Instance Pre-Installation Checklist

You have been requested to provide an SQL Server environment to host the database/s of Application123. Once you’ve identified the server onto which the instance will be installed there are a number of checks I would suggest, or at least these are the ones I follow. You will observe that... [Read More]

Configuring the SCOM 2012 SQL Server Management Pack for Low-Privilege Access

The System Center Operations Manager 2012 is Microsoft’s flagship product to monitor various aspects of the infrastructure.  Specific details about the product can be found in the TechNet at http://technet.microsoft.com/en-us/library/hh205987.aspx.  Monitoring can be “extended” to SQL Server instances (2005 and later versions only) using the System Center Monitoring pack for... [Read More]

Percent Complete and Estimated Completion Time for Backup Processes

The more I learn about SQL Server the more I realise how little I know.  While delving in the output of some DMVs I noticed that the sys.dm_exec_requests can be used to find the percentage completed for a backup operation, as well as the estimated time of completion. [Read More]

Table Counts plus Space Used by Data and Indexes

I was recently reviewing some of the Dynamic Management Views (DMVs) available since SQL Server 2005 and came across the interesting and useful sys.dm_db_partition_stats DMV.  The documentation states that this DMV will return “page and row-count information for every partition in the current database”.  In the Space Used by Filegroup... [Read More]