Database Performance

SQLServerCentral Article

Query Performance Diagnostics with sp_PerfSQ

  • Article

This article discusses sp_PerfSQ a diagnostic tool designed to quantify performance features of database queries with active requests. It includes a behavioural parser and can assist in troubleshooting complex performance issues.

4.4 (10)

You rated this post out of 5. Change rating

2021-12-24 (first published: )

11,395 reads

SQLServerCentral Article

Parameter pain

  • Article

A forum question came up a few days ago regarding an abnormally large procedural cache. In an attempt to help out, I threw together a few ideas (some wrong, some right) and started looking at the types of query that were in the cache. A lot of the queries were in the format select * […]

4.7 (10)

You rated this post out of 5. Change rating

2019-11-11

4,751 reads

Blogs

Updating dbatools–Fixing the Certificate Failure

By

I was trying to update my dbatools install to test something and go this...

Classifications and sensitivity labels in Microsoft Purview

By

I see a lot of confusion on how classifications and sensitivity labels work in...

PASS Data Community Summit: A Personal Journey

By

As someone attending the event since 2011, I would like to share my personal...

Read the latest Blogs

Forums

How to get a distinct value from my data set

By skaggs.andrew

Hi, I need help with writing a script that will allow me to pull...

How To Approach Adding A primary Key To An Existing Table

By YSLGuru

In our vendor created/managed DB we have a table that is like an audit...

Dont want to restart Tempdb not able to shrink datafiles in ag primary

By naga.rohitkumar

HI All, Dont want to restart Tempdb not able to shrink datafiles in always...

Visit the forum

Question of the Day

SQL Server on Linux Restrictions

Which of these features are not available on SQL Server on Linux? (choose 2)

See possible answers