SQL SERVER STORAGE REVIEW

Report Generated on 21/05/2018 10:46

SQL Server Information



MachineNameInstanceNameServerTypeVersionEditionVersionNumberServicePackDatabases
SRVR-UNIVERSESRVR-UNIVERSESTANDALONEMicrosoft SQL Server 2016 (SP1) (KB3182545)Enterprise Edition: Core-based Licensing (64-bit)13.0.4001.0SP1 1.MASTER, 2.TEMPDB, 3.MODEL, 4.MSDB, 5.DB-Jupiter, 6.DB-Pluto, 7.DB-Monitor, 8.REPORTSERVER, 9.REPORTSERVERTEMPDB

Disk Space Status



HostnameDriveNameDiskSpace(GB)FreeSpace(GB)Free(%)
SRVR-UNIVERSEC:36929279
SRVR-UNIVERSEX:300099433
SRVR-UNIVERSEY:295998833

Storage Physical Properties



DriveNamePartitionNameFileSystemBlock SizeDisk Offset
C:Disk #0, Partition #2NTFS40962782208
X:Disk #1, Partition #0NTFS65536132096
Y:Disk #1, Partition #1NTFS655363145860096

System Databases File Location



DatabaseMDF File LocationLDF File Location
masterC:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\master.mdfC:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\mastlog.ldf
tempdbY:\MSSQL11.MSSQLSERVER\MSSQL\Data\tempdb.mdfY:\MSSQL11.MSSQLSERVER\MSSQL\Logs\templog.ldf
tempdbY:\MSSQL11.MSSQLSERVER\MSSQL\DATA\tempdb_1.ndfY:\MSSQL11.MSSQLSERVER\MSSQL\Logs\templog.ldf
tempdbY:\MSSQL11.MSSQLSERVER\MSSQL\DATA\tempdb_2.ndfY:\MSSQL11.MSSQLSERVER\MSSQL\Logs\templog.ldf
tempdbY:\MSSQL11.MSSQLSERVER\MSSQL\DATA\tempdb_3.ndfY:\MSSQL11.MSSQLSERVER\MSSQL\Logs\templog.ldf
tempdbY:\MSSQL11.MSSQLSERVER\MSSQL\DATA\tempdb_4.ndfY:\MSSQL11.MSSQLSERVER\MSSQL\Logs\templog.ldf
tempdbY:\MSSQL11.MSSQLSERVER\MSSQL\DATA\tempdb_5.ndfY:\MSSQL11.MSSQLSERVER\MSSQL\Logs\templog.ldf
tempdbY:\MSSQL11.MSSQLSERVER\MSSQL\DATA\tempdb_6.ndfY:\MSSQL11.MSSQLSERVER\MSSQL\Logs\templog.ldf
tempdbY:\MSSQL11.MSSQLSERVER\MSSQL\DATA\tempdb_7.ndfY:\MSSQL11.MSSQLSERVER\MSSQL\Logs\templog.ldf
modelC:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\model.mdfC:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\modellog.ldf
msdbC:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\MSDBData.mdfC:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\MSDBLog.ldf

Database Default Locations



Database File Default Location Log File Default Location
X:\MSSQL11.MSSQLSERVER\MSSQL\Data\Y:\MSSQL11.MSSQLSERVER\MSSQL\Logs\

User Database(s) File Location



DatabaseMDF File LocationLDF File Location
DB-JupiterX:\MSSQL11.MSSQLSERVER\MSSQL\Data\DB-Jupiter.mdfY:\MSSQL11.MSSQLSERVER\MSSQL\Logs\DB-Jupiter.ldf
DB-JupiterY:\MSSQL11.MSSQLSERVER\MSSQL\Data\DB-JupiterIndex.ndfY:\MSSQL11.MSSQLSERVER\MSSQL\Logs\DB-Jupiter.ldf
DB-JupiterY:\MSSQL11.MSSQLSERVER\MSSQL\Data\DB-Jupiter2.ndfY:\MSSQL11.MSSQLSERVER\MSSQL\Logs\DB-Jupiter.ldf
DB-PlutoX:\MSSQL11.MSSQLSERVER\MSSQL\Data\DB-Pluto.mdfY:\MSSQL11.MSSQLSERVER\MSSQL\Logs\DB-Pluto_log.ldf
DB-MonitorX:\MSSQL11.MSSQLSERVER\MSSQL\Data\DB-Monitor.mdfY:\MSSQL11.MSSQLSERVER\MSSQL\Logs\DB-Monitor.ldf
ReportServerX:\MSSQL11.MSSQLSERVER\MSSQL\Data\ReportServer.mdfY:\MSSQL11.MSSQLSERVER\MSSQL\Logs\ReportServer_log.ldf
ReportServerTempDBX:\MSSQL11.MSSQLSERVER\MSSQL\Data\ReportServerTempDB.mdfY:\MSSQL11.MSSQLSERVER\MSSQL\Logs\ReportServerTempDB_log.ldf

Database Auto-Growth Stats



Database NameLogical File NamePhysical File NameFile Size (MB)Is Percent Growth?Growth Increment FactorNext Auto Growth Size (MB)Max File Size
mastermasterC:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\master.mdf4.88Yes10%0.49File will grow until the disk is full
mastermastlogC:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\mastlog.ldf2.00Yes10%0.20File will grow until the disk is full
tempdbtempdevY:\MSSQL11.MSSQLSERVER\MSSQL\Data\tempdb.mdf9435.31No10 MB10.00File will grow until the disk is full
tempdbtemplogY:\MSSQL11.MSSQLSERVER\MSSQL\Logs\templog.ldf0.50No10 MB10.00File will grow until the disk is full
tempdbtempdev1Y:\MSSQL11.MSSQLSERVER\MSSQL\DATA\tempdb_1.ndf4096.00No10 MB10.00File will grow until the disk is full
tempdbtempdev2Y:\MSSQL11.MSSQLSERVER\MSSQL\DATA\tempdb_2.ndf4096.00No10 MB10.00File will grow until the disk is full
tempdbtempdev3Y:\MSSQL11.MSSQLSERVER\MSSQL\DATA\tempdb_3.ndf4096.00No10 MB10.00File will grow until the disk is full
tempdbtempdev4Y:\MSSQL11.MSSQLSERVER\MSSQL\DATA\tempdb_4.ndf4096.00No10 MB10.00File will grow until the disk is full
tempdbtempdev5Y:\MSSQL11.MSSQLSERVER\MSSQL\DATA\tempdb_5.ndf4096.00No10 MB10.00File will grow until the disk is full
tempdbtempdev6Y:\MSSQL11.MSSQLSERVER\MSSQL\DATA\tempdb_6.ndf4096.00No10 MB10.00File will grow until the disk is full
tempdbtempdev7Y:\MSSQL11.MSSQLSERVER\MSSQL\DATA\tempdb_7.ndf4096.00No10 MB10.00File will grow until the disk is full
modelmodeldevC:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\model.mdf4.06No1 MB1.00File will grow until the disk is full
modelmodellogC:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\modellog.ldf2.00Yes10%0.20File will grow until the disk is full
msdbMSDBDataC:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\MSDBData.mdf94.00Yes10%9.40File will grow until the disk is full
msdbMSDBLogC:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\MSDBLog.ldf214.13Yes10%21.41268435456
DB-JupiterDB-JupiterX:\MSSQL11.MSSQLSERVER\MSSQL\Data\DB-Jupiter.mdf2048.00No0 MB0.00File will grow until the disk is full
DB-JupiterDB-Jupiter_logY:\MSSQL11.MSSQLSERVER\MSSQL\Logs\DB-Jupiter.ldf2048.00No10240 MB10240.00268435456
DB-JupiterPlanetsIndexY:\MSSQL11.MSSQLSERVER\MSSQL\Data\DB-JupiterIndex.ndf204800.00No0 MB0.00File will grow until the disk is full
DB-JupiterDB-Jupiter2Y:\MSSQL11.MSSQLSERVER\MSSQL\Data\DB-Jupiter2.ndf665600.00No0 MB0.00File will grow until the disk is full
DB-PlutoDB-PlutoX:\MSSQL11.MSSQLSERVER\MSSQL\Data\DB-Pluto.mdf6144.00No0 MB0.00File will grow until the disk is full
DB-PlutoDB-Pluto_logY:\MSSQL11.MSSQLSERVER\MSSQL\Logs\DB-Pluto_log.ldf4224.00No0 MB0.00268435456
DB-MonitorDB-Monitor_datX:\MSSQL11.MSSQLSERVER\MSSQL\Data\DB-Monitor.mdf10.00No5 MB5.007040
DB-MonitorDB-Monitor_logY:\MSSQL11.MSSQLSERVER\MSSQL\Logs\DB-Monitor.ldf3.00No5 MB5.003200
ReportServerReportServerX:\MSSQL11.MSSQLSERVER\MSSQL\Data\ReportServer.mdf7.06No1 MB1.00File will grow until the disk is full
ReportServerReportServer_logY:\MSSQL11.MSSQLSERVER\MSSQL\Logs\ReportServer_log.ldf9.19Yes10%0.92268435456
ReportServerTempDBReportServerTempDBX:\MSSQL11.MSSQLSERVER\MSSQL\Data\ReportServerTempDB.mdf4.06No1 MB1.00File will grow until the disk is full
ReportServerTempDBReportServerTempDB_logY:\MSSQL11.MSSQLSERVER\MSSQL\Logs\ReportServerTempDB_log.ldf2.06Yes10%0.21268435456

Database File IO Latency



DatabaseDrivePhysical LocationReadLatencyWriteLatencyLatencyAvgBPerReadAvgBPerWriteAvgBPerTransfer
DB-JupiterX:X:\MSSQL11.MSSQLSERVER\MSSQL\Data\DB-Jupiter.mdf03613540472811044928
DB-JupiterY:Y:\MSSQL11.MSSQLSERVER\MSSQL\Data\DB-JupiterIndex.ndf01981093371426669898
DB-JupiterY:Y:\MSSQL11.MSSQLSERVER\MSSQL\Data\DB-Jupiter2.ndf11866841359514501576
tempdbY:Y:\MSSQL11.MSSQLSERVER\MSSQL\DATA\tempdb_1.ndf043278261313816589
tempdbY:Y:\MSSQL11.MSSQLSERVER\MSSQL\DATA\tempdb_5.ndf032285671307616564
tempdbY:Y:\MSSQL11.MSSQLSERVER\MSSQL\DATA\tempdb_6.ndf022286271321516589
tempdbY:Y:\MSSQL11.MSSQLSERVER\MSSQL\DATA\tempdb_7.ndf022282061309016472
DB-PlutoX:X:\MSSQL11.MSSQLSERVER\MSSQL\Data\DB-Pluto.mdf020467291160940636
tempdbY:Y:\MSSQL11.MSSQLSERVER\MSSQL\DATA\tempdb_2.ndf022296201318816702
tempdbY:Y:\MSSQL11.MSSQLSERVER\MSSQL\DATA\tempdb_3.ndf022274761306016384
tempdbY:Y:\MSSQL11.MSSQLSERVER\MSSQL\DATA\tempdb_4.ndf021259351330916491
tempdbY:Y:\MSSQL11.MSSQLSERVER\MSSQL\Data\tempdb.mdf022234141285816605
ReportServerX:X:\MSSQL11.MSSQLSERVER\MSSQL\Data\ReportServer.mdf01031209975428467
ReportServerY:Y:\MSSQL11.MSSQLSERVER\MSSQL\Logs\ReportServer_log.ldf0002192843864562
ReportServerTempDBX:X:\MSSQL11.MSSQLSERVER\MSSQL\Data\ReportServerTempDB.mdf00030270851527280
ReportServerTempDBY:Y:\MSSQL11.MSSQLSERVER\MSSQL\Logs\ReportServerTempDB_log.ldf0002081245044756
DB-JupiterY:Y:\MSSQL11.MSSQLSERVER\MSSQL\Logs\DB-Jupiter.ldf000333492650428781
tempdbY:Y:\MSSQL11.MSSQLSERVER\MSSQL\Logs\templog.ldf000183385727456958
masterC:C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\master.mdf00034541866111963
masterC:C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\mastlog.ldf0003185742254228
DB-PlutoY:Y:\MSSQL11.MSSQLSERVER\MSSQL\Logs\DB-Pluto_log.ldf0004199444524559
DB-MonitorX:X:\MSSQL11.MSSQLSERVER\MSSQL\Data\DB-Monitor.mdf000394921028529263
DB-MonitorY:Y:\MSSQL11.MSSQLSERVER\MSSQL\Logs\DB-Monitor.ldf0003575862796589
modelC:C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\model.mdf00048334819242151
modelC:C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\modellog.ldf0001251554735833
msdbC:C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\MSDBData.mdf00045100974438421
msdbC:C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\MSDBLog.ldf0001337558596100

Check Database VLF Count



Database NameVLF Count
DB-Jupiter166
DB-Monitor4
DB-Pluto26
master8
model8
msdb163
ReportServer32
ReportServerTempDB8
tempdb6

Check Last Run DBCC CHECKDB



DatabaseNameLastKnownGoodDateLastRun
master2018-05-21 01:30:03.650Less then 1 Week ago
tempdbNeverNever
model2018-05-21 01:30:07.220Less then 1 Week ago
msdb2018-05-21 01:30:10.693Less then 1 Week ago
DB-Jupiter2017-09-03 01:00:38.310Less then 1 Week ago
DB-Pluto2018-05-21 01:45:06.323Less then 1 Week ago
DB-Monitor2018-05-21 01:45:02.963Less then 1 Week ago
ReportServer2018-05-21 01:45:09.803Less then 1 Week ago
ReportServerTempDB2018-05-21 01:45:13.267Less then 1 Week ago


END OF REPORT