Monthly Archives: September 2012

Quick tip: Querying database metadata with DBCC DBINFO

Page 9 in file 1 (of the primary filegroup) in a SQL Server database is the header page and contains a wealth of metadata about the database. We can have a look at this with DBCC PAGE or DBCC DBINFO. … Continue reading

Posted in Database options, SQL Server, T-SQL | Tagged , | 1 Comment

Quick tip: Using DBCC SQLPERF(‘LogSpace’)

A lot of a DBA’s time is spent managing and investigating transaction log files. A commonly used tool is the command: DBCC SQLPERF(‘LogSpace’) which returns a list of all databases, the size of their transaction log file, and the percentage … Continue reading

Posted in SQL Server, T-SQL | 2 Comments