SQL SERVER STORAGE REVIEW

Report Generated on 8/28/2021 11:55 AM

SQL Server Information



MachineNameInstanceNameServerTypeVersionEditionVersionNumberServicePackDatabases
EC2AMAZ-PDG972BEC2AMAZ-PDG972BSTANDALONEMicrosoft SQL Server 2019 (RTM-CU10) (KB5001090)Standard Edition (64-bit)15.0.4123.1RTM 1.MASTER, 2.TEMPDB, 3.MODEL, 4.MSDB, 5.SQLFLEETREPO

Disk Space Status



HostnameDriveNameDiskSpace(GB)FreeSpace(GB)Free(%)
EC2AMAZ-PDG972BC:653046

Storage Physical Properties



DriveNamePartitionNameFileSystemBlock SizeDisk Offset
C:Disk #0, Partition #0NTFS40961024

System Databases File Location



DatabaseMDF File LocationLDF File Location
masterC:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\master.mdfC:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\mastlog.ldf
tempdbC:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\tempdb.mdfC:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\templog.ldf
tempdbC:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\tempdb_mssql_2.ndfC:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\templog.ldf
tempdbC:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\tempdb_mssql_3.ndfC:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\templog.ldf
tempdbC:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\tempdb_mssql_4.ndfC:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\templog.ldf
modelC:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\model.mdfC:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\modellog.ldf
msdbC:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\MSDBData.mdfC:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\MSDBLog.ldf

Database Default Locations



Database File Default Location Log File Default Location
C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\

User Database(s) File Location



DatabaseMDF File LocationLDF File Location
SQLFleetRepoC:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\SQLFleetRepo.mdfC:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\SQLFleetRepo_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\MSSQL15.MSSQLSERVER\MSSQL\DATA\master.mdf4.44Yes10%0.44File will grow until the disk is full
mastermastlogC:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\mastlog.ldf2.00Yes10%0.20File will grow until the disk is full
tempdbtempdevC:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\tempdb.mdf8.00No64 MB64.00File will grow until the disk is full
tempdbtemplogC:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\templog.ldf8.00No64 MB64.00File will grow until the disk is full
tempdbtemp2C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\tempdb_mssql_2.ndf8.00No64 MB64.00File will grow until the disk is full
tempdbtemp3C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\tempdb_mssql_3.ndf8.00No64 MB64.00File will grow until the disk is full
tempdbtemp4C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\tempdb_mssql_4.ndf8.00No64 MB64.00File will grow until the disk is full
modelmodeldevC:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\model.mdf8.00No64 MB64.00File will grow until the disk is full
modelmodellogC:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\modellog.ldf8.00No64 MB64.00File will grow until the disk is full
msdbMSDBDataC:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\MSDBData.mdf17.88Yes10%1.79File will grow until the disk is full
msdbMSDBLogC:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\MSDBLog.ldf19.63Yes10%1.96268435456
SQLFleetRepoSQLFleetRepoC:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\SQLFleetRepo.mdf72.00No64 MB64.00File will grow until the disk is full
SQLFleetRepoSQLFleetRepo_logC:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\SQLFleetRepo_log.ldf72.00No64 MB64.00268435456

Database File IO Latency



DatabaseDrivePhysical LocationReadLatencyWriteLatencyLatencyAvgBPerReadAvgBPerWriteAvgBPerTransfer
msdbC:C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\MSDBData.mdf051929195579296
msdbC:C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\MSDBLog.ldf11132542318123978
tempdbC:C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\tempdb_mssql_2.ndf111819281928192
tempdbC:C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\tempdb_mssql_3.ndf010819281928192
tempdbC:C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\tempdb_mssql_4.ndf211819281928192
masterC:C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\mastlog.ldf5121186144066394
tempdbC:C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\tempdb.mdf010819281928192
modelC:C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\modellog.ldf111112867292140979
masterC:C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\master.mdf302867681928634
tempdbC:C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\templog.ldf0001439452786766560
modelC:C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\model.mdf1012856278192241549
SQLFleetRepoC:C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\SQLFleetRepo.mdf000925309253
SQLFleetRepoC:C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\SQLFleetRepo_log.ldf00093090341373874

Check Database VLF Count



Database NameVLF Count
master8
model6
msdb31
SQLFleetRepo8
tempdb4

Check Last Run DBCC CHECKDB



DatabaseNameLastKnownGoodDateLastRun
masterNeverNever
tempdbNeverNever
modelNeverNever
msdbNeverNever
SQLFleetRepoNeverNever


END OF REPORT