Link to home
Start Free TrialLog in
Avatar of my3cents
my3cents

asked on

sqlservr.exe is taking up 100% of the cpu

The sqlservr.exe process is taking up 100% of the cpu. Is there a way to check what query or what user is causing it?

I would also like to know if there is a general guide to trouble shooting sql server issues.

Thanks.
SOLUTION
Avatar of Jornak
Jornak
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Avatar of Alpesh Patel
Alpesh Patel
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial