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

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: Red-Gate | Category: sql monitor
Rating:  Rate this |   Briefcase | 6,224 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 | 8,715 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,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

SQL Monitor Custom Metric: Top Buffer Cache Object

This metric measures the amount of memory used in the buffer cache by the largest object (based on the number of pages). It checks the sys.dm_os_buffer_descriptors to identify the object, and returns the relative percentage used. You should use this metric if you want to monitor what is in the buffer area, or if you are having performance-related disk read problems.  Read more...
By Press Release 2013/07/22 | Source: Red-Gate | Category: top buffer cache object
Rating: (not yet rated)  Rate this |   Briefcase | 3,093 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: Database Autogrowth

This metric for Red Gate SQL Monitor measures the number of database autogrowth events (data file or log file) in the last hour. Too many autogrowth events causes disk fragmentation which requires a change in the autogrowth settings of a database.  Read more...
By Press Release 2013/06/25 | Source: Red-Gate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 3,711 reads

New Custom Metric: Percentage of blocked connections

This metric reports the number of connections that are currently blocked, divided by the total count of current connections. Most well-balanced SQL Servers will have some degree of blocking. This metric attempts to measure the impact of lead blocking queries against other queries. Higher values indicate that many connections are being blocked, and queries should be tuned to reduce the amount of contention.  Read more...
By Press Release 2013/06/07 | Source: SQLServerCentral.com | Category: blocking
Rating: (not yet rated)  Rate this |   Briefcase | 2,795 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
   Items 1 to 20 of 55    Older >>
 
Tags
custom metrics (16)    
red gate software (15)    
sqlservercentral (7)    
red gate (5)    
webinar (4)    
monitoring (3)    
press release (3)    
contest (2)    
performance tuning (2)    
ad hoc queries (1)    
administration (1)    
autogrowth (1)    
blocking (1)    
brent ozar (1)    
custom met (1)    
editorial (1)    
foreign keys (1)    
jobs (1)    
log file maintenance (1)    
memory (1)    
metrics (1)    
performance metrics (1)    
plan cache (1)    
product reviews (1)    
sp_blitz (1)    
sql source control (1)    
ssc clinic (1)    
table size (1)    
top buffer cache object (1)    
untrusted check constraints (1)    
writelog wait time (1)