SQL Monitoring tools
-
our client wants to implement Third Party SQL Monitoring tool to monitor SQL server Performance. I would like to understand any recommendation that is being implemented to monitor the performance.
-
Idera, Redgate, a few others. They probably offer a free trial so you can find what's best for you.
-
Please see Brent Ozar's recommendations:
https://www.brentozar.com/archive/category/production-database-administration/monitoring/
DBASupport
-
Third party monitoring tools could cause performance issues for your database platform unless you know how to use them properly.
I would write your own tools if you can.
DBASupport
-
Hi,
When you look around, there are two approaches. Tools with an agent, and tools without an agent. All tools bring some load, but usually, this load is negligible.
As my predecessors have already mentioned, there are trial versions that can be used for free for 30 days
Good luck,
Andreas
-
I created DBA Dash. It's a Windows service that collects data from your SQL instances into a central repository database. There is a Windows GUI app front-end. It will help you get to the root cause of almost any performance issue & will also assist with daily DBA checks. It's private, self-hosted, free & open source.
DBA Dash - Free, open source monitoring for SQL Server
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply