We changed our name from IT Central Station: Here's why
2020-07-07T06:09:00Z

What is the best tool for SQL monitoring in a large enterprise?


What tools do you recommend for SQL server monitoring for an enterprise-level business?

ITCS user
Guest
1010 Answers

author avatar
Top 5LeaderboardReal User

I highly recommend 2 products from the SolarWinds ITOM Suite;


1 Server Application Monitor Check link: https://www.solarwinds.com/server-application-monitor


1 Database Performance Analyzer for SQLServer https://www.solarwinds.com/database-performance-analyzer-sql-server



Both products are integrated

2020-07-08T09:22:30Z
author avatar
User

I use the Paessler (PRTG) for long time, and highly recommend one: https://www.paessler.com/database-monitoring

2020-07-09T11:20:43Z
author avatar
Real User

It is a very easy answer. For sure OpsMgr(SCOM). The simple reason is, Microsoft developed OpsMgr(SCOM) to monitor Microsoft products and the best to do this. NO other monitoring toolset can do it as good as OpsMgr(SCOM). OpsMgr(SCOM) can do 3rd party monitoring as well.

2020-07-08T08:08:26Z
author avatar
Real User

We have used Microsoft system center operations manager  and it integrates well with SQL.  We are starting to use open source tools and sending the metrics to Wavefront. This provides more real time monitoring but extensive development.  The main issue we have in our environment with SCOM is real time ability.  

2020-07-08T03:40:53Z
author avatar
Top 5LeaderboardReal User

PRTG With SQL sensor


Check this link: https://www.paessler.com/manua...

2020-07-07T21:25:33Z
author avatar
Top 10LeaderboardConsultant

You can use Solawind or BMC

2020-07-07T13:20:18Z
author avatar
Real User

I personally believe in SCOM (Operations Manager) since it contains all the required tools to monitor and manage SQL operationally. Majority of enterprises already have the Microsoft EA in place so the System Center licensing is already available along with SQL. 


.. in summary

2020-07-07T11:29:53Z
author avatar
Vendor

I am 100% biased as I work for Panopta, but I wouldn't work here if I didn't think our monitoring tools weren't outstanding. 


2020-07-09T13:28:05Z
author avatar
Top 10Real User

It is depending on what you need to monitor. Do you need to monitor transactions, or code or the SQL software and parameter values?


If it is for transactions, you have many tools. The best ones are Instana, Dynatrace. Both are easy to install and more importantly easy to configure. 


My favorite is Instana with Turbonomic.


For application code, you can use Datadog or SolarWinds.


For software, APM and all the above things you can use rufusai - a total solution for enterprises.

2021-11-17T08:49:55Z
author avatar
Real User

Micro Focus Operations Bridge Manager plus. 


The OBM Management Pack for Microsoft SQL Server helps administrators efficiently monitor distributed enterprise-wide Microsoft SQL Server environments from a central, best-in-class console.

2021-11-16T04:45:28Z
Find out what your peers are saying about Zabbix, Datadog, LogicMonitor and others in Network Monitoring Software. Updated: January 2022.
564,599 professionals have used our research since 2012.