#sys.master_files

T-SQL: Find the location of data and log files of the databases within a SQL Server instance.

Hi Friends,

Hope, you are doing fine!

Today, please find below the T-SQL script tip to find the location of the data & log files available within a SQL Server instance. The script is as below:

T-SQL:

SELECT name AS NameOfFile, physical_name AS FileLocation FROM sys.master_files

Snapshot:

Happy Coding :)

Query SQL Server Database File I/O Statistics

A SQL Server instance with one database (or hundreds) often has its database files spread across multiple physical drives to help with the read/write performance. However, as more and more databases are added to the server, the read/write activity among the drives can become unbalanced and slower than acceptable. One drive could be taking a heavier workload than others and become the performance…