Database | MDF File Location | LDF File Location |
master | C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\master.mdf | C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\mastlog.ldf |
tempdb | C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\tempdb.mdf | C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\templog.ldf |
tempdb | C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\tempdb_mssql_2.ndf | C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\templog.ldf |
tempdb | C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\tempdb_mssql_3.ndf | C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\templog.ldf |
tempdb | C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\tempdb_mssql_4.ndf | C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\templog.ldf |
model | C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\model.mdf | C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\modellog.ldf |
msdb | C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\MSDBData.mdf | C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\MSDBLog.ldf |
Database Name | Logical File Name | Physical File Name | File Size (MB) | Is Percent Growth? | Growth Increment Factor | Next Auto Growth Size (MB) | Max File Size |
master | master | C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\master.mdf | 4.44 | Yes | 10% | 0.44 | File will grow until the disk is full |
master | mastlog | C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\mastlog.ldf | 2.00 | Yes | 10% | 0.20 | File will grow until the disk is full |
tempdb | tempdev | C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\tempdb.mdf | 8.00 | No | 64 MB | 64.00 | File will grow until the disk is full |
tempdb | templog | C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\templog.ldf | 8.00 | No | 64 MB | 64.00 | File will grow until the disk is full |
tempdb | temp2 | C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\tempdb_mssql_2.ndf | 8.00 | No | 64 MB | 64.00 | File will grow until the disk is full |
tempdb | temp3 | C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\tempdb_mssql_3.ndf | 8.00 | No | 64 MB | 64.00 | File will grow until the disk is full |
tempdb | temp4 | C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\tempdb_mssql_4.ndf | 8.00 | No | 64 MB | 64.00 | File will grow until the disk is full |
model | modeldev | C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\model.mdf | 8.00 | No | 64 MB | 64.00 | File will grow until the disk is full |
model | modellog | C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\modellog.ldf | 8.00 | No | 64 MB | 64.00 | File will grow until the disk is full |
msdb | MSDBData | C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\MSDBData.mdf | 17.88 | Yes | 10% | 1.79 | File will grow until the disk is full |
msdb | MSDBLog | C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\MSDBLog.ldf | 19.63 | Yes | 10% | 1.96 | 268435456 |
SQLFleetRepo | SQLFleetRepo | C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\SQLFleetRepo.mdf | 72.00 | No | 64 MB | 64.00 | File will grow until the disk is full |
SQLFleetRepo | SQLFleetRepo_log | C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\SQLFleetRepo_log.ldf | 72.00 | No | 64 MB | 64.00 | 268435456 |
Database | Drive | Physical Location | ReadLatency | WriteLatency | Latency | AvgBPerRead | AvgBPerWrite | AvgBPerTransfer |
msdb | C: | C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\MSDBData.mdf | 0 | 5 | 1 | 9291 | 9557 | 9296 |
msdb | C: | C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\MSDBLog.ldf | 1 | 1 | 1 | 32542 | 3181 | 23978 |
tempdb | C: | C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\tempdb_mssql_2.ndf | 1 | 1 | 1 | 8192 | 8192 | 8192 |
tempdb | C: | C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\tempdb_mssql_3.ndf | 0 | 1 | 0 | 8192 | 8192 | 8192 |
tempdb | C: | C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\tempdb_mssql_4.ndf | 2 | 1 | 1 | 8192 | 8192 | 8192 |
master | C: | C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\mastlog.ldf | 5 | 1 | 2 | 11861 | 4406 | 6394 |
tempdb | C: | C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\tempdb.mdf | 0 | 1 | 0 | 8192 | 8192 | 8192 |
model | C: | C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\modellog.ldf | 1 | 1 | 1 | 112867 | 2921 | 40979 |
master | C: | C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\master.mdf | 3 | 0 | 2 | 8676 | 8192 | 8634 |
tempdb | C: | C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\templog.ldf | 0 | 0 | 0 | 143945 | 27867 | 66560 |
model | C: | C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\model.mdf | 1 | 0 | 1 | 285627 | 8192 | 241549 |
SQLFleetRepo | C: | C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\SQLFleetRepo.mdf | 0 | 0 | 0 | 9253 | 0 | 9253 |
SQLFleetRepo | C: | C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\SQLFleetRepo_log.ldf | 0 | 0 | 0 | 93090 | 3413 | 73874 |