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

Get required permissions for DMVs

By

Part of my job at work is to update Transact-SQL reference content. System dynamic...

A New Word: Rivener

By

rivener – n. a chilling hint of distance that creeps slowly into a relationship...

AI and Cybersecurity: the Genie is Out of the Bottle

By

Today's reality is that cybercriminals are increasingly using AI to develop better attacks. This...

Read the latest Blogs

Forums

2 table designs within one section to keep data for one section value within one

By blom0344

My requirement is to display data for  a number of routes within 2 tables...

How to Resolve SQL Server Error 9100?

By mohdkaif002

Is there any professional method to resolve SQL server error 9100.

Why Tech Events Matter for Data Pros (and why I’m grateful)

By dbakevlar

Comments posted to this topic are about the item Why Tech Events Matter for...

Visit the forum

Question of the Day

New Backup Compression

What is the new software backup compression algorithm in SQL Server 2025?

See possible answers