721 results found

1. Force re-check of index fragmentation alert

   The index fragmentation alert is checked only once per week, because of the load is causes on the system. I am fine with that.
   However, I would like to have the option to force an immediate re-check for a specific database - for instance by adding a "re-check" button to the alert window.

   SCENARIO: The index fragmentation check runs on Saturday and triggers an alert on one database. On Monday I check the alert but I know that the weekly index defragmentation job runs on Sunday, so it is likely that the problem is already fixed. But I like to be sure (because if not, I really need to investigate what went wrong in the defrag job). Plus, I like to get the alert removed from my dashboard, but if it's not fixed then as far as I know it will not be re-raised when the check sees the same issue next week.

   The index fragmentation alert is checked only once per week, because of the load is causes on the system. I am fine with that.
   However, I would like to have the option to force an immediate re-check for a specific database - for instance by adding a "re-check" button to the alert window.

   SCENARIO: The index fragmentation check runs on Saturday and triggers an alert on one database. On Monday I check the alert but I know that the weekly index defragmentation job runs on Sunday, so it is likely that the problem is already fixed. But I like to… more

   19 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   5 comments  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating

2. For Installed Version doesn't show the patching details of the active and passive node of FCI

   For Installed Version doesn't show the patching details of the passive node of FCI
   So if cluster has 3 nodes, you should one line for each
   this will be very helpful if we have missed out on patching inany node then the SQL Monitor can high light this to us

   1 vote

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating

3. Dashboard view for multi-instance environment

   We have multi-instance SQL Server on one VM.
   Today on dashboard we have waits for instance, and we need processor usage for instance also.

   We would prefer to have on tile:
   1. Waits for instance
   2. Procesor for instance
   3. Disk i/o for instance

   We should have also tile which grup all instances into machine. On machine tile we shoul have the same information as for instance but measuers would count machine indicators.

   There would be also great if You would add new dashboard view for multi instance environment.

   My proposal for view in atachment (I am not a professional graphic artist as you can see ;))

   We have multi-instance SQL Server on one VM.
   Today on dashboard we have waits for instance, and we need processor usage for instance also.

   We would prefer to have on tile:
   1. Waits for instance
   2. Procesor for instance
   3. Disk i/o for instance

   We should have also tile which grup all instances into machine. On machine tile we shoul have the same information as for instance but measuers would count machine indicators.

   There would be also great if You would add new dashboard view for multi instance environment.

   My proposal for view in atachment (I am not a professional… more

   •  

   6 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating

4. How about a custom metric or alert to return data in character value as opposed to just numeric scalar or NULL

   I want to have a function much like profiler to collect login data, who logged on & be able to filter on the data collection, for instance, if I only want to see when domain\me connects to the sql server, I would like to track that information. I am aware this can be done with profiler, but I would really like to have the ability to use one tool.

   4 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   1 comment  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating

5. Get notification for when a SQL Agent job is in a retry state

   Hi, it would be really useful if SQL Monitor could identify when any currently executing job steps are in a retry state. We have many such jobs and the time lost whilst they are in such a state is frustrating as if we had notification we could take action. I appreciate I can roll my solution but would be nice if SQL Monitor could do it :)

   1 vote

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating

6. Report average page life expectancy

   The "page life expectancy" performance counter can be a good indicator of an impending performance problem. It's in the "Buffer Manager" performance object.

   http://sqlserverpedia.com/blog/sql-server-bloggers/sql-server-%E2%80%93-what-is-page-life-expectancy-ple-counter/

   1 vote

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   completed  ·  2 comments  ·  Delete…  ·  Admin →

7. On the main dashboard please maintain a consistent ordering.

   Dashboard element sorting should be fixed preferably in alphabetical order. The whole idea of a dashboard should be to provide an at a glance view of the state of your server set. When you change the order from servername when all is green to some other order because something has triggered an alert on a server I have to spend extra time figuring out which server has an issue because the sort order has changed.

   1 vote

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   1 comment  ·  Delete…  ·  Admin →
   completed  ·  Adam responded

   Version 6.0.11 has now been released and amongst the enhancements is the ability to fix the servers in alphabetical order (Oder by: Name).

   If you have any feedback, email sqlmonitorfeedback@red-gate.com

   Thanks,
   SQL Monitor Development Team

8. Bring back the ability to list fragments of T-SQL to reduce Blocking Process alerts, please

   By FAR the largest number of abject NUISANCE Blocking Process alerts I get across 17 servers is due to a simple "How is fragmentation going?" query from a 3rd party product (Idera Defrag Manager).

   Looks like this:

   use [DBName] declare @indexId int declare @dbId int declare @tblId int declare @partitionId int set @partitionId = 0 select @dbId = ISNULL(DBID(),-1) if @dbId=-1 RAISERROR( N'Database does not exist or permission denied: %s', 16, 1, '[DBName]' ) else begin select @tblId = ISNULL(OBJECTID('[DBName].[dbo].[TableName]') ,-1) if @tblId=-1 RAISERROR( N'Table does not exist or permission denied: %s', 16, 1, '[DBName].[dbo].[TableName]' ) else begin select @indexId=indexid from sys.indexes where objectid=@tblId and name='PKtblForecast' if @tblId=-1 OR @indexId IS NULL RAISERROR( N'Index does not exist or permission denied: %s', 16, 1, '[PKtblForecast]' ) else begin select avgrecordsizeinbytes, avgpagespaceusedinpercent, pagecount, avgfragmentationinpercent from sys.dmdbindexphysicalstats(@dbId, @tblId, @indexId,@partitionId,'LIMITED') WHERE ([allocunittypedesc] = 'INROWDATA') END END END

   Back in the days of SQL Monitor 3x, and maybe 4x, we could list fragments-to-ignore, and that reduced HUGE volumes of false-positive Alerts.

   Either my abilities to find the equivalent are sadly lacking, or RG has removed this feature.

   Please, please, either tell me where it's buried, or restore it!

   I honestly don't care if this type of monitoring query is being blocked. Neither, actually do I care if it is the victim of a Deadlock - "it will run at the next scheduled slot".

   Thanks, either way.

   By FAR the largest number of abject NUISANCE Blocking Process alerts I get across 17 servers is due to a simple "How is fragmentation going?" query from a 3rd party product (Idera Defrag Manager).

   Looks like this:

   use [DBName] declare @indexId int declare @dbId int declare @tblId int declare @partitionId int set @partitionId = 0 select @dbId = ISNULL(DBID(),-1) if @dbId=-1 RAISERROR( N'Database does not exist or permission denied: %s', 16, 1, '[DBName]' ) else begin select @tblId = ISNULL(OBJECTID('[DBName].[dbo].[TableName]') ,-1) if @tblId=-1 RAISERROR( N'Table does not exist or permission denied: %s', 16, 1, '[DBName].[dbo].[TableName]' ) else… more

   3 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   2 comments  ·  Delete…  ·  Admin →
   completed  ·  Adam responded

   Version 6.0.16 has now been released and this includes the ability to add regular expression filters to blocking process alerts. We hope this completes your suggestion.

   Thanks, SQL Monitor Team

9. Median from jobs - calculating Job duration unusual ONLY for sucess

   I have noticed that SQL Monitor calculate median from all jobs ragardles if it is failed or sucess...
   From my point of view it should analyse only jobs which finished success and calculate median from duration.
   I need to know when job succeded what is duration median and if it is ok or not.

   Please change job duration median to calculate from jobs which ended with sucess.

   3 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   completed  ·  2 comments  ·  Delete…  ·  Admin →

10. Add number of alerts to browser tab

    I always have SQL Monitor open as one of the tabs on my browser (Chrome). What might be useful is to change the text of the tab (only when it is set to Global Overview) to include the number of alerts (unread or uncleared I'm not sure.....) - much like if you have Gmail inbox open, then any unread items make the tab text "Gmail - inbox (1)'

    3 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    2 comments  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Submit Rating

11. global dashboard should handle multi-level groupings

    Currently the global dashboard presents the SQL instance tiles according to their top-level group. So if I have 3 servers grouped such as:

    App1

    Prod

    Svr1
    Dev
    Svr2
    App2
    Prod
    Svr3

    it will present these under 2 groups: App1 and App2. This is fine if you're viewing all servers.

    However when I filter the view to only show servers in the App1 group, I'd like the tiles to be grouped using the next level of grouping if there is one (in this case "Prod" and "Dev")

    18 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    1 comment  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Submit Rating

12. Save alert email addresses

    I monitor a large enterprise and forward hundreds of alerts using cut/paste. If recent addresses were retained, it would save a lot of time.

    1 vote

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Submit Rating

13. Set a configurable delay to send the Resolved/Ended emails

    Sometimes the emails sent by SQLmonitor to PagerDuty are delayed for some minutes
    In this case it can happen that PagerDuty received the "Resolved/Ended" emails before the "Raised" emails because this one has been delayed for too long and because the alert was resolved after 1 or 2 minutes...
    When it happening the alert is never closed and generate a useless phone call
    So to fix this issue we would like to delay all the "Resolved/Ended" emails send by SQL monitor to be sure that PagerDuty received the "Raised" emails before "Resolved/Ended" emails

    4 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Submit Rating

14. Save metrics used on Analysis page and enable quick way to select them from GUI

    I find myself selecting the same SQL metrics when monitoring or analyzing issues.
    
    It would be nice if I could save metrics and settings for them and next time just select them from the drop-down.

    19 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Submit Rating

15. Shorten the focus window from 15mins to 1min

    I want to be able to apply a shorter timescale to the focus window, 15mins is far too long on a very busy system.

    I would like to be able to put a start / end date/time instead of selecting a time and then x hours before that

    6 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Submit Rating

16. Add a summary tile for deployments to a database

    I'd like to see a summary tile for deployments to a database by SQL Compare and SQL Change Automation.
    Also it would be good if alerts can be created for these events.

    3 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Submit Rating

17. Be able to see and dissect alerts for deadlocks on the AWS RDS platform.

    Currently, SQL Monitor does not raise deadlock alerts for AWS RDS database instances. I'd like this functionality to be added, as it's a major feature and selling point for the product.

    The current workaround we're using is a combination of AWS performance insights and a SQL script. A "single pane of glass" would be much more efficient.

    1 vote

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    1 comment  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Submit Rating

18. create user permissions script

    provide the sql to run for users to use during install to assign permissions to the back end database use and the monitored db use

    obviously explain about the SysAdmin problem with your product

    https://forum.red-gate.com/discussion/80787/required-permissions-changed-after-upgrade
    https://forum.red-gate.com/discussion/80448/new-permissions-needed-for-monitoring
    https://documentation.red-gate.com/display/SM7/Permissions

    7 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Submit Rating

19. Allow custom metrics to be optionally created as "event" alerts rather than default "continuous" alerts.

    I have installed the "Used/available database space increased alert" which alerts when defined thresholds of used space have been exceeded. However, once activated, the alert remains in an active state with no additional notifications (easily missed). I'd prefer to have this metric run daily and notify each time a threshold is exceeded.

    20 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    2 comments  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Submit Rating

20. flexible disk configuration

    Currently the configuration for disk space monitoring in “RedGate Monitor” only gives the option to check on the number of bytes that is still free on the disk (in GB or MB).

    Ideally one should check on the number of bytes in combination with the % free space.
    The reason for this is that percentage hugely differs depending on the total size of the disk. On a small disk one would like to extend the disk when it is 80% FULL, where as on a much bigger disk, 20% space might still be many GB’s and to early to extend the disk.

    A suggestion would be to have an alert generated when for instance: Free space < 20% AND # bytes free < 50GB

    Currently the configuration for disk space monitoring in “RedGate Monitor” only gives the option to check on the number of bytes that is still free on the disk (in GB or MB).

    Ideally one should check on the number of bytes in combination with the % free space.
    The reason for this is that percentage hugely differs depending on the total size of the disk. On a small disk one would like to extend the disk when it is 80% FULL, where as on a much bigger disk, 20% space might still be many GB’s and to early… more

    4 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Submit Rating