所有資料庫資訊匯入

SELECT DB_NAME(mf.database_id) AS databaseName ,
 mf.physical_name ,
 divfs.num_of_reads ,
 --other columns removed in this section. See Listing 6.14 for complete code
 GETDATE() AS baselineDate
INTO #baseline
FROM sys.dm_io_virtual_file_stats(NULL, NULL) AS divfs
 JOIN sys.master_files AS mf ON mf.database_id = divfs.database_id
 AND mf.file_id = divfs.file_id