SQL Server performance

External Article

SQL Server Perfmon counters that are still interesting in 2019

  • Article

Years ago, my first go-to tool for performance tuning was Performance Monitor: it was available everywhere, worked in all versions, and gave me a lot of useful information without paying for a monitoring tool. Since then, I’ve moved on – wait stats are a much better starting point – but there are still 3 good Perfmon counters that I rely on.

2019-02-13

2,442 reads

Blogs

Quick Wins with GenAI

By

The more I look to GenAI to save me minutes, short periods of time,...

Speaking at the 2025 PASS Data Community Summit

By

I will be back in Seattle this year attending the 2025 PASS Data Community...

The Book of Redgate: Motivation

By

Another of our values is this: Motivation isn’t about carrots and sticks. Constant oversight...

Read the latest Blogs

Forums

Batchmode execution in SQL 2019

By cooldude001

Is there a way to force a query to use Batchmode execution, my database...

How to Work with RStudio and SQL Server

By Daniel Calbimonte

Comments posted to this topic are about the item How to Work with RStudio...

Finding Heaps

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Finding Heaps

Visit the forum

Question of the Day

Finding Heaps

If I am querying DMVs for a heap, what do I look for?

See possible answers