SQL Monitor

SQL Monitor Custom Metric: Table size (MB)

• by Press Release

• Redgate

• SQL Monitor

• Article

This metric is useful if you want to know exactly how much physical space a particular table is taking up, including the size of its indexes.

2015-07-21

2,899 reads

Monitoring Availability Groups with Redgate SQL Monitor

• by Anthony Nocentino

• Redgate

• SQL Monitor

• Article

Anthony Nocentino, experienced Enterprise Architect and Friend of Redgate, explains the challenges presented by monitoring Availability Groups and shows you a technique for monitoring AG replication latency with Redgate SQL Monitor and its Custom Metric functionality.

2015-07-07

2,913 reads

SQL Monitor Custom Metric: Memory Used By Ad Hoc Queries Running Once

• by Press Release

• SQLServerCentral

• SQL Monitor

• Article

This metric measures the amount of memory used by the total number of ad-hoc queries that are currently in the plan cache. If the value is high, it indicates memory is being wasted by storing the execution plans of queries that will never be run more than one time.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

2015-06-25

2,334 reads

SQL Monitor Custom Metric: WriteLog wait time

• by Press Release

• SQLServerCentral.com

• SQL Monitor

• Article

This metric shows Writelog wait time in ms, per elapsed second. Writelog wait types occur when the log cache is being flushed to disk. If this happens all the time, it may suggest disk bottlenecks where the transaction log is stored.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

2015-06-09

2,958 reads

SQL Monitor Custom metric: Average I/O stalls

• by Press Release

• Redgate

• SQL Monitor

• Article

This is a good general indicator of performance problems. High stall times indicate I/O problems, which can be attributed to busy physical disks or queries that return large data sets to the client.

2015-05-26

6,171 reads

SQL Monitor Custom Metric: Plan Cache; Cache Pages Total

• by Press Release

• Redgate

• SQL Monitor

• 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

SQL Monitor Custom Metric: Hash Warnings (Last Hour)

• by Press Release

• Redgate

• SQL Monitor

• 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

SQL Monitor Custom Metric: Tempdb Allocation Contention

• by Additional Articles

• Redgate

• SQL Monitor

• 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

New SQL Monitor Custom Metric: Number of Unused Indexes

• by Press Release

• Redgate

• SQL Monitor

• Article

This metric can help if you want to monitor the number of indexes per database that haven't been used for the last month. Indexes that aren't in use should be removed because they can degrade INSERT, UPDATE and DELETE performance, and they use storage space.

2015-02-04

2,179 reads

SQL Monitor Custom Metric: Percentage of Fragmented Indexes

• by Press Release

• Redgate

• SQL Monitor

• 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