Save results DBCC SQLPERF(UMSSTATS) in a table

Examining the output of DBCC SQLPERF(UMSSTATS) helps in determining a CPU bottleneck. The output of the command is not handy for further investigation (from a table).This procedure performs a transformation of the results, so it is easy to query and store in a database.

2005-11-04 (first published: )

1,896 reads

Blogs

State of Database DevOps Survey

By

Maybe you’re using DevOps within your database development and deployment. Maybe you’re not. Maybe...

HP is the 2019 Laptop Winner

By

This is for me, not necessarily for you, but I decided to go with...

Data Lake Architecture using Delta Lake, Databricks and ADLS Gen2 Part 4

By

This is the fourth and final post in a series about modern Data Lake...

Read the latest Blogs

Forums

Snapshot Isolation and DMVs

By chris.o.smith

I recently noticed that DMVs, or at least sys.dm_db_partition_stats, does not respect snapshot isolation. ...

SSAS Remote Access

By Nick

Hi all, I've been using Power Pivot and Power BI for some time and...

Stored Procedure Documentation

By SQL Espo

I have developed several stored procedures that will be utilized by developers on a...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers