DMV - Active queries sorted by CPU usage

select
           s.session_id,

           db_name(s.database_id) DB,

           s.login_time,

           s.host_name,

           s.program_name,

           s.login_name,

           s.cpu_time,

           s.memory_usage,

           s.total_scheduled_time,

           s.total_elapsed_time,

           s.endpoint_id,

           s.last_request_start_time,

           s.last_request_end_time,

           s.reads,

           s.writes,

           s.logical_reads,

           s.is_user_process,

           s.row_count,

           s.open_transaction_count,

           t.text as [command]

from sys.dm_exec_sessions s

inner join sys.dm_exec_connections c...

2019-04-25

19 reads

Blogs

Adding a Column with a Default Constraint

By

Last week a question came up about adding a column to a table, and...

Rename Azure VM OS Disk

By

In a recent post about creating Azure VMs using PowerShell, I noted a common...

How I Continuously Learn About SQL Server

By

Watch this week’s episode on YouTube. In order to stay current in a technology...

Read the latest Blogs

Forums

The AI Manager

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The AI Manager

A Pandas Series

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Pandas Series

DevOps and OSS Can Scale

By Steve Jones - SSC Editor

Comments posted to this topic are about the item DevOps and OSS Can Scale

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers