SQL Server Performance

sqlserver.exe taking 25% cpu

Discussion in 'SQL Server 2005 General DBA Questions' started by acki4711, May 2, 2007.

  1. acki4711 Member

    Hi all,
    I see in task manager sqlserver.exe taking constantly 25% cpu time.
    checking with profiler and acitvity monitor shows no activity explaining 25% cpu time???
    What might going on here?

    TIA
  2. satya Moderator

    25% is not a problem as far as I'm concerned, check what kind of activity running by using SP_WHO2 against the server.
    Also see if there are any background processes other than SQL is running, get process explorer from sysinternals site to see what it is running.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  3. acki4711 Member

    satya,
    Taskmanager shows that sqlserver.exe taking 25% cpu time (will say no other mysterious background process)
    I agree it's not a problem, but I'd like to know what's going on on my server if nothing is suposed to going on. In other words there is no workload on sqlserver but still uses 25% of cpu time??
    sp_who2 is equal to activity monitor and both show that only my own (activity monitor) process increases CPUTime???

    Is it possible that internal activity (like updating statistics) is not shown in activity monitor (sp_who2) ???

    Any other suggestions?
  4. satya Moderator

  5. acki4711 Member

    satya,
    I got prozess explorer and it shows that nothting is going on that's why I'm a bit confused.
  6. satya Moderator

    Strange I though that should bring up some information to analyze, anyway refer tohttp://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1210559,00.html?track=sy41 andhttp://sqlserver-qa.net/blogs/perftune/archive/2007/04/26/high-cpu-spikes-affecting-performance.aspx links too to checkout.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  7. MohammedU New Member

    Process explorer gives you processes information where SQL server is one process for process explorer and I don't think process explorer can get sql server internal process information like active spids etc...

    In profiler/Activity monitor you don't see background process information run by the server, you can only regular info...

    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  8. satya Moderator

  9. acki4711 Member

    Hi all,
    I did some more "research" on the problem and found out the following:
    Launched periodical sp_who2 during the 25% CPU period (system is not always on 25%)
    and compared the results.
    -> Nothing else then my own process (sp_who2) grows more then 1% in CPU usage!!!
    (No disk i/o growing on any process)

    -> Fazit: sqlserver.exe does somthing but not in the "db engine"
    -> Question: What else could I examine? Looks to me like some misconfiguation because on same system it's not possible to start sqlbrowser (see:http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=20970).


  10. satya Moderator

    Appreciate your feedback and reference to check, I hope you are able to diagnose further with the links.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  11. acki4711 Member

    Folks, the problem is still unresolved and it's a mystery to me.
    Have now two different machines with the same behavior. CPU usage shows a 25% processor load on sqlserver.exe but profiler and sp_who2 does not show any activity going on ???
    Does any1 have a idea what this could be ??
    TIA
    acki
  12. satya Moderator

    Explain what kind of applications you have on this server, such as MOM or anti-virus etc.
  13. acki4711 Member

    it's just a db server.
    - antivirus (mcaffee) is istalled but all disk drives are excluded from "on access scans".
    - mom agent (client) is installed
    - hp ovo client is installed
    as I explained it's only the sqlserver.exe that takes up 25% cpu
  14. satya Moderator

    Can you stop all these services, also the processes and connections to the SQL instance and see what else is running on this server
  15. acki4711 Member

    stopping the services and all connecting applications has no effect cpu remains ~ 25 %
  16. satya Moderator

    How about database settings such as AUTOGROW & AUTOSHRINK?
  17. acki4711 Member

    Would'nt those processes been shown in activity manager ?
    however, no growing or shrinking is going on
  18. acki4711 Member

    The funny thing is, one machine contains two instances of sql server. cpu load goes sometime to 50 % (task manager shows 2 x sqlserver.exe with 25 % each.) or 25 % (once sqlserver.exe) but never to zero ??

Share This Page