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

Content with tag Custom Metrics Rss

   Items 1 to 20 of 27    Older >>
 

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: Red-Gate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 6,710 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: Red-Gate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 1,525 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: Red-Gate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 6,669 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,825 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: Red-Gate | Category: indexing
Rating: (not yet rated)  Rate this |   Briefcase | 7,013 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: Red-Gate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 6,681 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: Red-Gate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 6,236 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: Red-Gate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 7,248 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: Red-Gate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 8,283 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: Red-Gate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 8,017 reads

SQL Monitor Custom Metric: Ad Hoc Queries Running Once

This metric measures the total number of ad hoc queries in the plan cache that have only run one time. The 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/06/10 | Source: Red-Gate | Category: sql monitor
Rating:  Rate this |   Briefcase | 1,679 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. If a database is growing quickly within a short time and you suspect a certain table is responsible, you can monitor its actual size, or the rate at which it is increasing.  Read more...
By Press Release 2014/04/15 | Source: Red-Gate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 1,599 reads

SQL Monitor Custom Metric: Server principals with default database offline

This metric monitors whether a server principal’s default database is offline. When you create a SQL Server server principal (formerly referred to as a server login) it has a default database setting that is used to assist in a connection request when no database is specified.  Read more...
By Press Release 2014/04/04 | Source: Red-Gate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 2,037 reads

SQL Monitor Custom Metric: Performance-Related Database Settings

If you manage a server where you are not in complete control of the creation of databases, or you’re unfamiliar with what settings to change, you may miss things out or set them incorrectly. This metric could pick up on issues that affect performance in obscure ways, and saves you having to search for them when a system suddenly stops performing as you would expect.  Read more...
By Press Release 2014/03/11 | Source: Red-Gate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 977 reads

New SQL Monitor Custom Metric: Default User Service Account

Using a default account for SQL Server services can be a security risk for two reasons. Firstly, it can give the service a higher level of permissions than it needs. Secondly, isolation is compromised by several services running under the same account. This metric checks whether SQL Server services are running under any of the default accounts, such as localsystem.  Read more...
By Press Release 2014/01/14 | Source: Red-Gate | Category: sql monitor
Rating:  Rate this |   Briefcase | 1,786 reads

New SQL Monitor Custom Metric: Default TCP Port

This metric checks whether your SQL Server installation is using the default TCP port. It’s widely known that SQL Server 2005 and 2008 listen on TCP port 1433. Keeping this default gives hackers a potential way of attacking your server.  Read more...
By Press Release 2013/12/10 | Source: SQL Monitor Metrics | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 1,541 reads

New SQL Monitor Metric: Principals with Sysadmin Login

This metric counts the number of principals who are members of the sysadmin fixed server role. SQL Server relies on role-based security to manage permissions. If multiple IT system administrators have permissions to set up new SQL Server logins, they might be inclined to do so as part of the sysadmin role. Adding a normal user to the sysadmin role could pose a security risk and is not recommended unless the principal is highly trusted.  Read more...
By Press Release 2013/11/11 | Source: Red-Gate | Category: sql monitor
Rating:  Rate this |   Briefcase | 2,979 reads

SQL Monitor Performance Metric: Buffer Cache Used Per Database in MB

Data pages read from disk are placed in the buffer pool with the intention that they will be reused, and accessing them from RAM is faster than from disk. Knowing how much of your RAM is committed to each database can help you provision the right amount of RAM to SQL Server, and also to identify rogue queries that draw too much data into RAM and force data from other databases out of the cache.  Read more...
By Press Release 2013/10/15 | Source: Red-Gate | Category: custom metrics
Rating: (not yet rated)  Rate this |   Briefcase | 3,151 reads

SQL Monitor Performance Metric: SQL Server: Plan Cache: Cache Pages Total

This metric collects the total amount of memory, in kilobytes, used by the plan cache of an instance to help identify memory pressure or plan cache pollution. It is similar to the SQL Server: memory manager: SQL cache memory counter, but instead of providing the number of 8-kilobyte pages that make up the plan cache, it provides the total memory used.  Read more...
By Additional Articles 2013/10/01 | Source: Red-Gate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 2,722 reads

New SQL Monitor Custom Metric: Percentage of Free Log Space

This metric measures the percentage of free space for transaction log files (LDF files). You’ll find this useful if your SQL Server has limited capacity, so you need to maximize existing disk space utilization by minimizing unused space. It will also alert you if the amount of free space drops below the specified thresholds.  Read more...
By Press Release 2013/09/17 | Source: Red-Gate | Category: sql monitor
Rating:  Rate this |   Briefcase | 2,901 reads
   Items 1 to 20 of 27    Older >>
 
Tags
sql monitor (26)    
red gate (4)    
red gate software (3)    
brent ozar (1)    
buffer pressure (1)    
foreign keys (1)    
indexing (1)    
log file maintenance (1)    
monitoring (1)    
performance metrics (1)    
plan cache (1)    
schemas (1)    
sp_blitz (1)    
table size (1)    
tempdb (1)    
untrusted check constraints (1)