In most of the organizations use certain monitoring tools to monitor all or subset of the servers in their environment and the monitoring tool will raise alerts to the DBAs and other groups when a certain alert condition is met. It is very important to have some alert mechanism because it is not possible to manually monitor all the servers 24×7 and the problems can arise at any time. No matter how proactive a DBA team is, still there are unexpected problems with SQL Server either directly caused by SQL Server or due to issues related to Hardware, Network, Operating System or other applications or tools.
One of the important role of SQL Server DBA is to respond to alerts received and fix them in timely fashion based on the severity. Some very senior DBAs may be involved in making decisions on which monitoring product to be used or if a custom monitoring solution is to be developed. Most often or not most organizations prefer using third party monitoring tools to avoid unnecessary costs of developing and maintaining the in house tools.
There are various third party monitoring tools available in the market so we need to choose the correct article which suits our requirement. This article has information regarding the processes or Criteria that can be followed to determine which Third party monitoring tool best suits your environment.
Below are some of the popular 3rd party Monitoring tools available in the market.
SQL Spotlight by Quest – SQL Spotlight from Quest monitoring tool is a very mature tool and provides many features or consists of many functionalities. This tool allows us to customize the alerts, not just the selection of the alerts but also we can customize the thresholds and severity. It can be customized to ignore alerts which are not required and allows to disable the alerts temporarily while the DBA team is working on the issue. This has central server where one can view various reports. There are limited options for level of details for SQL Server Monitoring and there is web based console for monitoring alerts.
SQL Diagnostic Manager by Idera – SQL Diagnostic Manager is one of the most popular and widely used monitoring tool. It provides basic alerting features and performance and server-monitoring options. It Provides a comprehensive view of current performance. Alerts and Thresholds can be configured and alerts can be snoozed during maintenance. This tool provides a central console from where we can manage all the servers and instances and also generate various reports. It is simple to install, configure and use, also the product support is good too. The price of the product is on higher side as the licensing mode in per SQL Server instance.
Microsoft Systems Center 2012 (SCOM) – Systems Center is a very powerful tool that can be used to monitor SQL Servers, Windows Servers and Windows Workstations. This comes with easy to use central management interface and Integrates well with all Microsoft products and can be used on Windows and SQL Servers. We can manage and generate reports from centralized server. However this tool is not easy to configure and lacks monitoring SQL Server compared to other third party monitoring tools. This has a complex licensing model involving per processor licenses.
SQL Monitor by RedGate – SQL Monitor from Red Gate is a lightweight tool which is easy to install and configure and simple to use. This tool is an effective monitoring solution for simple to moderately complex environments. The licensing model of this tool is per instance which makes it costlier compared to other tools with similar features. This can be bundled with other tools like Backup tools and works well.
ApexSQL Monitor – ApexSQL Monitor tool provides alerting and performance monitoring options. All monitored performance parameters can be viewed from the dashboard on central server. We can see real time activity as well as we can configure it to send alerts to the DBA groups for various alerts. ApexSQL Monitor doesn’t install any agents to collect performance metric values. The data is collected using the tools already available in the operating system and SQL Server. This approach eliminates the need for installation of any additional agents, thus avoiding the situation when agent installation is not possible due to insufficient permissions and company policies.
This is applicable on below versions of SQL Server
SQL Server 2005
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014
Hope this was helpful.
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.