SQL Monitor

External Article

SQL Monitor Custom Metric: Possible Duplicate Indexes

  • Article

When a table has multiple indexes defined on the same columns, it produces duplicate indexes that waste space and have a negative impact on performance. This metric measures the number of possible duplicate indexes per database above a set threshold. You can then consider dropping the indexes and reverse the change.

2014-11-18

7,931 reads

External Article

SQL Monitor Custom Metric: Buffer Pressure

  • Article

Trying to determine if you have pressure in your buffer allocations can be difficult. This metric reliably indicates if you have a buffer problem using the memory dump from DBCC MEMORYSTATUS() and comparing Target Committed to the Current Committed allocations. If you hit negative numbers you are looking at a buffer issue.

2014-10-14

6,901 reads

External Article

SQL Monitor Custom Metric: WriteLog Wait Time

  • Article

During a transaction, data is written to the log cache so that it’s ready to be written to the log file on commit, or can be rolled back if necessary. When the log cache is being flushed to disk, the SQL Server session will wait on the WriteLog wait type. If this happens all the time, it may suggest disk bottlenecks where the transaction log is stored.

2014-07-25

9,844 reads

Blogs

Recovering a TDE Database Without the Certificate 

By

If you don’t have the backups of the certificate and private key from the...

Daily Coping 31 Jan 2023

By

Today’s coping tip is to take a small step towards and important goal. One...

Tales From The Field Weekly Wrap Up for the Week of 01-23-2022

By

 Hello Dear Reader!  It's been a while since I had time to sit down...

Read the latest Blogs

Forums

wrong index name

By thbaig

Hi , I have 2 databases 1)staging 2)prod. I am using following query to...

VSS / SQLWriter sequence of warnings and error (... subset of the volumes ...)

By Johan Bijnens

We have (only) one SQL2019 clustered instance reporting this sequence of error and warnings:...

The Data Fabric – Future of Data Management

By Ajay Kumar

Comments posted to this topic are about the item The Data Fabric – Future...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers