December 4, 2002 at 3:03 pm
My SQL Server 7 is running like a race car 30% avg CPU utilization on each of the 4 processors.
I cycle SQL Server and performance takes a dump (70-80%)and doesn't come back (16 hrs) until a job that runs dbcc reindex and update stats on each database takes place.
We run the reindex and update stats daily at 2:00am the database had to be cycled at 10am at which point we saw the database performance slump until the jobs kicked in again that following morning.
Any thoughts?
John Zacharkan
John Zacharkan
December 4, 2002 at 3:12 pm
Sounds like you're due a vist from a consultant with his Swiss Army diagnostic tool kit.
Do you have any jobs running in SQL Agent that might be looping?
Tables growing?
Viruses?
Are you also running your SQL Server box as PDC or BDC? STOP! if so.
December 4, 2002 at 3:20 pm
ANother thing to consider is how you queries are executed. If most are straight queries and not part of Stored Procedures then when you cycle the box you clear the buffer cache, the execution plans and several other items that help speed the box up over time. You may have an IO bottleneck somewhere such as amount of RAM or speed of Harddrives.
December 4, 2002 at 4:28 pm
I've seen this situation in high transaction databases where the indexes were insufficient, and statistics went out of date quickly (due to the high amount of inserts/deletes), and we had to evaluate the indexes and create the appropriate ones for the app. We were also able to pinpoint a couple of tables as causing the performance slump by profiling, and performed additional update statistics on those particular tables at intervals during the day.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply