SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag SQL Monitor Rss

Search for any content tagged sql monitor

   Items 1 to 20 of 80    Older >>
 

SQL Monitor plans for the second half of 2017

SQL Monitor’s dev team has made huge improvements to the product over the last year. In the first half of 2017 alone, they released reporting capabilities, support for collecting metrics from VMWare hosts, significant improvements to performance and scalability, improved configurability of alerts, as well as dozens of smaller enhancements. Since we’re about half way through 2017, it’s time to talk about the plans for the rest of the year.  Read more...
By 2017/08/03 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 4,094 reads

VMware monitoring in SQL Monitor

The Redgate SQL Monitor team has been looking into how you can more effectively monitor SQL Server running on a virtual machine, and are pleased to announce that they've begun this by introducing support for VMware in SQL Monitor version 7.0.11. Find out more about the beta feature in this blog post.  Read more...
By 2017/06/09 | Source: Redgate | Category: monitoring
Rating: (not yet rated)  Rate this |   Briefcase | 3,117 reads

Troubleshooting a painful query using execution plans in SQL Monitor

When something's wrong with your database you need to be able to identify the primary pain points within SQL Server and get to the root cause of the problem fast. Grant Fritchey explains how you can use execution plans inside SQL Monitor to help quickly and simply identify the problem.  Read more...
By Additional Articles 2016/12/09 | Source: Redgate | Category: execution plans
Rating: (not yet rated)  Rate this |   Briefcase | 3,251 reads

How to fix SQL Server deadlocks with monitoring

Learn about deadlocks and how you might better troubleshoot the issues involved.  Read more...
By Additional Articles 2016/04/12 | Source: Redgate | Category: sql monitor
Rating:  Rate this |   Briefcase | 4,955 reads

SQL Server Performance Troubleshooting with SQL Monitor 5

Any SQL Server monitoring tool must gather the metrics that will allow a DBA to diagnose CPU, memory or I/O issues on their SQL Servers. It should also provide a set of accurate, reliable, configurable alerts that will inform the DBA of any abnormal or undesirable conditions and properties, as well as specific errors, on any of the monitored servers. This article provides an in-depth guide to the monitoring and alerting functionality available in one such tool, Redgate SQL Monitor. It focuses on the latest edition (5.0), which includes several key new features, such as performance diagnosis using wait statistics, the ability to compare to baselines, and more.  Read more...
By Additional Articles 2016/02/29 | Source: SimpleTalk | Category: troubleshooting
Rating:  Rate this |   Briefcase | 3,016 reads

SQL Monitor Custom Metric: Table size (MB)

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.  Read more...
By Press Release 2015/07/21 | Source: Redgate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 2,758 reads

Monitoring Availability Groups with Redgate SQL Monitor

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.  Read more...
By Anthony Nocentino 2015/07/07 | Source: Redgate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 2,655 reads

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

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.  Read more...
By Press Release 2015/06/25 | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 2,211 reads

SQL Monitor Custom Metric: WriteLog wait time

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.  Read more...
By Press Release 2015/06/09 | Source: SQLServerCentral.com | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 2,752 reads

SQL Monitor Custom metric: Average I/O stalls

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.  Read more...
By Press Release 2015/05/26 | Source: Redgate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 6,098 reads

SQL Monitor Custom Metric: Plan Cache; Cache Pages Total

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.  Read more...
By Press Release 2015/05/06 | Source: Redgate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 7,098 reads

SQLServerCentral Runs sp_Blitz - The Future

After examining the SQLServerCentral servers using the sp_Blitz™ script, Steve Jones now looks at how we will use the script moving forward.  Read more...
By Steve Jones 2015/04/30 | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: |  Discuss |   Briefcase | 6,755 reads

SQL Monitor Custom Metric: Hash Warnings (Last Hour)

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.  Read more...
By Press Release 2015/03/31 | Source: Redgate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 6,768 reads

SQL Monitor Custom Metric: Tempdb Allocation Contention

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.  Read more...
By Additional Articles 2015/02/17 | Source: Redgate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 8,384 reads

New SQL Monitor Custom Metric: Number of Unused Indexes

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.  Read more...
By Press Release 2015/02/04 | Source: Redgate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 2,082 reads

SQL Monitor Custom Metric: Percentage of Fragmented Indexes

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.  Read more...
By Press Release 2015/01/22 | Source: Redgate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 7,334 reads

SQL Monitor Custom Metric: Identity Columns Near Limit

If your application relies on identity columns, this metric is a useful measure of the number of identity columns that are near to the limit per database. You can then avoid logical problems in your application and SQL Server errors.  Read more...
By Press Release 2015/01/06 | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 6,180 reads

SQL Monitor Custom Metric: Excessive Virtual Log Files in Transaction Log

This metric picks up excessive counts of Virtual Log Files (VLF) in a transaction log that can lead to performance problems, including write performance, restore and recovery times. The ideal value for this metric should be less than 25; excessively high values (greater than 50) can cause high write times when writing to the transaction log.  Read more...
By Press Release 2014/12/11 | Source: Redgate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 7,211 reads

SQL Monitor Custom Metric: Possible Duplicate Indexes

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.  Read more...
By Press Release 2014/11/18 | Source: Redgate | Category: indexing
Rating: (not yet rated)  Rate this |   Briefcase | 7,620 reads

SQL Monitor Custom Metric: Average I/O Stalls

This metric is a great 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.  Read more...
By Additional Articles 2014/10/28 | Source: Redgate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 7,202 reads
   Items 1 to 20 of 80    Older >>