SQL Monitor

External Article

SQL Monitor Custom Metric: Plan Cache; Cache Pages Total

  • Article

This metric collects the number of 8-kilobyte pages that make up the plan cache to help identify memory pressure or plan cache pollution. A sudden drop in values for this metric may indicate that the instance is under memory pressure and SQL Server had to reclaim part of the plan cache for other use.

2015-05-06

7,382 reads

External Article

SQL Monitor Custom Metric: Hash Warnings (Last Hour)

  • Article

This alert is raised when the number of hash warnings events in the last hour goes above a specified threshold. A hash warning event means that part of the data processed for a hash operation was written to tempdb during query execution, which can degrade SQL Server Performance.

2015-03-31

6,894 reads

External Article

SQL Monitor Custom Metric: Tempdb Allocation Contention

  • Article

If your code uses temporary tables, variable tables or dynamic cursors, this metric can help identify whether you have contention on tempdb allocation. Tempdb is shared by all databases and is used for many operations in a SQL Server instance, so it is common for tempdb to cause performance problems.

2015-02-17

8,580 reads

External Article

SQL Monitor Custom Metric: Percentage of Fragmented Indexes

  • Article

This is a general indicator of performance problems. Index fragmentation can affect the rate of return for moderate to large tables. If this value indicates an increased amount of index fragmentation throughout your database, you may need to fine-tune your indexes by redesigning, or rebuilding more frequently.

2015-01-22

7,455 reads

Blogs

Daily Coping 3 Feb 2023

By

Today’s coping tip is to ask other people about things they’ve enjoyed recently I...

Daily Coping 2 Feb 2023

By

Today’s coping tip is to challenge negative thoughts and look for the upside. I’m...

Deadline for Microsoft MVP contributions is 20 March 2023

By

Since changing to the new MVP renewal model, Microsoft MVPs have had until 31...

Read the latest Blogs

Forums

Aws rds transfer/migrate login/users to other rds

By thbaig

Hi , I have script to extract all users details with password and permissions....

Can an INSERT statement block SELECT statements?

By vsamantha35

Hi All, Can an INSERT statement block SELECT statements? not sure why ? Can...

Extended Events to capture query causing tempdb log to get full

By PJ_SQL

Hi! How\Steps to setup Extended events to capture query causing tempdb log getting full?...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers