Post reply

CPU Usage 100% SQLServr.exe

  • January 12, 2004 at 10:57 am

    #161082

    Hello!!!

    I have a SQL 2000 Standard Edition (SP3) installed on a Win2000 server (SP4 with Patches) and since last thursday, the SQLServr.exe process is hitting more than 97% of CPU Usage.

    SQL memory is configured to dynamically (min. 0 / max 719) and nothing was changed on the server that might be causing this problem.

    I used sp_who2 but there are no obvious problems and I verify about virus but nothing was found either.

    Could you help me to find and solve the problem, please????

    Thanks!!!!

  • January 12, 2004 at 12:23 pm

    #489622

    I am wondering there are some large queries running. Check all your schedule jobs and run Profiler to see which queries consume CPUs time.

    Please post "select * from sysprocesses where waittime > 0 order by waittime desc" here.

     

  • January 12, 2004 at 2:33 pm

    #489647

    Besides the select asked by Allen, could you show the return of your sp_who2?

    Kindest Regards,

    Giuliano Camarini de Oliveira
    agnitia.com.br

  • January 13, 2004 at 3:17 am

    #489700

    hey , even i am facing the same problem but with server 7.This query "select * from sysprocesses where waittime > 0 order by waittime desc" gave me this result spid kpid blocked waittype waittime lastwaittype waitresource dbid uid cpu physical_io memusage login_time last_batch ecid open_tran status sid hostname program_name hostprocess cmd nt_domain nt_username net_address net_library loginame suid .Sp_who shows lots of entries where status is "sleeping" and cmd is "awaiting cmd".

  • January 13, 2004 at 3:17 am

    #489699

    hey , even i am facing the same problem but with server 7.This query "select * from sysprocesses where waittime > 0 order by waittime desc" gave me this result spid kpid blocked waittype waittime lastwaittype waitresource dbid uid cpu physical_io memusage login_time last_batch ecid open_tran status sid hostname program_name hostprocess cmd nt_domain nt_username net_address net_library loginame suid .Sp_who shows lots of entries where status is "sleeping" and cmd is "awaiting cmd". Plz help, TIA.

  • January 13, 2004 at 6:41 am

    #489724

    sp_who2 active will tell those active spids. DBCC opentran will show the Oldest active transaction that might still running.

Viewing 6 posts - 1 through 5 (of 5 total)

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