SQL Server Performance Forum – Threads Archive
sqlserver.exe taking 25% cpu
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
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.
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?
No chance for hiding any system process if it is running, get thishttp://www.microsoft.com/technet/sysinternals/SystemInformation/ProcessExplorer.mspx and see what 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.
satya,
I got prozess explorer and it shows that nothting is going on that’s why I’m a bit confused.
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.
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.
See thishttp://forums.microsoft.com/TechNet/ShowPost.aspx?PageIndex=2&SiteID=17&PostID=1547022 relevant post in MSDN too. 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.
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).
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.
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
Explain what kind of applications you have on this server, such as MOM or anti-virus etc.
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
Can you stop all these services, also the processes and connections to the SQL instance and see what else is running on this server
stopping the services and all connecting applications has no effect cpu remains ~ 25 %
How about database settings such as AUTOGROW & AUTOSHRINK?
Would’nt those processes been shown in activity manager ?
however, no growing or shrinking is going on
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 ??
]]>