Wednesday, April 17, 2002

I am a SQL Server guru......

For the last week I've been struggling with horrendous performance problems on our big production database. Today I rewrote a little Microsoft-supplied procedure. I just popped it onto the live server. Average CPU instantly drops from 70% going on 100% down to 20% or 30%. Blocking locks, which were running at 30 or 40 for the last week, have now dropped down to zero.

I am a GURU!

No comments: