var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: What is causing SQL7 high CPU usage
As a novice sql administrator, I am having troubles identifying what is causing the mssql 7 service to use >99% CPU usage.
It is happening on a semi-regular basis, where it skyrockets from anywhere between 10+ minutes to a couple of hours. Since it goes up and down, I don't think it is due to a software bug.
May I know what sort of steps I can take to determine the user, database, sql procedure/statement that could be causing the problem?
Thanks for any advice.
The best bet to use PERFMON provided from Windows, and gather counters for PRocess, Processor, Memory, Physical disk, sql serve related. Refer to this
link for PERFMON tips and tricks, also other information.
High Physical memory
I am looking at my Perf Mon and see that the buffer cache is 99% and the total server memory is 87%. What is telling me please?