Database |
ReadLatency |
WriteLatency |
Latency |
AvgBPerRead |
AvgBPerWrite |
AvgBPertransfer |
Drive |
Type |
Physical name |
---|
Testdb | 2 | 0 | 1 | 59603 | 8192 | 48487 | F: | ROWS | F:\MSSQL12.PROD\MSSQL\DATA\Testdb.mdf |
Testdb | 1 | 0 | 0 | 19456 | 3015 | 7125 | F: | LOG | F:\MSSQL12.PROD\MSSQL\DATA\Testdb_log.ldf |
Testdb | 2 | 0 | 2 | 32768 | 0 | 32768 | F: | ROWS | F:\MSSQL12.PROD\MSSQL\DATA\Testdb_02.ndf |
tempdb | 2 | 1 | 2 | 59517 | 8192 | 45728 | F: | ROWS | F:\MSSQL12.PROD\MSSQL\DATA\tempdb.mdf |
tempdb | 0 | 6 | 5 | 84650 | 32899 | 35149 | F: | LOG | F:\MSSQL12.PROD\MSSQL\DATA\templog.ldf |
t4 | 5 | 0 | 4 | 60914 | 8192 | 51940 | F: | ROWS | F:\MSSQL12.PROD\MSSQL\DATA\t4.mdf |
t4 | 1 | 0 | 0 | 4915 | 8192 | 6931 | F: | LOG | F:\MSSQL12.PROD\MSSQL\DATA\t4_log.ldf |
t4 | 2 | 0 | 2 | 58982 | 0 | 58982 | F: | ROWS | F:\MSSQL12.PROD\MSSQL\DATA\T4_2.ndf |
t4 | 1 | 0 | 0 | 3677 | 787 | 1646 | F: | LOG | F:\MSSQL12.PROD\MSSQL\DATA\T4_log2.ldn |
msdb | 6 | 0 | 5 | 61048 | 9420 | 50565 | F: | ROWS | F:\MSSQL12.PROD\MSSQL\DATA\MSDBData.mdf |
msdb | 2 | 3 | 3 | 34486 | 3128 | 11821 | F: | LOG | F:\MSSQL12.PROD\MSSQL\DATA\MSDBLog.ldf |
model | 4 | 0 | 3 | 63744 | 8192 | 60993 | F: | ROWS | F:\MSSQL12.PROD\MSSQL\DATA\model.mdf |
model | 4 | 3 | 3 | 55616 | 2787 | 19042 | F: | LOG | F:\MSSQL12.PROD\MSSQL\DATA\modellog.ldf |
master | 3 | 0 | 2 | 63811 | 8192 | 51620 | F: | ROWS | F:\MSSQL12.PROD\MSSQL\DATA\master.mdf |
master | 2 | 0 | 1 | 42338 | 2831 | 19950 | F: | LOG | F:\MSSQL12.PROD\MSSQL\DATA\mastlog.ldf |