Hi
Sometime around one time per week my sql server 2008 utilized cpu up to 95 -99 %. Off course I can analyse trace log later but I would like to get know immediately which proccess utilize cpu so much and kill this process or processes.
Thanks
Technology Tips and News
Hi
Sometime around one time per week my sql server 2008 utilized cpu up to 95 -99 %. Off course I can analyse trace log later but I would like to get know immediately which proccess utilize cpu so much and kill this process or processes.
Thanks
Why dont you refer to task manager for CPU utilization, you can eaisly conclude which process is utilizing CPUHi
Sometime around one time per week my sql server 2008 utilized cpu up to 95 -99 %. Off course I can analyse trace log later but I would like to get know immediately which proccess utilize cpu so much and kill this process or processes.
Hi
I meant to find out which user run stored procedure or scripts in sql server that utilize a lot of cpu time.
Vik
Hello Vik,
see TechNet Scriptcenter: Current IO and CPU Workload , it returns also login name + SQL statement
Hi
I meant to find out which user run stored procedure or scripts in sql server that utilize a lot of cpu time.
This is not possible AFAIK you can know which user executed certain SP but there is no way to track that certain SP caused high CPU utilization wuith sureity.
You can look at sys.dm_exec_query_stats and find out costly queries or CPU utilizing queries and can see trace to find which user executed it. But you would require to refer a lot to correlate its not direct.