Welcome to MSDN Blogs Sign in | Join | Help

June 2008 - Posts

SQL Server Performance Assessment – What are my top 20 expensive batches

Previously here , I discussed the nature of collecting data when you are experiencing a SQL Server performance problem. A performance problem sometimes intimidates people as they are not sure where to start. This post details one of my preferred ways
Posted by grahamk | 1 Comments
Attachment(s): top20batches.sql

SQL Server Assertions and Dumps – a typical example and some proactive help

I recently worked with a customer who was seeing the following error in their error log: SQL Server Assertion: File: <qxcntxt.cpp>, line=1069 Failed Assertion = 'cref == 0' Could not find an entry for table or index with partition ID 491897996509184
Posted by grahamk | 0 Comments
 
Page view tracker