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:
Post a Comment