Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag SQL Monitor Rss

   Items 1 to 20 of 75    Older >>
 

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,425 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 | 1,616 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 | 1,969 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,089 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 | 5,919 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 | 6,395 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,571 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,474 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,029 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 | 1,804 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 | 6,986 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 | 5,997 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 | 6,975 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,310 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 | 6,936 reads

SQL Monitor Custom Metric: Buffer Pressure

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

SQL Monitor Custom Metric: Last backup size

Backups are at the heart of the activities of any DBA. You have to restore the backup to know it is good, but you can get an early alert that something is wrong if your backup size changes rapidly or unexpectedly in a short period of time.  Read more...
By 2014/09/16 | Source: Redgate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 7,473 reads

SQL Monitor Custom Metric: Time Since Last Restore

If your log restores aren't happening when they’re meant to, you want to know about it. You’ll be relying on restoring from logs should anything happen to your databases, and if you can’t restore to a certain point in time, you risk losing valuable data.  Read more...
By Press Release 2014/09/02 | Source: Redgate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 7,013 reads

SQL Monitor Custom Metric: Out of memory errors

The number of out of memory errors that have occurred within a rolling five minute window. If you just want to keep an eye out for any memory errors, you can watch the ring buffers for the Out of memory errors alert when it gets registered there.  Read more...
By Press Release 2014/08/19 | Source: Redgate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 8,507 reads

SQL Monitor Custom Metric: Schema Modified

This metric creates an alert that will be raised when something is added to the schema, or the existing schema is modified.  Read more...
By Press Release 2014/08/05 | Source: Redgate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 8,238 reads
   Items 1 to 20 of 75    Older >>
 
Tags
custom metrics (31)    
redgate software (22)    
sqlservercentral (8)    
monitoring (4)    
webinar (4)    
press release (3)    
administration (2)    
contest (2)    
performance tuning (2)    
plan cache (2)    
table size (2)    
writelog wait time (2)    
ad hoc queries (1)    
autogrowth (1)    
blocking (1)    
brent ozar (1)    
buffer pressure (1)    
custom met (1)    
editorial (1)    
foreign keys (1)    
hash warning (1)    
i/o stalls (1)    
i/o statistics (1)    
indexing (1)    
jobs (1)    
log file maintenance (1)    
memory (1)    
memory use (1)    
metrics (1)    
performance metrics (1)    
product reviews (1)    
schemas (1)    
sp_blitz (1)    
sql source control (1)    
ssc clinic (1)    
tempdb (1)    
top buffer cache object (1)    
untrusted check constraints (1)