Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
CPU spikes by session_id RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi!

    We have a process that logs active sessions (sys.dm_exec_connections) and cpu_time (sys.dm_exec_sessions and sys.dm_exec_requests) when CPU spikes. Which value is more likely to indicate a contributor to CPU spikes; high sys.dm_exec_sessions .cpu_time or high sys.dm_exec_requests.cpu_time? 

    Thanks

    Robert J. Cantor DBA

    Wednesday, June 1, 2016 11:30 PM

Answers

All replies