October 5, 2016 at 9:45 am
Is there a way to see individually how much each process is taking up in relation to to processor time. My DB was pegged at 80% to 90% and I couldn't figure out which process or which processes was killing the system. The wait time, wait type, or wait resource columns was no indication. Any suggestions?
Thanks,
Cardgunner
October 5, 2016 at 11:51 am
Card Gunner (10/5/2016)
Is there a way to see individually how much each process is taking up in relation to to processor time. My DB was pegged at 80% to 90% and I couldn't figure out which process or which processes was killing the system. The wait time, wait type, or wait resource columns was no indication. Any suggestions?Thanks,
Cardgunner
Not sure if this is what you are after but I would guess you could take a look at querying sys.dm_exec_sessions to get more information on resource usage of different sessions.
Sue
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply