Sql server 2005 cpu spiking issue
-
Hi everyone, new to this sub but I was wondering what you guys would do to check on a sql server that goes from 5% cpu utilization to 99% back down to 5% every 4 seconds. I checked if it was a job and the closest one is a simple insert that runs every minute.
The server has a total of 20 user connections to a db that is 3 gb big. But this issue occurs at night when there are almost 0 connections.
Anyone have any ideas on queries I could run to see what is happening in geometry dash breeze?
Thanks!
- This topic was modified 7 months ago by nelsonvillicana.
-
Launch a profiler trace to see what is going on
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply