Database Name | FromDateTime | ToDateTime | Backup Type | Backup Size MB | Compressed Backup Size MB | Logical Device Name | Physical Device Name | ||
---|---|---|---|---|---|---|---|---|---|
master | N/A | N/A | No Backup | 0 | 0 | N/A | N/A | ||
model | N/A | N/A | No Backup | 0 | 0 | N/A | N/A | ||
msdb | N/A | N/A | No Backup | 0 | 0 | N/A | N/A | ||
t4 | Nov 19 2015 3:41PM | Nov 19 2015 3:41PM | Database | 4180 | 650 | N/A | F:\MSSQL12.PROD\MSSQL\Backup\T4_compressed.bak | ||
tempdb | N/A | N/A | No Backup | 0 | 0 | N/A | N/A | ||
Testdb | N/A | N/A | No Backup | 0 | 0 | N/A | N/A |
Database | File | File State | Collation | File Size | Used Size | Max Size | Autoextend | Recovery Model | Compability level |
---|---|---|---|---|---|---|---|---|---|
master | master | ONLINE | Finnish_Swedish_CI_AS | 5.38 | 3.81 | Unlimitied | 10 % | SIMPLE | 120 |
master | mastlog | ONLINE | Finnish_Swedish_CI_AS | 2.25 | 0.51 | Unlimitied | 10 % | SIMPLE | 120 |
model | modeldev | ONLINE | Finnish_Swedish_CI_AS | 4.19 | 2.69 | Unlimitied | 1 MB | FULL | 120 |
model | modellog | ONLINE | Finnish_Swedish_CI_AS | 1.00 | 0.38 | Unlimitied | 10 % | FULL | 120 |
msdb | MSDBData | ONLINE | Finnish_Swedish_CI_AS | 17.13 | 16.69 | Unlimitied | 10 % | SIMPLE | 120 |
msdb | MSDBLog | ONLINE | Finnish_Swedish_CI_AS | 9.94 | 1.69 | Unlimited | 10 % | SIMPLE | 120 |
t4 | t4 | ONLINE | Finnish_Swedish_CI_AS | 5.00 | 2.69 | Unlimitied | 1 MB | FULL | 120 |
t4 | t4_log | ONLINE | Finnish_Swedish_CI_AS | 1.00 | 0.78 | Unlimited | 10 % | FULL | 120 |
t4 | T4_2 | ONLINE | Finnish_Swedish_CI_AS | 500.00 | 0.19 | Unlimitied | Disabled | FULL | 120 |
t4 | T4_log3 | ONLINE | Finnish_Swedish_CI_AS | 1.00 | 0.78 | Unlimited | 10 % | FULL | 120 |
tempdb | tempdev | ONLINE | Finnish_Swedish_CI_AS | 8.00 | 4.13 | Unlimitied | 10 % | SIMPLE | 120 |
tempdb | templog | ONLINE | Finnish_Swedish_CI_AS | 0.50 | 0.56 | Unlimitied | 10 % | SIMPLE | 120 |
Testdb | Testdb | ONLINE | Finnish_Swedish_CI_AS | 5.00 | 2.69 | Unlimitied | 1 MB | FULL | 120 |
Testdb | Testdb_log | ONLINE | Finnish_Swedish_CI_AS | 1.00 | 0.73 | Unlimited | 10 % | FULL | 120 |
Testdb | Testdb_02 | ONLINE | Finnish_Swedish_CI_AS | 5.00 | 0.06 | Unlimitied | 1 MB | FULL | 120 |
Database | LastStatisticsDate | LastDBCCRunDate | |||||||
---|---|---|---|---|---|---|---|---|---|
master | Nov 19 2015 3:47PM | Dec 2 2015 1:37PM | |||||||
model | Nov 19 2015 5:25PM | Dec 2 2015 1:37PM | |||||||
msdb | Nov 19 2015 4:40PM | Dec 2 2015 1:37PM | |||||||
t4 | Nov 19 2015 4:11PM | Dec 2 2015 1:52PM | |||||||
tempdb | Dec 2 2015 2:11PM | N/A | |||||||
Testdb | Oct 6 2015 2:08PM | Dec 2 2015 1:39PM |
Job Name | Description | Email operator configured | Eventlog operator configured | Page operator configured | Netsend operator configured | ||||
---|---|---|---|---|---|---|---|---|---|
M01.Subplan_1 | No description available. | No | Yes | No | No | ||||
syspolicy_purge_history | No description available. | No | No | No | No |
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 | 45176 | F: | ROWS | F:\MSSQL12.PROD\MSSQL\DATA\tempdb.mdf |
tempdb | 0 | 6 | 5 | 84650 | 32848 | 34977 | 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 |