2020-07-07T06:09:00Z

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

Rony_Sklar - PeerSpot reviewer
  • 7
  • 145
PeerSpot user
10

10 Answers

Donald Bakels - PeerSpot reviewer
Reseller
Top 20
2020-07-08T09:22:30Z
Jul 8, 2020

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

Search for a product comparison in Network Monitoring Software
Sergiy Ustenko - PeerSpot reviewer
Real User
2020-07-09T11:20:43Z
Jul 9, 2020

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

Real User
2020-07-08T08:08:26Z
Jul 8, 2020

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.

WH
Real User
2020-07-08T03:40:53Z
Jul 8, 2020

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.  

MA
Real User
Top 5Leaderboard
2020-07-07T21:25:33Z
Jul 7, 2020

PRTG With SQL sensor


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

UM
Consultant
2020-07-07T13:20:18Z
Jul 7, 2020

You can use Solawind or BMC

Find out what your peers are saying about Zabbix, Datadog, Auvik and others in Network Monitoring Software. Updated: February 2024.
763,955 professionals have used our research since 2012.
MO
Real User
2020-07-07T11:29:53Z
Jul 7, 2020

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

IS
Vendor
2020-07-09T13:28:05Z
Jul 9, 2020

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. 


TS
Real User
Top 10
2021-11-17T08:49:55Z
Nov 17, 2021

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.

Muhammad-Bilal - PeerSpot reviewer
Real User
Top 10
2021-11-16T04:45:28Z
Nov 16, 2021

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.

Network Monitoring Software
Network Monitoring Software is a category of tools designed to monitor and manage computer networks.
Download Network Monitoring Software ReportRead more

Related Q&As