212 results found

1. Missing database name in blocking session alert

   When I receive an alert about a blocking session, it does not tell me the database. The mail starts with e.g.

   Blocking Session ID: 93
   Number of blocked descendants: 1
   Total blocking duration for all descendants: 00:03:02
   Blocking SQL fragment: CREATE PROCEDURE [dbo]...

   In the subsequent blocks (blocked sessions) it shows the corresponding database name, but only after much of scrolling, when the block cames from a long procedure (some with > 1000 lines).

   So please add the database name to the blocking session part too.

   5 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 →
   completed  ·  Adam responded

   Thanks for the suggestion. Version 7.1.3 has now been released and improvements include adding the database name to the Blocking process alert.

   Kind regards,
   SQL Monitor Development Team

2. Link executions of top 10 queries

   I had an issue with a query that runs slow every other day. For a specific slow day I could find it in the top 10 queries. I'd like to be able to easily compare the days when it was previously executed . I did manage this by opening a new tab to select the fast day - the query was hard to find as there were many other queries in the top 10 on the fast day. I'd like to be able to lock in on a specific query and monitor the server/query stats at the time/duration of previous executions. As I said we can kind of do this now by manually searching for the query on other days but it's not always easy when there is a busy workload going on.

   I had an issue with a query that runs slow every other day. For a specific slow day I could find it in the top 10 queries. I'd like to be able to easily compare the days when it was previously executed . I did manage this by opening a new tab to select the fast day - the query was hard to find as there were many other queries in the top 10 on the fast day. I'd like to be able to lock in on a specific query and monitor the server/query stats at the time/duration of previous… more

   5 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 →
   completed  ·  Adam responded

   Thank you for this suggestion. A graph showing a query’s history was added to the Server Overview Top Queries table in Version 7.1.11 in November 2017. This allows you to see a query’s performance over time, view its execution count, duration, reads, and writes, and the points in time a query’s plan changed.

   We will close this suggestion, but please do raise another suggestion if you have other specific improvements you’d like to see.

   Kind regards,
   Adam
   SQL Monitor Development Team

3. Preserve advanced filter settings when page size is changed

   When viewing alerts and changing page size, a predefined filter setting is preserved, but any other advanced settings appear to be reset.

   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…)
   2 comments  ·  Delete…  ·  Admin →
   completed  ·  Adam responded

   In v3.1 the filters now persist on the Alert inbox until they are manually cleared, so you can change the page size or navigate away and always return to the filtered alerts without having to reselect the filter.

   We’re interested to hear your feedback on this feature so please let us know at usability@red-gate.com.

   Thanks again for the suggestion and comments.

4. add the ability to specify a default filter. I'm getting tired of having to re-select my custom filter each time I click on the Alerts tab.

   When working through a huge list of alerts, if I don't remember to click on the "back" button I am forced to re-select my custom filter from the Filter dropdown list.

   If would save some time if a custom filter could be specified as the default Alerts filter.

   • 

   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 →
   completed  ·  Adam responded

   In v3.1 the filters now persist on the Alert inbox until they are manually cleared, so you can navigate away and always return to the filtered alerts without having to reselect the filter from the dropdown list.

   We hope this fixes the root of the problem that your workaround was a suggestion for. We’re interested to hear your feedback on this feature so please let us know at usability@red-gate.com. Thanks again for the suggestion and comments.

5. Regarding Custom Metrics - allow us to either have the "Description" inserted into the email or give us another text field for annotating.

   We have solution documents in a help desk application. I would like to have my error message emailed with a suggestion that the recepient reference the solution document for steps in resolving the problem.

   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…)
   2 comments  ·  Delete…  ·  Admin →
   completed  ·  Priya Sinha responded

   SQL Monitor V 3.3. has now released. This release contains improved subject lines and message bodies of alert emails to help you quickly understand problems before logging in to SQL Monitor. For custom alert, emails now include description.

   Thanks,
   SQL Monitor Development Team

6. Configure disk space alerts at individual disk level

   I'm able to get away with some disks running closer to capacity than others. (not all drives hold SQL!) it would be nice to be able configure alerts to reflect this and have the email alert display which disk is causing the problem.

   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 →
   completed  ·  Priya Sinha responded

   This feature already exists in the product.

7. increase or decrease the fill factor

   Dear team.

   I see some explanation on the sql Monitor live Demo tool which seems incorrect:

   Check also: The fill factor percentage of the tables in your indexes. If enough space for index expansion is available on data pages, the potential for page splits is reduced. The default fill factor value setting is 0 (100%), which means that pages are filled to capacity. If you increase the fill factor, additional free space is left in the indexes after they are rebuilt or reorganized, helping to prevent excessive page splitting

   increase should be decrease: the higher the fill factor the less free space remains.

   Best regards Patrick van Older

   Dear team.

   I see some explanation on the sql Monitor live Demo tool which seems incorrect:

   Check also: The fill factor percentage of the tables in your indexes. If enough space for index expansion is available on data pages, the potential for page splits is reduced. The default fill factor value setting is 0 (100%), which means that pages are filled to capacity. If you increase the fill factor, additional free space is left in the indexes after they are rebuilt or reorganized, helping to prevent excessive page splitting

   increase should be decrease: the higher the fill factor the less… 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…)
   completed  ·  1 comment  ·  Delete…  ·  Admin →

8. Recognize Low Alerts visually in overview

   Low Alerts show as blue dots on the Latest Alerts panel, but in the overview they show Green like Healthy.
   Especially when showing Small Tiles (we monitor 60+ instances) they do not stand out from Healty ones (see the attached examples).

   For that reason I dont use many Low Alerts.
   It would be more consistent to use blue in the overviews also.

   •  

   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…)
   completed  ·  1 comment  ·  Delete…  ·  Admin →

9. If a job fails the alert should not be cleared until the job has run successfully again

   If a job fails the alert should not be cleared until the job has run successfully again. It doesn't make sense clearing the alert just because a job has been restarted. The alert should remain active until a completely successful run.

   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 →
   completed  ·  Neil Turner responded

   This has been changed and now works as described here. In SQL Monitor since 11.2.13 (released 26 Sep 2021).

10. Put SQL statements from "top 10" in a textarea box

    I'd like to see the SQL statements in the "Top 10 expensive queries" inside a textarea box so it's easy to copy and paste out of it.... The current layout of putting the SQL in a div makes it difficult to get the SQL out of there to paste into Management Studio to examine

    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…)
    1 comment  ·  Delete…  ·  Admin →
    completed  ·  Daniel Rothig responded

    they are in a textarea: Doubleclick to copy

11. Make cookie timeout duration configurable

    Currently Cookies expire after 2 days, this means you have to re-enter your password for SQL Monitor every two days. This should be configurable. Some of us have adequate desktop security, and secure external access that this is unnecessary.

    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 →

12. create a function to allow clearing of all alerts on a given server, instance, database.

    Currently i can only find a way to clear 100 alerts at a time, or to purge information from the SQL monitor. It would a nice easy feature to be able to clear all alerts in one go.

    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…)
    3 comments  ·  Delete…  ·  Admin →
    completed  ·  Priya Sinha responded

    This feature is already present in the SQL Monitor.

13. Custom Metric Order

    Either allow an order to be defined for custom metrics on the analysis tab or at least order them alphabetically rather than in the order created.

    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…)
    1 comment  ·  Delete…  ·  Admin →
    completed  ·  Adam responded

    We’ve alphabetically ordered the custom metrics on the Analysis tab and this will go in the next release which we hope to have available later next month.

    Thanks again for the suggestion.

14. Alert if any data collection of metrics values stops unexpectedly

    For some reason our data collection stops every other week for certain metrics. Restarting the SQLMonitor-service will make the service resume collecting again.
    As it is now we have to inspect each metric manually to identify problems.
    I would like an alert if any data collection stops unexpectedly.

    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…)
    3 comments  ·  Delete…  ·  Admin →
    completed  ·  Priya Sinha responded

    This feature already exists in SQL Monitor.

15. Day of week is not considered in Analysis Graph when comparing this mont with last month

    When comparing this month's data with last month's data, the 1st of this month is compared with last month's 1st.
    This might not be relevant if, for example, the first of the current month was a Wednesday and the 1st of last month was a Saturday.

    When comparing this week with last week, this Monday is Always compared with last Monday asf.

    So, it would be nice to have a new option where the day of week is considered.

    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…)
    1 comment  ·  Delete…  ·  Admin →
    completed  ·  Priya Sinha responded

    SQL Monitor v3.4 is now released.

    The new features include:

    • Time ranges and comparison on the Analysis graph are fully customisable, making it easier to identify unusual patterns of behaviour.
    • There are now more ways to manipulate the Analysis graph, including clicking and dragging to change the time frame, and zooming in and out with the mouse wheel.

    Thanks,
    SQL Monitor Developement Team.

16. Overlap

    To analyse a trend over a period of say 30 days using one continuous line graph is difficult. If we could see a line for day 1, overlapped with day2, day 3 etc over the same 24 hour period then its easier to see trends and patterns e.g. processing time increases at 1pm everyday

    Regards

    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…)
    1 comment  ·  Delete…  ·  Admin →
    completed  ·  Daniel Rothig responded

    See the Baselining features introduced in SQL Monitor 3.5

17. Raise Alert level based on time

    Currently all alert levels are based on the numbers allocated and the alert is simply triggered at that level,

    Some of the values I'm tracking sit at 0 quite often, the problem is less the number but the length of time that it remains at that number

    So after 5 collections i would like to raise a low alert, after 10 collections a medium and after 20 a high alert

    Thanks for your time and concideration

    Ste

    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  ·  Delete…  ·  Admin →
    completed  ·  Daniel Rothig responded

    Hi this is planned for status alerts: https://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/11123793-reduce-the-number-of-false-positive-status-alerts

    For custom metrics that’s already possible via the custom metric wizard

    Thanks
    Daniel

18. 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 begin… 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

19. Push 5.2 Alias down to Analysis and beyond

    The write-up about the 5.2 Alias feature waxes almost lyrical about how much we would like it...

    Until you open the Analysis page and see the old names - in my case unintelligible I.P. addresses. Sad, very sad...

    Please make Aliases utterly pervasive, as in Analysis, Configuration => Monitored Servers (I.P. list), emails (just to make sure they're not overlooked).

    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…)
    1 comment  ·  Delete…  ·  Admin →
    completed  ·  Adam responded

    I’m closing this suggestion because the server aliases were fixed in v5.2.2.

    However, there is currently no way to alias cluster/machine names, so if this is important, please do raise this as a suggestion as we could look to address that if there is demand

20. Navigation for "rewind time" shouldn't hide navigation buttons

    The navigation controls for "rewind time" autohide when actively using this feature. Please consider enabling until "live" is chosen again to simplify operation to move back and forth in time increments.

    Issue submitting first time. if duplicate please close.

    •  

    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…)
    1 comment  ·  Delete…  ·  Admin →
    completed  ·  Adam responded

    Closing this because the v6 server overviews no longer have this particular time control so hopefully this bug is no longer relevant.