Browse by Tags

  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...

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...

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...

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 how Soft...

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...

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...