SQL instances which are part of Availability Group does show if it primary or secondary in Global Dashboard
When SQL instances which are in Availability Groups are being monitored, the global dashboard lists both the primary & secondary node.
However though it does have 'AG' badge but it does not say which is primary or secondary.
While looking at the SQL monitor it will key that we know upfront which is the primary instance and also when alerting it should say primary or secondary in the subject line.33 votes
Create a replication monitor type dashboard show status and current latency etc.33 votes
The ability to create an alert metric around data which is currently being collected for the Analysis graphs. E.g. Being able to alert when the BufferPagerLifeExpectancy drops below a certain amount.32 votesDaniel Rothig responded
Add the possibility to report on deadlocks. The information is stored in the database as an alert but it's currently not possible to report on alerts.
I'd like to see the occurrence of deadlocks over time, per database,...31 votes
You should be able to add development machines at no additional cost if you already have a production license. If you do not have a license for the development instance then the features can be scaled back to only allow you to view alerts.31 votes
It would be very helpful to have a configuration setting to make alerts audible (something like a beep or alarm ring). In the office we have a screen that displays the SQL Monitor where the alerts are only noticed when people look at the screen, which is not very often.
An audible alert of 'red' alerts would prompt us to action them straight the way.31 votes
When a cluster spans regions I want to be able to only monitor my "active" region and note my "passive/DR" region.
If my primary region fails I would like to switch over my licenses to the other region in SQL Monitor so that I retain my license count.30 votes
We have different data retention requirements depending on what server is being monitored, but currently only 1 purge setting is available which covers all servers. An example of what I'd like to see would be to select to purge data older than 14 days for production/critical servers and a much shorter retention of data for test/development servers. This would be controlled by what group a server was a member of.30 votes
CONTEXT: We use comments to document the root cause of alerts we encounter
PROBLEM: When alerts repeat, recovering the comments is a pain - they only apply to individual occurences, so don't get surfaced when they issues re-occur.
- Show historical comments in alerts
- When creating alerts, allow us to choose whether this applies to the whole alert type
Comments should also show when configuring alerts30 votes
For instance BRENT OZAR has an excellent method to diagnose memory pressure. The counter in use is SQLServer: Memory Manager – Memory Grants Pending which is not available.
If Memory Grants Pending is averaging over 0, queries can’t even start because they can’t get enough memory. You may have queries that have incorrect memory grants, or you may just desperately need more RAM.30 votes
In SQL Monitor 184.108.40.20667 the new Reporting feature is terrific, however I would like to see the addition to add the COMPARE BASELINE option to the Reports like Analysis option currently has. This would allow us to see if measurements like CPU, user connections etc are in line with a baseline of, say last week or way off.30 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:\xcptrans.mdf] in database [xcptrans] (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
SQL Monitor currently does not monitor the execution of SSIS Packages.
It would be extremely useful if SQL Monitor would monitor the execution of the SSIS packages like it does the execution of SQL Jobs
Alert if the SSIS Package Execution Fails
Alert if the SSIS Package is taking longer than normal to Execution
Alert if the SSIS Package fails to start29 votes
The Alert gives objectId and databaseid but your average 'accidental DBA' doesn't know the command
select OBJECTNAME ( objectid [, database_id ] )
Perhaps somehow suggesting the command as context sensitive help?29 votes
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
Idea is to save snapshots of DMV's so that the changes can be analyzed. For example sys.dmexecprocedure_stats shows only total, last and average elapsed time. It will be great to know how the average changed over a period of time.
Common use case: sysproperties29 votes
The 'Job duration unusual' alert is based off of the last ten runs of a job. I think allowing a configurable number of runs to be a baseline or better yet, the last x runs at the same time of day would be ideal.28 votes
Include login or user id information in the Top 10 Queries. This could help identify if a user is running an ad-hoc query.28 votes
Please include the name of the stored procedure (where applicable) in the report of "Longest running queries".
Currently I need to use SQL Search to find the procedure that includes the query.
You can do a LEFT OUTER JOIN sys.objects using objectid to find the name (objectname) of the originating stored procedure.28 votes
in other monitoring tools (Idera) i can see active sql connections and they are doing. i also have a option to kill the process if i decide. dose your product have this ability27 votes
- Don't see your idea?