I encountered the situation recently where I needed to find the size of the log file. When I tried to find the script by using Search@SQLAuthority.com I was not able to find the script at all.

Here is the script, if you remove the WHERE condition you will find the result for all the databases. SELECT DB_NAME ( database_id ) AS DatabaseName, Name AS Logical_Name, Physical_Name, ( size * 8 )/ 1024 SizeMB FROM sys.master_files WHERE DB_NAME ( database_id ) = 'AdventureWorks' GO Reference: Pinal Dave ( ). John Deere Backhoe Serial Number Location more.

Windows Server 2012 - Page File. In the case of SQL. For Windows 8.1 and Windows Server 2012 R2 the Minimum Paging File Size 'Depends on. 36 related questions. SQL Server max memory, page file, max degree parallelism. Up vote 13 down vote favorite. Is there a rule for the size of the page file on dedicated sql server. Recommended page file size for SQL 2008R2 on Windows 2008R2. Is for SQL Server 2008R2 running. Server with 64GB of RAM, is a pagefile necessary for.

Thank you Pinal! That’s very helpful – but if you have large initial file size configured for your database (which is best practice), your script actually shows the initial file size and not the actual size used by the database.

Can you shed light on how to get the actual disk space size of a database and not the disk space reserved for the database (because of the large initial file size)? There is the sp_spaceused command, the FILEPROPERTY(name, ‘SpaceUsed’) command – but they are very confusing.

Wish somebody can explain them Thank you so much again. Pinal Dave is a SQL Server Performance Tuning Expert and an independent consultant. He has authored 11 SQL Server database books, 21 Pluralsight courses and has written over 4000 articles on the database technology on his blog at a Along with 16+ years of hands on experience he holds a Masters of Science degree and a number of database certifications. For any send email at pinal@sqlauthority.com.

Pinal is also a and. Nupur Dave is a social media enthusiast and and an independent consultant.