Few resources carry as much important information as databases. Small oversights and mistakes can lead to database outages and losing some of your most important data.
Taking your eye off the ball could very easily lead to your database metrics exceeding capacity limits.
Here is our list of the best database monitoring tools & software:
- SolarWinds Database Performance Analyzer for SQL Server EDITOR’S CHOICE Includes real-time performance monitoring plus analysis functions. Runs on Windows Server. See how your code works with root cause analysis, start a risk-free 14-day free trial.
- Datadog Database Monitoring (FREE TRIAL) A cloud-based application monitoring service that includes database performance checks.
- ManageEngine Applications Manager (FREE TRIAL) Includes monitoring screens for both SQL-based and NoSQL databases. Runs on Windows Server and Linux.
- SolarWinds AppOptics APM (FREE TRIAL) A comprehensive cloud-based application performance monitor that includes specialized processes for monitoring databases
- Site24x7 Server Monitoring (FREE TRIAL) An online monitoring package that includes SQL monitoring and analysis functions.
- Paessler PRTG Network Monitor (FREE TRIAL) Database monitoring functions are part of this all-in-one network, server, and applications monitor. Runs on Windows Server.
- SentryOne SQL Sentry (FREE TRIAL) Live database performance monitoring with automated index defragmentation.
- Atera A remote management solution for managed service providers that includes database backup automation and supervision.
- dbWatch Database Control A data-base focused tool that unifies monitoring for all databases in an enterprise operated by SQL Server, Oracle, Sybase, MariaDB, MySQL, and Postgres.
- Idera SQL Diagnostic Manager A specialist database monitor for MySQL or SQL Server.
- AimBetter This SaaS system remotely monitors database performance and includes the services of database experts for SQL Server, Oracle, and SAP.
- SQL Power Tools Logs database performance metrics and scans for anomalous behavior to detect any intrusions.
- Red-Gate SQL Monitor Real-time database monitor with color-coded statuses and some great data visualizations.
- Lepide SQL Server Auditing A database monitor that is prized for its cybersecurity features.
- ManageEngine Free SQL Health Monitor A competent free database performance monitor from a leading infrastructure management producer.
- Spiceworks SQL Server Monitoring Free, ad-supported database performance monitor.
The best database monitoring tools
The bigger the server, the more CPU and memory are needed to process the data. Using a database monitoring tool is the only reliable way to monitor databases. Similarly, the widespread use of SQL Servers has made monitoring SQL Servers a top priority for monitoring SQL server performance.
1. SolarWinds Database Performance Analyzer for SQL Server (FREE TRIAL)
Our methodology for selecting a database monitoring tool
We reviewed the database monitoring tools market and analyzed tools based on the following criteria:
- The ability to attach to database instances from different DBMSs
- SQL query troubleshooting and optimization
- Database resource and server resource monitoring
- Alerts for resource shortages and performance deterioration
- An easy-to-use interface
- Secure access procedures that include authentication and multiple user accounts
- A free trial, demo, or money-back period for no-risk assessment
- A reasonable price that reflects the quality of the product and offers value for money
SolarWinds Database Performance Analyzer for SQL has become a core tool for network administrators looking to address database problems in real time. You can monitor your server performance through the dashboard and verify the status of a server’s database queries, CPU, memory, disk, and sessions. Problematic devices are denoted as yellow for Warning and red for Critical. You also have the ability to view graphs of your server health to see all emerging trends.
Key Features:
- Watch query activity
- Track resource usage
- Spot resource shortages
- Monitor on-premises and cloud databases
What makes this platform special is its root cause analysis ability. The foundation of this is the opportunity to view how the code works. This gives you the ability to look beyond the basics through the use of multi-level permissions and group-based policies. This is a refreshing approach because it takes you away from the database metrics to look at the code beneath the surface.
It is fair to say that SolarWinds Database Performance Analyzer doesn’t fall victim to being a one trick pony either. With this tool, users can monitor a variety of databases. SQL Server, MySQL, DB2, Aurora, virtualized, and cloud databases can all be monitored through this program. The variety of options means that this program functions well in most enterprise environments.
If you’re looking for a database monitor that helps you to identify problems and pinpoint the cause in real-time, then this is a program you should definitely consider. SolarWinds Database Performance Analyzer is available from a price of $1,995 (£1,562). It is also available to download on a 14-day free trial.
Pros:
- Highly intuitive DB management system tailored for medium to large size database implementations
- Monitors in real-time, offering a number of alert and notification options that can integrate into popular helpdesk solutions
- Threshold monitoring helps keep teams proactive, and fix issues before they impact performance
- Dashboards are highly customizable and can be tailored to individuals or teams
- Built-in query analysis helps DBAs build more efficient queries
- Leverages machines learning to identify performance bottlenecks
Cons:
- Could benefit from a longer 30 day trial period
2. Datadog Database Monitoring (FREE TRIAL)
EDITOR’S CHOICE
The Database Performance Analyzer offers cross-platform support for on-premises or cloud installations. High-powered anomaly detection engine, index and query tuning advisors and an interface that doesn’t leave you guessing are available straight out-of-the-box. Real-time and historical data presentation is the icing in the cake.
Get 30 Day Free Trial: solarwinds.com/database-performance-analyzer
OS: Windows, Linux or Unix, Azure Marketplace, or AWS launch
Datadog Database Monitoring is a SaaS application monitor that includes extensive database monitoring capabilities. The Datadog system includes AI machine learning techniques that establish normal performance profiles for applications and infrastructure over time. This enables the system to automatically set alert thresholds and cut down the number of notifications that administrators receive.
- Hosted SaaS package
- 400 DBMS integrations
- AI-based query assessments
- Performance analysis
It includes over 400 turn-key integrations including Cassandra, Redis, PostgreSQL MongoDB, SQL Server, MySQL, and more.
Although alert thresholds are set automatically, they can be adjusted and it is also possible to create custom conditions that would trigger alerts. These can be created by combining existing performance checks by using a straightforward SQL query tool.
The performance monitor has a lot of database performance visualizations and, when combined with infrastructure or website monitoring modules, can show exactly where any performance issue in your IT system originates. The APM will cover server performance metrics as well as application delivery checks.
The screens of Datadog enable fast problem recognition through charts, maps, and color coding and they include a number of troubleshooting investigative tools. The user can reorganize graphs to create a simultaneous performance stack to make analysis easier.
As a cloud-based service, Datadog can monitor databases wherever they are. So, you can centralize the monitoring of services located on several different sites and it is also possible to watch cloud databases with this system.
There is a certain amount of service performance logging with the Datadog APN package. However, to get standard database logs and other system logs analyzed properly, you would probably need to get the company’s log management module as well – it is called Ingest.
Datadog visualizations and performance analysis reports are great for communicating the current state of your databases and their future needs to stakeholders. Information can be distributed through an integration with Slack, or through other team collaboration tools.
Datadog Database Monitoring and all other Datadog modules can be experienced on 14-day free trials.
Excellent graphic options for monitoring multiple metrics
Highly customizable dashboards, great for NOC teams
Cloud-based monitoring – can be accessed from anywhere
400+ integrations can support nearly any database deployment
Would like to see a longer trial period
Datadog Database Monitoring Start 14-day FREE Trial
3. ManageEngine Applications Manager (FREE TRIAL)
ManageEngine offers database monitoring as part of its Applications Manager system. This software package also covers server performance, so you can drill down and examine the physical support for your databases as well as checking on the operating metrics of your databases.
- Monitors demand
- Tracks resource availability
- Analyzes database performance
The monitoring services of the Applications Manager have specialized procedures to monitor relational databases, including Oracle, MS SQL, MySQL, IBM Informix, IBM DB2, Sybase, and PostgreSQL. NoSQL databases are also included in the monitoring capabilities of Applications Manager. This includes Oracle NoSQL, MongoDB, Cassandra, Couchbase, and Apache HBase. Big data stores, such as Hadoop and in-memory databases, including Oracle Coherence, SAP HANA, and Redis and also covered.
The monitor will watch database-specific metrics and also examine the dependencies of other applications that rely on databases, such as web servers, and how the interactions between the server and the database management systems perform.
The main database performance monitoring screen in the Applications Manager is tabbed. This removes the need to constantly leave the environment and go back to the main Applications Manager menu in order to observe other categories of database statuses.
The monitoring tool will show live response times as an overall statistic for all databases, allowing a drill down on metrics per DBMS and then per instance. Monitoring categories include database-wide factors, such as memory and disk usage, I/O speeds, and buffer statuses. It also has transaction information on all SQL performance, which can also be analyzed. These different tabs offer a range of monitoring services that cover hour-by-hour service requirements and analytical tools for database optimization and query refinements.
ManageEngine Applications Manager installs on Windows Server and Linux. All of the server and application monitoring capabilities of the tool are available to all buyers – there aren’t any partial versions or incremental purchase plans. The tool is available for a 30-day free trial.
Offers on-premise and cloud deployment options, giving companies more choices for install
Can highlight interdependencies between applications to map out how performance issues can impact businesses operations
Offers log monitoring to track metrics like memory usage, disk IO, and cache status, providing a holistic view into your database health
Can automatically detect databases, server hardware, and devices in real-time
Can take time to fully explore all features and options available
ManageEngine Applications Manager Fully Functional Free 30 Days Trial
4. AppOptics APM (FREE TRIAL)
AppOptics APM is a cloud-based service from SolarWinds that monitors the performance of applications and the infrastructure that supports them. A lower edition, called AppOptics Infrastructure just focuses on the performance of equipment and doesn’t include the application performance monitoring features of the APM package.
- Application dependency mapping
- Spots resource contention
- SQL optimization
APM has specialist screens for different applications, including databases. The service can interact with a long list of database management systems including Microsoft SQL Server, MySQL, Oracle, Postgres, and Apache DBMSs.
The tool can examine queries as they run on your database, spotting those that seem to be taking too long or behaving inefficiently. When the monitor spots a poorly performing query, it makes a trace file of all of the database transactions that it performs, which enables further analysis. Other features in the tool examine the code of programs that include SQL database queries and also any batch files and SQL scripts that you might have on your system. This feature identifies lines of code and clauses in SQL that should be altered to improve performance.
The AppOptics APM service isn’t restricted to just monitoring databases and applications running on your site. It is also able to supervise the performance of applications running on rented virtual servers run by AWS or Azure servers. If you have a hybrid on-premises/cloud system, then that can be monitored by the service as well.
As a cloud service, AppOptics is charged for by subscription. The service has a flat fee per year and it doesn’t matter how many staff access the service. As well as the APM and infrastructure-only plans, SolarWinds offers a cheaper Metrics Pack. However, to get database monitoring features, you have to go for the APM edition. You can get a 14-day free trial of AppOptics APM.
- Offers great visualizations reflecting live and historical health metrics and resource consumption
- Is easily scalable, built as a cloud service
- Tracks all major resources such as CPU, memory, and network usage
- Can monitor Docker, Azure, and Hyper-V platforms, offering more flexibility than competing options
AppOptics APM Start 14-day FREE Trial
5. Site24x7 Server Monitoring (FREE TRIAL)
Site24x7 Server Monitoring offers network, server, and application monitoring. This combination is ideal for keeping the performance of your databases in a good state. The system is a cloud-based service, so you don’t have to install any database monitoring software to use it. This configuration makes it a great tool for monitoring remote sites and it also works well for MSPs.
- Tracks all application activity
- Dependency mapping around the database
- Performance optimizer
The application monitors in this bundle include a database performance optimizer. It will automatically discover all of your databases and install agents to keep tabs on them. These agents report back to the central Site24x7 system, where you can access results through a browser.
Performance metrics are shown live on the screen, and you can set alert parameters that enable you to head off overloading. As the tool can monitor any number of instances, it is a good assistant for coordinating between distributed databases and between production and development environments. The reporting utility in the tool will help you analyze the performance of your databases over time.
Given that you get dedicated server monitoring with this support tool, it is easy to identify the cause of performance impairment. You can explore through supporting resources to find exactly which element of the stack is dragging down the performance of your databases.
Site24x7 is charged for on a subscription model and the different plans and add-on options make it possible to create a custom package that is tailored to your business’s needs. There is even a free version, which limits monitoring to just five servers. You can try out the system on a 30-day free trial. If you decide not to buy at the end of that period, your account gets switched over to the free edition.
Flexible cloud-based monitoring option
Offers a host of out-of-box monitoring options and dashboard templates
Allows administrators to view dependencies within the application stack, good for building SLAs and optimizing uptime
Offers root cause analysis enhances by AI to fix technical issues faster
Site24x7 is a feature-rich platform withfeatures that extended beyond databases management – may require time to learn all options and features
Site24x7 Server Monitoring Start 30-day FREE Trial
6. Paessler PRTG Network Monitor (FREE TRIAL)
Next, we have Paessler PRTG Network Monitor, a network monitoring tool that boasts a sizeable SQL monitoring ability. This program can monitor common databases such as Microsoft SQL, MySQL, Oracle SQL, and PostgreSQL. In other words, it covers everything needed to provide a solid foundation of visibility on most enterprise networks.
- Alerts for long execution times
- MySQL, SQL Server, Oracle, and PostgreSQL
- Resource utilization monitoring
For a network monitoring tool, PRTG Network Monitor is also straightforward to set up. PRTG Network Monitor comes equipped with sensors that have been configured out of the box. These pre-configured settings cover most large database providers like Microsoft SQL, MySQL, and Oracle SQL. This has the advantage of eliminating the need for you to configure your configurations from nothing.
PRTG Network Monitor can be used to monitor the execution time for an SQL query. The tool will measure the time from the moment the connection was established right through the transfer to the end of the connection. This allows you to clearly see the performance of your database under pressure.
Overall, PRTG Network Monitor is a product that combines general network monitoring ability while simultaneously providing a compelling experience for database monitoring. There are several pricing options available for PRTG Network Monitor. This starts with a freeware version of PRTG Network Monitor, which allows the monitoring of up to 100 sensors for free.
The first paid version of PRTG Network Monitor costs $1600 (£1253) for 500 sensors. The next three products for larger organizations cost $2850 (£2,232) for 1000 sensors, $5950 (£4,662) for 2500 sensors and $10500 (£8,227) for 5000 sensors. Organizations that need to monitor even more can download the XL1 Unlimited version, which supports unlimited sensors for $14500 (£11,361). There is also a 30-day free trial available for downloaded.
Offers dozens of preconfigured sensors supporting multiple databases
Fully customizable dashboard is great for both lone administrators as well as NOC teams
Drag and drop editor makes it easy to build custom views and reports
Supports a wide range of alert mediums such as SMS, email, and third-party integrations into platforms like Slack
Sensors can be customized, allowing you to only pull the metrics you want to monitor
Supports a freeware version
Is a very comprehensive platform with many features and moving parts that require time to learn
Paessler PRTG Network Monitor Download 30-day FREE Trial
7. SentryOne SQL Sentry (FREE TRIAL)
SentryOne SQL Sentry is a product that takes an old-school approach to database monitoring. The user interface doesn’t have the same sheen as some of the other products on this list, but it gets the job done just fine. With SQL Sentry you can view real-time data on your databases through the performance monitoring dashboard. All the data displayed allows you to see how available your SQL servers are critically.
- Performance alerts
- Deadlock analysis
- Index management
Like other top-end database monitoring products, SQL Sentry also has its own alerts system. In fact, there are over 100 alerting conditions available out of the box. These alerts notify you both when servers go down and when databases are taking too long to process data. You can even customize your alert message text to help your staff to respond to problems more effectively.
This program also offers automated index defragmentation and visual deadlock analysis. It helps you to know exactly when you need to perform defragmentation. This is informed by a combination of live and historical data so that you can get a balanced perspective.
In many ways, SentryOne SQL Sentry is a program that deserves more attention as it offers a database monitoring experience that is much more sophisticated than its initial appearance. SentryOne is available as a License or a Subscription. The License version can be purchased for $2,495 (£1,955) and provides technical support and updates. The Subscription version can be purchased for $125 (£97.95) per month. There is also a 14-day free trial available for download.
Dedicated to monitoring specifically only SQL, good for companies that already have other app monitoring tools they’re happy with
100+ alerts and templates customized around SQL server health monitoring
Supports root cause analysis for faster resolution times
Pricing is on the higher end
Can’t offer monitoring outside the scope of SQL databases
SentryOne SQL Sentry Start 14-day FREE Trial
8. Atera
Atera is a cloud-based service that supports managed service providers (MSPs). The platform includes both remote monitoring and management (RMM) and professional services automation (PSA). So, it includes all of the software that an MSP needs to conduct its business.
- Designed for MSPs
- Remote monitoring
- Network, server, and application performance monitoring
The monitoring features of Atera include the tracking of live statuses and also database log file monitoring. Any database problems that arise will be caught by one of those two methods and converted into alerts in the system dashboard.
One of the remote management services included with the Atera RMM is the ability to manage database backup and recovery procedures through the tool. This feature doesn’t implement the backup and restore process directly – it is better to use the native procedures built into the DBMS. However, the Atera interface can interact with the DBMS of multiple vendors, which means that a systems administrator working as part of an MSP team can perform all backup and recovery tasks through one dashboard.
The Atera system can interact with the database management systems for MS SQL Database Server, MySQL, and Oracle.
As an online service, Atera is billed on a subscription basis. Prices are levied per technician per month, which makes the service ideal for a small MSP or independent technician. The prices are lower for those who opt to pay annually. However, the service has to be paid for in advance whichever billing period you choose.
Atera is available in three editions: Pro, Growth, and Power. All editions include the regular database status monitoring feature and all include database backup and recovery procedures. However, the top plan, Power, also includes the ability to store database snapshots. Atera is available for a 30-day free trial.
Lightweight cloud-based tool
Built with MSPs in mind, and includes RMM and PSA tools built-in
Dashboard access from any browser makes Atera extremely flexible
Can scale and support multiple databases in a multi-tenant environment
Could use better reporting functionality
Automated remediation would use improvement
9. dbWatch Database Control
Norway-based dbWatch Database Control is a specialized database monitoring tool – it doesn’t form part of a generalized infrastructure monitor. So, this tool is a good choice if you already have all of your server and application monitoring tools in place but lack insight into the performance of your databases.
- Monitor local, remote, and cloud-based databases
- Maintenance automation
- Performance alerts
The tool is implemented as an on-premises database monitoring software. You pay for a license based on the number of databases that you want to monitor. The pricing structure begins with a minimum database coverage of ten.
The tool can monitor a range of databases in real-time and it also gathers historical data for analysis and reporting. Views and reports can be accessed on each individual database, or as an overall view of the performance of all of your databases.
It doesn’t matter if you have RDMSs from several providers on your site because the tool can monitor different types of databases all at once. It can monitor SQL Server, Oracle, Sybase, MariaDB, MySQL, and Postgres databases. It doesn’t matter where those databases are because dbWatch can oversee remote and cloud-based databases as easily as it can monitor on-premises instances. It is also able to oversee SQL Server and Oracle clusters, and it can interface with Azure SQL on the cloud.
The dbWatch package is available in three service plans. These are dbWatch Essentials, dbWatch Professional, and dbWatch Enterprise. The Essentials package gets you all of the database monitoring tools. The Professional plan adds on automation for maintenance tasks and it also includes license management for SQL Server and Oracle databases. The Enterprise package includes database autodiscovery and cluster management.
The dbWatch software installs on hosts running the windows, Mac OS, and Linux operating systems. You can get a 30-day free trial of the dbWatch Essentials plan to put it through its paces before buying.
Supports multiple database types including cloud-based databases like Azure SQL
Good option for businesses that have a large number of SQL servers in operation
Can proactively alert based on set thresholds
Available cross-platform on Windows, Linux, and Mac
Specializes only in SQL server monitoring
Minimum license requirement of 10, not for small businesses
10. Idera SQL Diagnostic Manager
When it comes to diverse database monitoring solutions, Idera SQL Diagnostic Manager is hard to beat. This SQL monitoring tool can monitor databases in both physical and virtual environments. This program has been specifically designed to help the user view key performance metrics. Metrics you’ll encounter on Idera SQL Diagnostic Manager include CPU, Hard Disk Usage, Space, Network Usage, and Memory. This data gives you the basics you need to assess how well a database is performing.
- Server resource tracking
- Transaction analysis
- SQL workload analysis
You can also view what is happening through the lens of transaction analysis. This allows you to view application problems in isolation. For example, SQL Workload Analysis combines granular state monitoring and query plan tuning together with recommendations. This allows you to make targeted changes to address poor performance issues.
What makes Idera SQL Diagnostic Manager a stand out product is its alerts. Alerts notify you when certain data occurs. You can set your alert thresholds so that you are notified when specific events happen. There is also a predictive alert facility that shows a percentage detailing the likelihood that a particular event will happen.
Idera SQL Diagnostic Manager is one of the most accessible products on the market. It mixes a compelling user interface available online and as a mobile app to help you monitor effectively. You can purchase the Pro version of Idera SQL Diagnostic Manager for $999 (£782). You can also download this tool as a 14-day free trial.
Preconfigured views make monitoring key SQL metrics easy
Offers transaction analysis to help improve queries and measure performance on a granular level
Alerts are flexible and can be configured based on condition or threshold
Would like to see a longer trial period
Visualizations could use a refresh
Reporting configurations are limited
11. AimBetter
AimBetter is a cloud service that assesses databases and provides tuning solutions. The package also provides continuous monitoring and will raise an alert if a resource runs short or table records get locked. This isn’t just an automated tool because the AimBetter data center is staffed by database experts who manually examine the performance of databases run by the service’s clients. You can also choose to get those experts managing your databases full time.
- Expert support
- Query assessments
- Database optimization
- Managed service option
The AimBetter package examines the source of access to your database and the types of activity that it serves. This information can alter the design of the database and you will get advice about that. Monitoring services include the tracking of host resources beneath the database and also activity, such as index operations and record locking. The system is able to monitor SQL Server, Oracle, and SAP databases plus IIS and Windows Server.
The performance monitor watches over 400 metrics and they are stored for historical analysis. The exact data retention period depends on the services that you specify when you negotiate your quote. The maximum period available is one year.
The dashboard for the AimBetter service includes a live alert board plus a data analysis tool. This console can be accessed through any standard Web browser and AimBetter also provides a mobile app.
AimBetter is a cloud service and it is hosted, so you don’t need to download the system as a software package. The system does require agents to be installed on each server that hosts your databases. You can assess AimBetter with a free trial.
An automated monitoring tool that tracks database and server resources
Expert consultants that interpret performance data and give advice on tuning
Historical analysis tools that operate on stored metrics
Alerts for performance problems
Not available for self-hosting
12. SQL Power Tools
Back in 2000, SQL Power Tools began to develop a name for itself as a staple tool for all things SQL monitoring. This product remains popular as one of the most lightweight products on account of its deployment. SQL Power Tools logs database metrics including response time, destination IP, source IP application, login id, bytes sent, and packets sent etc. In short, this tool provides you with the basics to view how your database is performing.
- Performance logging
- Behavior analysis
- Deadlock tracking
SQL Power Tools also delivers a high-quality experience in terms of cybersecurity. Advanced Behavioral Analysis and user Entity Behavioral Analytics help the user to identify threats and respond accordingly. If a hacker accesses your system, the breach will be identified promptly and the activity stopped ASAP.
The general monitoring experience offered by SQL Power Tools is extensive. You can look at everything from SQL wait times to stall times, blocking, and deadlocks. You can even view these in 3D graphs which makes it much easier to understand what’s going on.
SQL Power Tools is a tool that still provides a contemporary monitoring experience despite its age. However, you will need to contact the sales team to view a quote for purchasing this product. That being said, you can also download a free trial.
Was specifically built to be as lightweight as possible, allowing it to manage a large number of SQL servers with little resource consumption
Offers built-in security auditing and monitoring that leverages behavioral analytics to stop SQL attacks
Clean user interface takes little time to learn
Doesn’t support other applications beyond SQL
Must contact sales for pricing
13. Red-Gate SQL Monitor
Next,we have Red-Gate SQL Monitor. Red-Gate SQL Monitor is a program that’s SQL monitoring abilities are as striking as its visual design. With this tool, you can monitor all of your SQL databases through one dashboard on the web-based GUI. Your servers will be color-coded and you can identify what their status is in seconds. There is a traffic light system with a green light for Healthy, amber for Warning, and red for Critical.
- Simultaneously tracks multiple databases
- Traffic light status indicators
- Server resource tracking
One of the great things about Red-Gate SQL Monitor is that the web-GUI updates every 15 seconds. This means that you can track live activity without falling behind. This is particularly advantageous for dealing with problems as they emerge in more extensive networks.
There are also a variety of alerts that you can take advantage of. You can use alerts for high CPU, memory, low disk space, SQL errors, and performance issues. In total, 40 customizable alerts come with Red-Gate SQL Monitor out of the box. This provides you with everything you need to stay on top of what is happening on your network.
There are a variety of pricing options available for Red-Gate SQL Monitor based on how many servers you want to monitor. If you want to monitor one to four servers then you can do so for a price of $1,495 (£1,171) per server. If this isn’t enough then you can purchase for five to nine servers for $1,271 (£995). However, you’ll need to contact the company directly if you want to see the price for 10+ servers. There is also a 14-day free trial available.
Scalable- can manage multiple SQL databases without clutter
Best suited for multi SQL server environments
Offers pre-configured alerts and templates specifically for SQL DBAs
Doesn’t support other applications beyond SQL
Trial is only 14 days, could be longer
14. Lepide SQL Server Auditing
Lepide SQL Server Auditing is a product that has been used by many big names over the years. Brands from Cisco and Intel to Coca-Cola have called on LepideAuditor to protect their data over the years. This is no surprise given that this product offers one of the most complete platforms for live and historic SQL monitoring.
- Overview for multiple databases
- Security auditing
- Usage tracking
The user experience on Lepide SQL Server is driven through the dashboard where you can view all your SQL Servers. The dashboard has been designed so that you can see changes to configurations and permissions instantly. It also allows you to view your databases in a hierarchical format. For example, you can view your top 10 active databases and failed logins.
Lepide SQL Server Auditing is used widely for many reasons, but many administrators use it because of its cybersecurity credentials. This program allows you to monitor any changes made to user permissions. If a suspicious change has been made you will be sent an alert. These alerts operate in real-time and can even run custom scripts to allow the user to configure the automated threat response.
As far as SQL Monitoring goes, Lepide SQL Server Auditing is a program that is highly recommended for administrators looking to stay protected against external threats. To view pricing options for Lepide SQL Server Auditing you need to contact the sales team. However, there is also a demo version that you can download.
Offers monitoring services with detailed auditing, good for larger DevOps teams
Supports alerts sent as push notifications and webhook integration
Can track SQL config changes over time automatically
Takes time to learn, unconventional layout
Must contact sales for pricing
15. ManageEngine Free SQL Health Monitor
ManageEngine Free SQL Health Monitor is a tool that provides a premium yet affordable SQL Monitoring experience. With ManageEngine Free SQL Health Monitor you can monitor all versions of MS SQL including MS 2012 and MS SQL 2014. In other words, if you’re using SQL servers then this is a tool you should definitely consider deploying.
- Free to use
- SQL Server monitoring
- Server resource usage tracking
The user interface delivers the high-level production value that one would expect from a ManageEngine product. There is a clear performance monitoring dashboard where you can monitor the key metrics of your MS SQL servers with information such as CPU, memory, and disk space utilization being displayed. This provides you with a centralized location where you can take a magnifying glass to your MS SQL servers.
On the other hand, the SQL server monitoring abilities of this product allow you to view data on the log files used, active transaction data, transactions per second, and log cache hit radio. This is a healthy mix that allows you to look below the surface to solve problems. This is added by being able to set warning thresholds based on metrics like disk space, memory, and CPU.
In terms of setup, ManageEngine Free SQL Health Monitor is straightforward to set up. You can even autodiscover SQL servers throughout your network. This is massive because it means you don’t have to waste time adding servers manually. This means less time configuring and more time monitoring. You can download ManageEngine Free SQL Health Monitor for free.
Completely free SQL monitor, great for small businesses
Tracks server resource utilization as well as database performance
Simple and easy to use
Supports auto-discovery for quick onboardings
Large dev teams may need more features found in other tools
16. Spiceworks SQL Server Monitoring
SpiceWorks is another well-known name in the network monitoring space, and SpiceWorks SQL Server Monitoring is a platform that showcases this company’s prowess in creating infrastructure monitoring products. With Spiceworks SQL Server Monitoring you can check the health of your servers minute by minute on SQL databases from SQL Server 2005 and up.
- Free to use, ad-supported
- Customizable live performance monitor
- Spots inefficient objects
Customizable charts and graphs are an area where SpiceWorks excels. You can create charts that change the perspective you take of your servers. For example, you can select or deselect metrics such as IO Bytes/sec, Disk Queue Length, CPU Queue Length, and Processes Blocked. The result is the ability to analyze your server performance in different ways.
This is also true of the customizable dashboard where you can choose precisely how your monitoring environment is structured. You can create your own widgets and dedicate them to server data as needed. The best part about this is that you don’t need an elaborate display to take the basics in, and you can restrict what you see to only the crucial data.
SpiceWorks SQL Server Monitoring is a product that is great for smaller organizations looking to make their way into SQL monitoring on a budget. The best part about this product is that it is completely free.
Completely free SQL monitoring tool
Dashboard and graphs are both easy to customize and informative
Provides database health metrics per database
Large sidebar degrades the user experience and displays ads/upsells
Not suited for larger organizations, better for budget monitoring
Database Monitoring Tools: Our Top Picks
All of the products listed above are valuable database monitoring tools in their own right. However, if you were limited to two, we would recommend SolarWinds Database Performance Analyzer for SQL Server, ManagEngine Applications Manager, and Paessler PRTG Network Monitor. SolarWinds Database Performance Analyzer for SQL Server should be the top pick for any organization serious about overseeing database performance long term.
The ability to see the root cause of performance issues is something that will help you immeasurably when going through the troubleshooting process. Rather than spending time fumbling around for solutions, you will be able to point to specifics and take the appropriate action.
However, if you would like to combine a network monitoring experience alongside your SQL monitoring activities then Paessler PRTG Network Monitor is the better choice. It has the ability to monitor a variety of SQL databases and delivers a scalable pricing structure that is suitable for organizations of all sizes.
Related posts
Best Tools for Oracle Database Management & Troubleshooting
Best Database Encryption Tools
Row counts per table
Table sizes
Database size
Database file IO
Memory performance
Rollback space (transaction log in memory)
Transaction log file size
CPU utilization
Response times per query
Blocking events
Wait time per execution
All of these important database performance metrics can be monitored by querying system tables. However, that is a boring and time consuming task, which would lead any DBA’s attention to wander, thus leading to poor monitoring. It is better to buy monitoring software to watch these metrics, set thresholds, and alert when one of these indicators gets tripped.
Implement a secure credentials policy
Enforce complex passwords.Ensure password rotation.
Protect authentication databases.
Encrypt the database
Protect data in the database.
Encrypt system files that contain metadata.
Encrypt all data transmissions between the database and users
Encrypt all backup files.
Segment the database
Hold related tables per business function in each database segment.
Only allow each user access to pertinent segments.
Set up views to resolve cross-segment referencing.
Restrict development access to the live database
Create clones of the database with sensitive data removed.
Only allow adjustments to the live database once they have been tested elsewhere.
Analyze all code in sandbox environments before applying it to the live database.
On web applications, don’t allow direct outsider access over the internet.
Monitor and audit the database
Track users.
Monitor code performance.
Optimize database queries.
Implement intrusion detection systems.
Enforce complex passwords.Ensure password rotation.
Protect authentication databases.
Protect data in the database.
Encrypt system files that contain metadata.
Encrypt all data transmissions between the database and users
Encrypt all backup files.
Hold related tables per business function in each database segment.
Only allow each user access to pertinent segments.
Set up views to resolve cross-segment referencing.
Create clones of the database with sensitive data removed.
Only allow adjustments to the live database once they have been tested elsewhere.
Analyze all code in sandbox environments before applying it to the live database.
On web applications, don’t allow direct outsider access over the internet.
Track users.
Monitor code performance.
Optimize database queries.
Implement intrusion detection systems.
Shrink the transaction log with these steps.
- Go to the Orion Service Manager and shut down all Orion services.
- Open the SQL Server Management Studio. Connect to your SQL server.
- Right-click over the Orion Database.
- In the context menu, select All Tasks then Shrink and then click on Files. Set the File Type to Log.
- Under Shrink action, select Reorganize pages before releasing unused space.
- Set Shrink File to 0 MB.
- Click OK.
- Go to the Orion Service Manager and restart all Orion services.
The Shrink action takes a while to complete. Expect to wait a few minutes for each GB in the file. The process might not shrink all the size that is possible to reduce in one go, so repeat the process before restarting Orion services. Check the transaction log file size after each attempt. When the Shrink action makes no difference to the file size, it has done all it can.