Documentation.red-gate.com

Global Dashboard

At the very top of the Global Dashboard, we see the number of instances being monitored by SQL Monitor and we can filter and order the tiles by various means. You can filter theSee more

Actived: 5 days ago

URL: https://documentation.red-gate.com/sm/performance-and-activity-monitoring/dashboards-and-overviews/global-dashboard

Performance and activity monitoring

WebDashboards and Overviews – using these pages you can review and analyze the health and activity of your monitored SQL Servers. For example: Investigate which …

Category:  Health Go Health

SQL Server performance and activity monitoring

WebDashboards and Overviews – using these pages you can review and analyze the health and activity of your monitored SQL Servers. For example: Investigate which …

Category:  Health Go Health

Global Dashboard

WebThe middle band of each tile gives an indication of the recent "health" of each instance. It shows the most severe current or recent alert type raised on an …

Category:  Health Go Health

Using SQL Monitor for the first time

WebSelect the servers you want to monitor. Under Configuration > Monitored servers, click Add SQL Server (or Add Azure SQL Server if adding an Azure SQL DB …

Category:  Health Go Health

SQL Server performance and activity monitoring

WebDashboards and Overviews – using these pages you can review and analyze the health and activity of your monitored SQL Servers. For example: Investigate which …

Category:  Health Go Health

What is SQL Monitor

WebSQL Monitor is a SQL Server and PostgreSQL monitoring and alerting tool, designed to help DBA teams proactively manage any number of instances, whether they …

Category:  Health Go Health

Using SQL Monitor for the first time

WebGo to the Global Overview page to see the current health of your monitored servers and databases. All your monitored servers should be displayed as tiles, showing …

Category:  Health Go Health

What is SQL Monitor

WebA Base Monitor service continuously monitors the availability, health and performance of all of these SQL Server instances, collecting and assessing a range of …

Category:  Health Go Health

Availability group overview

WebThe State column shows the health state of each replica or database, along with the commit mode in parentheses next to each replica. The Failover column shows …

Category:  Health Go Health

Working with overviews

WebThe overviews in SQL Monitor show the current health of your monitored servers and are arranged into a hierarchy: The overview pages update automatically …

Category:  Health Go Health

Monitoring SQL Server Failover Cluster Instances and AlwaysOn

Webthe health probe is the one created to track the active instance; there should be no session persistence; floating ip (direct server return) should be disabled . Adding …

Category:  Health Go Health

Monitoring SQL Server Failover Cluster Instances and AlwaysOn

WebThe health probe is the one created to track the active instance. There should be no session persistence. Floating ip (direct server return) should be disabled. …

Category:  Health Go Health

Setting maintenance windows

WebTo edit the maintenance window settings: for a single machine, in the Maintenance window column, click Edit. Make your changes, then click Apply. for …

Category:  Health Go Health

Creating, configuring and downloading reports

WebCreating a report. Navigate to the Reports page. Click the "+ New report" button: Enter a report name and select whether you would like the report to be emailed …

Category:  Health Go Health

Setting maintenance windows

WebSetting a maintenance window. Go to the Configuration tab and under Monitoring, select Monitored servers. Use the check boxes in the Server column to select …

Category:  Health Go Health

Creating custom metrics and alerts

WebTo create a custom metric: Go to the Configuration tab. Under Alerts and metrics, select Custom metrics: The first page of a simple, three-step wizard is displayed. …

Category:  Health Go Health

What to try if you hit connection problems

WebCheck the Monitoring Status and the SQL Monitor logs. Go to Configuration > Monitored Servers in the web interface: The Status column will tell you whether the …

Category:  Health Go Health

Tracking Disk Space Usage and Database Growth

WebIt is rare for a database to suddenly run out of space. These events are predictable if you are aware both of changes to the free space on the storage and the …

Category:  Health Go Health