What tools do you recommend for SQL server monitoring for an enterprise-level business?
I use the Paessler (PRTG) for long time, and highly recommend one: https://www.paessler.com/database-monitoring
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
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.
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.
PRTG With SQL sensor
Check this link: https://www.paessler.com/manua...
You can use Solawind or BMC
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
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.