June 12, 2003 at 11:46 am
Exactly at midnight 12am, my processor time becomes 99.98, then it becomes stable around 50. I have 2 processors. Through another monitoring tool, we found p1 takes 35% and P2 takes 70% at midnight. My Processor queue length is mostly 2 or 3 somtimes 6.
Memory Pages/Sec is around 30 at midnight and less than 1 most of the time. Is there a paremeter I need to set to even out the processors? My cache hit ratio is always 99%.
Recently I found the virtual memory was too low and increased to 1.5times of ram. I though I did everything, I could. Will reindexing help(not done in a longtime). It is a 500meg db, with lots of deletes and inserts, and updates aswell. I have 2gb ram.
Your suggestions are appreciated. thanks.
June 12, 2003 at 11:58 am
How long the high CPU usage lasts? Any jobs/programs scheduled to start at 12:00AM?
June 12, 2003 at 12:06 pm
Around 30 seconds. But overall, the cpu utilization is high on processor 2 & together. After VM increase, the spike came down from high 90s to 70s.
I have one report starts at midnight and runs for 25 minutes, which has cursors and recursion in it. I know this is one of the culprits and I moved all other update jobs out of this window. There is a transaction log dump job also starts at 12AM, which finishes within a minute.
This is a dedicated machine for sql2k, and can I select the option 'Boost SQL server priority on windows' and is 256 threads enough?
June 12, 2003 at 1:06 pm
I wouldn't concern about it because it lasts only about 30 seconds. I think the high CPUs usage may caused by your report.
If you don't have large number user connection, I would leave max worker threads Option as default and you may not able to see performance improvement by enabling priority boost Option.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply