Change Data Capture gets disabled when you break mirroring and bring the database online

  Issue ================   Recently we encountered an issue where customer performed a planned failover for a mirrored database and after the failover the new principal went into suspect mode because of some reason (which is outside the scope of this blog) and was not accessible. The database which was mirrored had CDC(Change Data Capture)…


How to monitor deadlock using extended events in SQL Server 2008 and later

Before I talk about how to monitor the deadlocks let us have a small brief what is deadlock and how we were handling them in the previous versions of SQL Server.   Deadlock: A deadlock occurs when there is a cyclic dependency between two or more threads, or processes, for some set of resources within…

9

Upgrade from SQL Server 2008 to SQL Server 2008 R2 might fail with the error “Wait on the Database Engine Recovery Handle Failed”

PROBLEM DESCRIPTION ================ ·         During upgrade from SQL Server 2008 to SQL Server 2008 R2 we might encounter an error as shown below Wait on the Database Engine Recovery Handle Failed. Check the SQL Server error log for potential causes.   ·         The following KB article talks about a similar error but the cause for…

3

How to set Soft-NUMA for SQL Server 2008 R2

This is probably one of the murky topics of SQL Server. Add to this equation, hardware NUMA and the CPU Mask values can be a tough one to determine. Books Online has an article on how to configure Soft-NUMA for a SQL Server 2008 R2 instance. Rob Dorr has an excellent blog post which explains…


SQL Server 2008 R2 setup fails on Windows 7 with the error: Version’s parameters must be greater than or equal to zero

Symptom:   While installing SQL Server 2008 R2 RTM in a Windows 7 box, noticed an error message:   SQL Server Setup has encountered the following error: Version’s parameters must be greater than or equal to zero.   This error occurs after Setup Support Files are installed and then setup is trying to gather existing…


SQL Server 2008 & SQL Server 2008 R2 clustering FAQ’s:

1.       Can I use SQL 2008 slipstreamed installer to install SQL Server 2008 failover cluster? Yes. Launch the setup.exe from command prompt with PCUSource = <path to extracted SP1>. Refer http://blogs.msdn.com/petersad/archive/2009/03/02/sql-server-2008-basic-slipstream-steps.aspx for additional information. You can use merged slipstream installer for SQL 2008 cluster installation.   2.       If I install failover cluster using slipstream, do…