1.http://www.sqlhacks.com/Optimize/Optimize
例子 :
1)Tempdb usage
-
SELECT CAST ( DB_NAME ( mstr. database_id ) AS VARCHAR ( 24 ) ) AS 'Database' ,
-
CAST ( mstr. physical_name AS VARCHAR ( 72 ) ) AS 'File' ,
-
stats. num_of_reads ,
-
stats. num_of_bytes_read ,
-
stats. num_of_writes ,
-
stats. num_of_bytes_written ,
-
stats. size_on_disk_bytes
-
FROM sys. dm_io_virtual_file_stats ( null,null ) AS stats
-
join sys. master_files AS mstr
-
ON mstr. database_id = stats. database_id
-
and mstr. FILE_ID = stats. FILE_ID
-
WHERE DB_NAME ( mstr. database_id ) = 'tempdb' or
-
DB_NAME ( mstr. database_id ) = 'sql911' ;
-
go
2.http://support.microsoft.com/kb/907877/zh-cn
3.http://msdn.microsoft.com/en-us/library/cc966540.aspx#EGAA