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?

Rony_Sklar - PeerSpot reviewer
Community Manager at a tech services company with 51-200 employees
  • 7
  • 131
10
PeerSpot user
10 Answers
TS
CEO at Rufusforyou LLC
Real User
Top 5
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.

Search for a product comparison in Network Monitoring Software
Muhammad-Bilal - PeerSpot reviewer
Integration Consultant at Multilynx
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.

Donald Bakels - PeerSpot reviewer
Chief Executive Officer (CEO) at Adfontessoftware
Reseller
Top 5Leaderboard
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

Sergiy Ustenko - PeerSpot reviewer
Marketing Manager at Idealsoft
Real User
Top 5
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
User at a retailer with 10,001+ employees
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.  

Learn what your peers think about IBM SevOne Network Performance Management (NPM). Get advice and tips from experienced pros sharing their opinions. Updated: May 2023.
708,830 professionals have used our research since 2012.
MA
Technical & Pre-Sales Manager at GateLock
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
IT Consultant at a tech services company
Consultant
2020-07-07T13:20:18Z
Jul 7, 2020

You can use Solawind or BMC

MO
Lead specialist at OKCIUS (Pty) Ltd
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
Sales Development Representative at Panopta
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. 


Related Questions
SS
User at Rank IT
Dec 7, 2022
Hello Peers,  I am looking for the best network monitoring software. Which product would you choose: Nagios XI, PRTG Network Monitor, or SolarWinds Server and Application Monitor? What are the pros and cons of the solution? Thank you for your help.
See 1 answer
PG
Senior Software Engineer at a tech services company with 201-500 employees
Dec 7, 2022
Hi, Please share your complete monitoring requirement along with No. of devices for monitoring with their type (Unix/Linux Server, Web Server, Routers, etc.).
Shibu Babuchandran - PeerSpot reviewer
Regional Manager/ Service Delivery Manager at a tech services company with 201-500 employees
Dec 7, 2022
Hi community, I work as the Regional Manager at a Tech Services company. Currently, I'm exploring open-source Network Analyzer and Network Configuration managers.  Which one would you recommend and why?
2 out of 5 answers
FN
CEO/Founder at Zen Networks
May 10, 2022
Hello,  For Network Analyzer, you can use Elastiflow. It's pretty complete even though its development has stopped lately (we have recently deployed it in production for a customer). It is still just as good as it was a few years ago. For Network Configuration Management, it really depends on the sets of features you're looking for. But, you can use the Ansible & Gitlab combo. We've written a full tutorial for it on our website: https://www.zen-networks.io/ne... Good luck!  
TS
CEO at Rufusforyou LLC
May 11, 2022
I recommend checking Riverbed, depending on what you need: SNMP, MIB, or Flow. They have many tools available but they are not open source.  
Related Articles
Ariel Lindenfeld - PeerSpot reviewer
Director of Community at PeerSpot
Aug 21, 2022
We’re launching an annual User’s Choice Award to showcase the most popular B2B enterprise technology products and we want your vote! If there’s a technology solution that’s really impressed you, here’s an opportunity to recognize that. It’s easy: go to the PeerSpot voting site, complete the brief voter registration form, review the list of nominees and vote. Get your colleagues to vote, too! ...
AS
Director, Middle East, East India & SAARC at DMX Technologies
Aug 26, 2022
Modern-day servers are robust enough to accommodate as many applications and processes as possible. Still, there is a limit to how much load a server can handle. If your business does not heed the server constraints in time, you are bound to suffer from operational loss due to server downtimes. To closely monitor your server health, you must track specific metrics regularly. Here are some s...
See 1 comment
AW
Marketing & PR Specialist at AdRem Software
Aug 26, 2022
Collecting as many metrics, statuses, and logs about the servers is indeed the first step, you never know what data you will need to solve a particular problem. The second step is to process and correctly pinpoint where the network performance/behavior differs from the expected range/baseline.  Can your network monitoring software automate the obvious (execute remote corrective actions in response to alerts) and notify the IT person about only critical situations where the human needs to make a decision about the resolution options? We expect the network monitoring software today to do just that.  I would say NetCrunch can do it, but do you have any experience with other monitoring products that provide a similar type of monitoring experience for IT teams?
NC
Content Manager at PeerSpot (formerly IT Central Station)
May 2, 2022
PeerSpot’s crowdsourced user review platform helps technology decision-makers around the world to better connect with peers and other independent experts who provide advice without vendor bias. Our users have ranked these solutions according to their valuable features, and discuss which features they like most and why. You can read user reviews for the Top 8 Network Monitoring Software Tools ...
Related Articles
Ariel Lindenfeld - PeerSpot reviewer
Director of Community at PeerSpot
Aug 21, 2022
PeerSpot User's Choice Award 2022
We’re launching an annual User’s Choice Award to showcase the most popular B2B enterprise technol...
AS
Director, Middle East, East India & SAARC at DMX Technologies
Aug 26, 2022
7 Most Important Metrics of Server Monitoring Software
Modern-day servers are robust enough to accommodate as many applications and processes as possibl...
Download Free Report
Download our free IBM SevOne Network Performance Management (NPM) Report and get advice and tips from experienced pros sharing their opinions. Updated: May 2023.
DOWNLOAD NOW
708,830 professionals have used our research since 2012.