Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: March 2012

Debugging query timeouts by sampling blocking – part 2

In part 1 I explained how I was hunting for the root cause for some query timeouts that happened every once in a while. I knew for certain, that the affected queries were waiting for 30 seconds for an intent exclusive lock on something, before a timeout occurs.

Our good… Read more

7 comments, 1,701 reads

Posted in SQL Server Notes from the Field on 15 March 2012

Debugging query timeouts with X-Events – part 1

I like hunting. Not the kind where you are walking around the forrest and trying to find a target. No, I like hunting for SQL queries that are messy, or down right nasty. My latest hunting adventure was to find the root cause for intermittent query timeouts, that could happen… Read more

0 comments, 828 reads

Posted in SQL Server Notes from the Field on 10 March 2012

How to use Change Data Capture (CDC)

With SQL Server 2008 Microsoft added the CDC feature to SQL Server enterprise edition. I haven’t come to play around with it before, but the other day I was asked if CDC might be used for a specific purpose. Because I had no previous experience using CDC, I had to… Read more

0 comments, 2,692 reads

Posted in SQL Server Notes from the Field on 5 March 2012