Test Information

Company: Tieto
Date: Dec 2 2015 2:11PM
Type: Summary

Windows Server Information

ComputerNamePhysicalNetBIOS: WCNOD1
CPU_Count: 1
hyperthread_ratio: 1
IP address: 192.168.0.20
Local TCP port: 51460
physical_memory MB: 5040

SQL Server Information

ServerName: SQLHOST01\PROD
Edition: Enterprise Edition: Core-based
ProductVersion: 12.0.4100.1
ProductLevel: SP1
Collation: Finnish_Swedish_CI_AS
IsIntegratedSecurityOnly: Not Integrated Security
IsClustered: Clustered
Maximum size of server memory (MB): 1000
Minimum size of server memory (MB): 0
Enable compression of backups by default: Backup compression not enabled

SQL Server Backup Information

Database Name FromDateTime ToDateTime Backup Type Backup Size MB Compressed Backup Size MB Logical Device Name Physical Device Name
masterN/AN/ANo Backup00N/AN/A
modelN/AN/ANo Backup00N/AN/A
msdbN/AN/ANo Backup00N/AN/A
t4Nov 19 2015 3:41PMNov 19 2015 3:41PMDatabase4180650N/AF:\MSSQL12.PROD\MSSQL\Backup\T4_compressed.bak
tempdbN/AN/ANo Backup00N/AN/A
TestdbN/AN/ANo Backup00N/AN/A

Database Information

Database File File State Collation File Size Used Size Max Size Autoextend Recovery Model Compability level
mastermasterONLINEFinnish_Swedish_CI_AS5.383.81Unlimitied10 %SIMPLE120
mastermastlogONLINEFinnish_Swedish_CI_AS2.250.51Unlimitied10 %SIMPLE120
modelmodeldevONLINEFinnish_Swedish_CI_AS4.192.69Unlimitied1 MBFULL120
modelmodellogONLINEFinnish_Swedish_CI_AS1.000.38Unlimitied10 %FULL120
msdbMSDBDataONLINEFinnish_Swedish_CI_AS17.1316.69Unlimitied10 %SIMPLE120
msdbMSDBLogONLINEFinnish_Swedish_CI_AS9.941.69Unlimited10 %SIMPLE120
t4t4ONLINEFinnish_Swedish_CI_AS5.002.69Unlimitied1 MBFULL120
t4t4_logONLINEFinnish_Swedish_CI_AS1.000.78Unlimited10 %FULL120
t4T4_2ONLINEFinnish_Swedish_CI_AS500.000.19UnlimitiedDisabledFULL120
t4T4_log3ONLINEFinnish_Swedish_CI_AS1.000.78Unlimited10 %FULL120
tempdbtempdevONLINEFinnish_Swedish_CI_AS8.004.13Unlimitied10 %SIMPLE120
tempdbtemplogONLINEFinnish_Swedish_CI_AS0.500.56Unlimitied10 %SIMPLE120
TestdbTestdbONLINEFinnish_Swedish_CI_AS5.002.69Unlimitied1 MBFULL120
TestdbTestdb_logONLINEFinnish_Swedish_CI_AS1.000.73Unlimited10 %FULL120
TestdbTestdb_02ONLINEFinnish_Swedish_CI_AS5.000.06Unlimitied1 MBFULL120

Database Maintenance

Database LastStatisticsDate LastDBCCRunDate
masterNov 19 2015 3:47PMDec 2 2015 1:37PM
modelNov 19 2015 5:25PMDec 2 2015 1:37PM
msdbNov 19 2015 4:40PMDec 2 2015 1:37PM
t4Nov 19 2015 4:11PMDec 2 2015 1:52PM
tempdbDec 2 2015 2:11PMN/A
TestdbOct 6 2015 2:08PMDec 2 2015 1:39PM

SQL Server Alert Configuration

Job Name Description Email operator configured Eventlog operator configured Page operator configured Netsend operator configured
M01.Subplan_1No description available.NoYesNoNo
syspolicy_purge_historyNo description available.NoNoNoNo

Database File IO

Database ReadLatency WriteLatency Latency AvgBPerRead AvgBPerWrite AvgBPertransfer Drive Type Physical name
Testdb20159603819248487F:ROWSF:\MSSQL12.PROD\MSSQL\DATA\Testdb.mdf
Testdb1001945630157125F:LOGF:\MSSQL12.PROD\MSSQL\DATA\Testdb_log.ldf
Testdb20232768032768F:ROWSF:\MSSQL12.PROD\MSSQL\DATA\Testdb_02.ndf
tempdb21259517819245176F:ROWSF:\MSSQL12.PROD\MSSQL\DATA\tempdb.mdf
tempdb065846503284834977F:LOGF:\MSSQL12.PROD\MSSQL\DATA\templog.ldf
t450460914819251940F:ROWSF:\MSSQL12.PROD\MSSQL\DATA\t4.mdf
t4100491581926931F:LOGF:\MSSQL12.PROD\MSSQL\DATA\t4_log.ldf
t420258982058982F:ROWSF:\MSSQL12.PROD\MSSQL\DATA\T4_2.ndf
t410036777871646F:LOGF:\MSSQL12.PROD\MSSQL\DATA\T4_log2.ldn
msdb60561048942050565F:ROWSF:\MSSQL12.PROD\MSSQL\DATA\MSDBData.mdf
msdb23334486312811821F:LOGF:\MSSQL12.PROD\MSSQL\DATA\MSDBLog.ldf
model40363744819260993F:ROWSF:\MSSQL12.PROD\MSSQL\DATA\model.mdf
model43355616278719042F:LOGF:\MSSQL12.PROD\MSSQL\DATA\modellog.ldf
master30263811819251620F:ROWSF:\MSSQL12.PROD\MSSQL\DATA\master.mdf
master20142338283119950F:LOGF:\MSSQL12.PROD\MSSQL\DATA\mastlog.ldf