Post reply

Server slow with high CPU %privilege time

  • February 8, 2007 at 3:02 pm

    #62802

    Hi,

    We have SQL Server 2000 SP4 running on Windows 2000 server (with 2G RAM). The server would run for a couple days or three days and then user would complain that it is slow. Restart the SQL Server service fixes the issue, but then it happens again after couple days running.

    Looking at perfmon counters, I have noticed high % Processor time (~65%, comparing to normal at < 20%) and high % Privileged time (~50%). Disk Time is ok, so I believe it's not I/O issue. From what I've read about privileged time, it seemed that this could be a hardware driver or NIC issue. I have yet to run some diagnosis. But why restarting SQL Server service would fix it? It does not seem to me that there is memory issue, I have 1.2 G allocated to SQL Server. Please help. Thanks,
    George

  • February 8, 2007 at 3:29 pm

    #688688

    *lost typing

    Have a look at

    http://www.sql-server-performance.com/sql_server_performance_audit.asp

    for some info about performance counters etc.

    Resetting the service also clears any outstanding transactions/locks. Try to figure out which queries are taking longer (sql profiler), if there are any locks (sp_lock,sp_lock2) and if there are extended stored procedures used (sp_oacreate) that operate in the memtoleave memory area

  • February 9, 2007 at 6:49 am

    #688796

    Thanks for the link - I sure will digg deep into it.

    I will also take a loot at locks and extended sp.

    George

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply