These pages cover SQL Monitor 10, which is not the latest version. Help for other versions is also available.

Monitoring servers without sysadmin permissions

If you are unable to grant sysadmin permissions on monitored servers to the monitoring account, follow this guide to configure SQL Monitor and prevent it from attempting to perform actions which require sysadmin permissions. You can find a list of required permissions here.

Sysadmin is required by SQL Monitor to run the DBCC DBINFO command to determine the last integrity check for a database (required for the Integrity check overdue alert) as well as enabling the deadlock trace flag to collect deadlock information (not required when using Extended Events for deadlock collection). To prevent SQL Monitor from trying to perform these actions, you will need to disable collection for the Integrity check overdue alert

If you wish to still get Deadlock alerts, you must either enable Extended Events for deadlock monitoring or enable the SQL Server trace flag 1222 on your monitored servers

Disabling integrity check collection

Follow these steps on the machine where you have installed the SQL Monitor Base Monitor service:

  1. Open the following folder: %programdata%\Red Gate\SQL Monitor 
  2. Make a copy of the RedGate.SQLMonitor.Engine.Alerting.Base.Service.exe.settings.config file and store it.
  3. Open the original file and locate the <collectionSchedules> section.
  4. Add the following new schedule:

    collectionSchedule Toggle source code

    1. <schedule qualifiedChannelName="[Cluster].[SqlServer].[Database].[IntegrityCheck]">
    2. <disabledSchedule />
    3. </schedule>
  5. A default file with this addition will have a <collectionSchedules> section like the following:

    Full collectionSchedule Toggle source code

    1. <collectionSchedules>
    2.  
    3. <!-- Four schedules are available:
    4. intervalSchedule
    5. ****************
    6. parameters
    7. interval="hh:mm:ss"
    8.  
    9. Collect every hh:mm:ss. The full accepted format is "d.hh:mm:ss.ff".
    10. [ref: http://msdn.microsoft.com/en-us/library/se73z7b9%28v=VS.90%29.aspx ]
    11.  
    12.  
    13. disabledSchedule
    14. ****************
    15. (no parameters)
    16.  
    17. A special schedule that disables collection.
    18.  
    19. dailySchedule
    20. *************
    21. parameters
    22. hour="hh"
    23. minutes="mm"
    24.  
    25. collect once a day, at the specified local time (24-hour clock)
    26.  
    27. weeklySchedule
    28. **************
    29. parameters
    30. dayOfWeek="dddddd"
    31. hour="hh"
    32. minute="mm"
    33.  
    34. Collect once a week, at the specified local time, on the specified day. Day names are taken from
    35. the set (Monday .. Sunday)
    36. [ref: http://msdn.microsoft.com/en-us/library/system.dayofweek.aspx ]
    37.  
    38.  
    39. If a schedule parameter is specified incorrectly, the Base Monitor service will fail to start. A full reason will
    40. be logged to the Red Gate section of the Event Log.
    41.  
    42. The metric is specified by a qualifiedChannelName.
    43.  
    44. NB. All schedule times are in the local time zone of the Monitoring Service not UTC
    45. -->
    46.  
    47. <!-- Examples
    48. <schedule qualifiedChannelName="[Cluster].[Machine].[Process]">
    49. <intervalSchedule interval="00:01:00"/>
    50. </schedule>
    51. <schedule qualifiedChannelName="[Cluster].[SqlServer].[Database]">
    52. <disabledSchedule />
    53. </schedule>
    54. <schedule qualifiedChannelName="[Cluster].[SqlServer].[Database].[Table]">
    55. <dailySchedule hour="1" minute="0" />
    56. </schedule>
    57. -->
    58. <schedule qualifiedChannelName="[Cluster].[SqlServer].[Database].[IntegrityCheck]">
    59. <disabledSchedule />
    60. </schedule>
    61. <schedule qualifiedChannelName="[Cluster].[SqlServer].[Database].[Table].[Index]">
    62. <weeklySchedule dayOfWeek="Sunday" hour="1" minute="00"/>
    63. </schedule>
    64. </collectionSchedules>
  6. Save and close the file.
  7. Restart the SQL Monitor Base Monitor service.




Do you have any feedback on this documentation?

Let us know at sqlmonitorfeedback@red-gate.com


Didn't find what you were looking for?