Saturday, August 11, 2018

Monitoring Tools for SQL Server Administrator

Hey DBAs,

In this post we can see the list of necessary tools for SQL Server DBAs.

Idera's SQL diagnostic manager:

It is a performance monitoring and diagnostics solution that proactively alerts administrators to health, performance, or availability problems within their SQL Server environment. SQL diagnostic Manager allows DBAs to discover potential and existing problems, analyze the state of their SQL Server enterprise, and generate reports.
https://www.idera.com/resourcecentral/videos/how-to-setup-sql-diagnostic-manager


Pearl Knowledge Solution's SQL Centric

SQL Sentry Performance Advisor

ApexSQL Monitor

Red-Gate SQL Monitor

SQLTreeo

Microsoft's SQL Server Database Engine Tuning Advisor

Microsoft's SQL Server Profiler:
It is going to depreciated soon and will replaced by Extended Events.

Microsoft's System Monitor

ManageEngine SQLDBManager Plus

Lepide SQL Storage Manager

Heroix Longitude

Azure Explorer (Red Gate Software)