SQL Server 2012: Always On FAQs

As Always On is a new feature and many DBAs and Infrastructure teams have several questions regrading this solution, I thought of writing a blog post with one line answers for some of the most common FAQs on Always On solution. I will be adding more questions as we go. I have collected this information…

11

SQL Server Statistics: Explained

Several DBA’s asked me these questions about SQL Server statistics at different customer places. a)      Should we disable Auto update stats for the database and run maintenance plans instead? b)      What sampling rate does Auto Stats use? Can we control it? c)       Should we update statistics after rebuilding indexes during maintenance plans?   Here is…

8

SQL Server Scheduling Flowchart

  This is a basic flowchart explaining SQL Server Scheduling at a very high level.     References: Book: Professional SQL Server 2008 Internals and Troubleshooting Book: Microsoft® SQL Server® 2008 Internals Articles on www.sqlskills.com

0

Failure sending mail: Retrieving the COM class factory for component with CLSID {CD000001-8B95-11D1-82DB-00C04FB1625D} failed due to the following error: 8007007e. Mail will not be resent.

Have you been seeing this error on your SSRS Subscriptions page. Failure sending mail: Retrieving the COM class factory for component with CLSID {CD000001-8B95-11D1-82DB-00C04FB1625D} failed due to the following error: 8007007e. Mail will not be resent.   This generally occurs when you have missing DLL files which are required to send an email. So how…

0

SQL 2008 Cluster Install Errors :KB953748

In case you are getting cluster validation errors while installing SQL 2008 on Windows Cluster and you see the following message   Please follow these directions to troubleshoot the problem: 1) Download Procmon from sysinternals http://technet.microsoft.com/en-us/sysinternals/bb896645 2) Setup filters in Procmon to include processname as “setup100.exe”  3) Now,Go to the installation screen and Click on…

1