665 results found
Include an alert to monitor replication performance. i.e based on the latency reading that you can view in Replication Monitor. The counters for this are "SQL Server Replication LogReader: Delivery Latency" and "SQL Server Replication Dist.: Delivery Latency". I'd like to be able to set the alert priority based on this.72 votes
Hosting Company raised an alert that there is absolutely no trace of as an issue according to SQL Monitor:
ALERT NAME: Rackspace - SQL I/O Error
TIME: 6/22/2011 7:02:21 PM
Event Description: SQL Server has encountered 174 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [M:\xcp_trans.mdf] in database [xcp_trans] (5). The OS file handle is 0x0000000000000BBC. The offset of the latest long I/O is: 0x000023b6d20000
Please augment SQL Monitor to do the equivalent alerting.30 votesDaniel Rothig responded
Custom metrics on sys.dm_io_virtual_file_stats are the best way to get this today
Add an element that will track all DML/DDL activity within a SQL Server instance and log this to a tamper proof archive. If linked to performance trends this can corrolate performance to T-SQL executed against the instance.
This has scope for aiding with Compliance with PCI-DSS & SoX.10 votes
I would like an GUI option to configure the time the alert fragmented indexes run instead of it being set at 1.00am Sunday morning25 votesDaniel Rothig responded
Note that this can set in the BaseMonitor .config file
Currently, a cluster disk's collected statistics are only visible for the duration of being "active/owned" by a cluster node. If I ran on Node A for the last month and fail-over to the B node today then I lose all visibility to the prior month's stats since they were collected while on the node A.29 votes
- Don't see your idea?