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 17 of 17   
 

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,560 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,296 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 | 1,936 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 | 697 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,715 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,474 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,898 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,070 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,650 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: (not yet rated)  Rate this |   Briefcase | 2,808 reads

New SQL Monitor Custom Metric: Large Transaction Log Files

If the transaction log autogrows rapidly, it can suggest that log backups are not being carried out frequently enough, or another resource may be preventing the log from truncating. This metric measures the number of transaction log files that are greater than 10 GB. The associated alert is raised when the number of files exceeds a specified threshold.  Read more...
By Additional Articles 2013/09/03 | Source: Red-Gate | Category: sql monitor
Rating:  Rate this |   Briefcase | 2,179 reads

New SQL Monitor Custom Metric: Untrusted Foreign Keys

A foreign key points to a primary key that must exist in another table, for example, column X in Table 1 must also be present in Table 2. The key protects this link, and only valid data can be inserted in the foreign key column. An untrusted foreign key may threaten a database’s referential and data integrity.  Read more...
By Press Release 2013/08/20 | Source: Red-Gate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 2,149 reads

New SQL Monitor Custom Metric: Failed SQL Server logins

This metric returns the number of ‘login failed’ error messages found in the SQL Server error log file in the last hour.  Read more...
By Press Release 2013/08/02 | Source: Red-Gate | Category: red gate
Rating: (not yet rated)  Rate this |   Briefcase | 3,380 reads

New SQL Monitor Custom Metric: Untrusted Check Constraints

This metric returns the number of check constraints that have their is_not_trusted flag set to 1 in the sys.check_constraints table. Untrusted constraints force SQL Server to construct less efficient query plans, because it doesn’t know enough about the kind of data contained in the table. This can point to a data integrity issue which should be investigated.  Read more...
By Press Release 2013/07/08 | Source: Red-Gate | Category: sql monitor
Rating:  Rate this |   Briefcase | 2,342 reads

New SQL Monitor Custom Metric: Issues found by sp_Blitz

This custom metric adds Brent Ozar's popular SP_Blitz scripts to Red Gate SQL Monitor. It looks for configuration, security, health and performance problems, and reports back with a list of issues for you to look into. It’s great for quickly understanding the state of a server you've been asked to look after.  Read more...
By Press Release 2013/05/29 | Source: Red-Gate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 3,081 reads

Job overran Custom Metric

This SQL Monitor custom metric tells you if a specific SQL Server Agent job that runs at the same time every day has overrun. The metric is useful when a job can have negative effects on other processes if it overruns.  Read more...
By Press Release 2013/05/10 | Source: Red-Gate | Category: red gate software
Rating: (not yet rated)  Rate this |   Briefcase | 2,366 reads

Red Gate’s new custom metrics site - with a little help from our friends

With contributions from MVPs and the SQL Server community, the SQL Monitor team at Red Gate has put together a custom metrics site, SQL Monitor Metrics, to accompany the release of SQL Monitor 3.2. The site hosts T-SQL scripts which can be imported directly to SQL Monitor for custom metric monitoring.  Read more...
By Press Release 2012/08/15 | Source: Red-Gate | Category: red gate software
Rating: (not yet rated) |  Discuss |   Briefcase | 799 reads
   Items 1 to 17 of 17   
 
Tags
sql monitor (16)    
red gate (4)    
red gate software (3)    
brent ozar (1)    
foreign keys (1)    
log file maintenance (1)    
monitoring (1)    
performance metrics (1)    
plan cache (1)    
sp_blitz (1)    
table size (1)    
untrusted check constraints (1)