One of the most popular questions I often receive during Comprehensive Database Performance Health Check is which are the third-party tools I use in my daily routine and I recommend them. Here is the updated list for December 2019 of all the tools which I recommend.
Tools I Use December 2019
Here are the different tools and their download links along with it.
- Database Performance Analyzer (Download 1, Download 2)
- SQLGrease (Download)
- Foglight (Download)
- RedGate (Download)
- Melissa (Download)
Database Performance Analyzer for Performance
I have been using the Database Performance Analyzer (DPA) for many years. I am always delighted when I find this tool installed at my client’s place as that makes my life much easier while helping them optimize their SQL Server Performance. This tool reveals performance bottlenecks deep inside your SQL Server, Oracle, DB2 and SAP ASE instances. No other database monitoring tool focuses on response time and Multi-Dimensional Performance Analysis like DPA does.
SQLGrease for Subscription Model
Not everyone likes to pay upfront a large amount to own a performance optimization tool. SQLGrease is preferred by many clients who prefer subscription-based tools just for SQL Server. Using the newest monitoring features in SQL Server, SQLGrease collects detailed information with extremely low overhead. SQLGrease installs in minutes. Upgrades do not require reinstallations and do not require end-user intervention. As a result, SQLGrease frequently introduces new features at no additional cost.
Call to Action Download SQLGrease
Foglight for Cross-Platform
In my career, I have found Foglight installed wherever there is a Cross-Platform Ecosystem. With the foglight, you can proactively manage and monitor database environments, diagnose and tune real-time and historical performance, predict and troubleshoot issues, increase the health of your database environment. I often use it to optimize the server configuration, performance, and utilization of your cloud, hypervisors, VMs and storage, and gain end-to-everything visibility across your hybrid infrastructure.
Call to Action Download Foglight
RedGate for Monitoring
In the industry, there’s a need to ensure that the operations teams have full visibility of your estate, not just your production servers. If your engineering teams have access to secure development and testing servers, deployment issues are caught before they reach production. I strongly encourage you to read this whitepaper which discusses:
- Maintaining availability and security at all stages of the development process.
- Keeping visibility and communication flowing between DBA and development teams.
- Removing bottlenecks.
- Identifying and responding to deployment-related performance issues.
- Keeping customers happy and their data secure.
Call to Action Download RedGate Whitepaper
Melissa for SQL Server Data Quality
The most common data quality issue I see in the industry is about inaccurate data, outdated contacts, incomplete records, and duplicates. Without clean and accurate data, it’s hard to find new customers, better understand existing customers’ needs, and increase the lifetime value of every customer – today and tomorrow. Melissa’s Data Quality Components for SSIS is a unique set of global data quality tools for Microsoft’s integration and ETL (extract-transform-load) solution.
Call to Action Download Melissa
I strongly encourage you to check out the tool which I use for a variety of tasks. Do let me know if you use any of the above tools and share your experience with all of us. The list is updated as of December 2019.
Reference: Pinal Dave (https://blog.sqlauthority.com)