March 2009 - Posts

• Lies, Damned Lies And Statistics – Part I

  One of the biggest call generators at Microsoft SQL Server Support when SQL Server 7.0 was released was issues with statistics. In the beginning, they tended to be about the Autoupdate statistics feature interfering with user activity but when SQL Server Read More... Posted Sunday, March 01, 2009 11:51 PM by Elisabeth Redei | 21 Comments Filed under: autoupdate statistics, performance, statistics, UPDATE STATISTICS Attachment(s): CheckSampleRate.zip

• Bufferpool Performance Counters

  Technorati Tags: bufferpool , performance monitor counters , memory Memory configuration and investigating memory conditions is still something that seems to cause a lot of confusion. There are numerous articles, blog posts etc. that talk about SQL Server Read More... Posted Sunday, March 01, 2009 11:36 PM by Elisabeth Redei | 2 Comments

• How To Get High Quality Information About Query Performance

  There are a zillion reasons why Profiler and its friends by far are the most potent tuning tools available for SQL Server DBAs. This post focuses on one of them but I will mention a few others at the end as well (download details for the tools mentioned Read More... Posted Sunday, March 01, 2009 10:52 PM by Elisabeth Redei | 13 Comments Filed under: Profiler, Performance Data, Reporter, SQLNexus