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 73    Older >>
 

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,736 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 | 1,951 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,847 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,292 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,439 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,410 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 | 7,969 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,746 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,915 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,972 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,927 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,248 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,872 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,490 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,419 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 | 6,924 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,461 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,187 reads

SQL Monitor Custom Metric: WriteLog Wait Time

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.  Read more...
By Press Release 2014/07/25 | Source: Redgate | Category: sql monitor
Rating:  Rate this |   Briefcase | 9,531 reads

SQL Monitor 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 in the plan cache that have only run one time. This value is only accurate for the instant the query is run, and the value can change radically from one capture time to the next.  Read more...
By Press Release 2014/07/14 | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 9,298 reads
   Items 1 to 20 of 73    Older >>
 
Tags
custom metrics (30)    
redgate software (21)    
sqlservercentral (8)    
monitoring (4)    
webinar (4)    
press release (3)    
administration (2)    
contest (2)    
performance tuning (2)    
plan cache (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)    
table size (1)    
tempdb (1)    
top buffer cache object (1)    
untrusted check constraints (1)