Archive:
Search site:
Tags:
Compilation (1) Concurrency (3) DMVs (1) docker (2) Execution Plans (4) internals (10) linux (3) Name Resolution (1) Optimization (4) Performance (7) Performance Tuning (2) pgadmin (1) postgres (4) RCSI (2) Schemas (1) Security (1) SQL Server (18) Transactions (1) tsql2sday (1) Version Store (2)
Categories:
Tag: DMVs
-
SQL Server – See What’s Executing Now With DMVs
In SQL Server, there are a few DMVs that tell us “What is running now”. This is built into SSMS as Activity Monitor, but I’ve never met anyone who actually finds that method useful, there’s also sp_who and sp_who2, but they are dated and limited in what they tell you. Instead, the more robust way…