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,892 reads


Beginning T-SQL and Career Roadmap for Women (and Men)! #SQLSatBR


Download session materials and watch the recordings of my excellent sessions on Transact-SQL and...

Actual Kubernetes


This post continues looking at my process of learning more about Kubernetes. I’ve been...

New product: Azure Data Share


A brand new product by Microsoft called Azure Data Share was recently announced. It...

Read the latest Blogs


Primary Key and Clustered Index

By RonMexico

A topic I always get confused with is primary key vs. clustered index. I...

odd error message in function in a proc

By tcronin 95651

I have a cursor which has calls a function (sorry for  design this is...

How to make in memory SQL transformations within a data flow task

By svenflock

Hi all, first of all, I am new to Integration Services. I googled everything...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers