Colin Millerchip, Product Manager at Redgate, talks you through the major new features in SQL Monitor 5, including:
Active Directory integration (00:39)
AlwaysOn Availability Group support (03:12)
To find out more about SQL Monitor, visit http://www.red-gate.com/sql-monitor
Hi, my name is Colin Millerchip, and I work at Redgate Software as part of the team developing SQL Monitor. In this short video, I’m going to introduce you to SQL Monitor version 5, which we released in October 2015.
If you’re not already familiar with SQL Monitor, it’s a performance monitoring tool that helps you manage your SQL Servers, keeping an eye on them 24-7, alerting you to problems or potential problems, helping you diagnose the root cause and keep your system up and running.
Version 5 has two new key features: Active Directory integration, and improved support for AlwaysOn Availability groups.
First let’s look at active directory integration.
You can now use your Windows credentials to log into SQL Monitor, and SQL Monitor administrators have granular control over which monitored servers you’re allowed to see. This improves collaboration, for example, giving developers performance insights into production servers without having to grant them direct access, or allowing your BI team to only see the servers relevant to them. It also allows you to share administration duties across the team of people who are looking after your servers.
• To enable Active Directory integration, go to the configuration tab, and select Authentication settings
• By default, SQL Monitor uses built-in credentials. To switch to using Active Directory, select this as your authentication type
• Now configure the domain information, and select a service account used to query Active Directory.
• Save the settings…
• … and SQL Monitor will ask you to set up a user as administrator.
• Now, log on as this admin user
• … and you’ll be taken to the configuration screen where you can add in any users who you want to give access to SQL Monitor. You can add individual users, as well as groups of users.
• For standard users...
• … not only do you restrict their access to some of the more administrative features of SQL Monitor (such as license management), but you can restrict the set of servers that they can manage.
All the authorization data is stored internally within SQL Monitor, so this feature requires no modification of your Active Directory domain.
Now let’s look at Availability Group support.
Prior to version 5, SQL Monitor would monitor the host machines running an AlwaysOn Availability Group, but had no Availability Group-specific features.
With the introduction of version 5, SQL Monitor now has Availability Group overviews, alerts, metrics, and wait types.
The overview gives you an at-a-glance view of the status of an Availability Group. You can see information about Availability Group specific alerts, … the state and failover information for availability replicas and databases, … and key availability database metrics
Further details on the meaning of these fields and their values can be found in the product documentation.
As for any other overview in SQL Monitor, you can drill through to see details of alerts or metrics.
SQL Monitor version 5 ships with 7 pre-configured Availability Group alerts, covering areas including the health of Availability Group databases and replicas, whether replication is falling behind, and whether replication is slowing down query execution on your primary replica. Of course, these metrics can be extended using SQL Monitor’s custom metrics and alerting features.
Time series data collected from Availability Groups is available within the Analysis tab. Again, you can drill through from the overviews to get this.
If you are already monitoring host machines running Availability Groups, then upgrading to version 5 will automatically provide you with these Availability Group features.
As to other changes in version 5:
If you’re already familiar with SQL Monitor version 4, you’ll have noticed that we’ve refreshed the user interface, both to make it easier to use, and to make the UI faster and more responsive.
Other changes include improving the stability of the monitoring service; and SQL Monitor version 5 has been fully tested against community technology previews of SQL Server 2016,
If you want to find out more about SQL Monitor, visit the product homepage, and better still give us a call to arrange a demo or get help with your evaluation.