In many organizations, accidental DBAs are the individuals who are often responsible for SQL Server Performance. In the real world when we face performance problems, we often do not have the luxury to open PowerPoint and study theory. What helps us during times of crisis are handy scripts or a tool that helps us fix our performance problems. Let us learn today about SQL Diagnostic Manager.
Now this problem goes to the next level when we have to do the same on the cloud. The most cloud platform has tools to monitor their platform but they do not have a tool that can monitor the application which is installed on their platform. Here is where we can take the help of the SQL Diagnostic Manager.
Many of my clients are using SQL Diagnostic Manager for SQL Server for the primary following reasons to monitor data.
- Real-time monitoring data for health and performance
- Monitoring TempDB contention and space
- Monitoring OS-level file size monitoring on Linux and Windows
- Resource Monitoring – CPU, Memory
- Analysing and Resolving Blocks and Deadlocks
- Performance issues resolution under production workload
- Life Cycle Management of queries (Monitor, Alert, Kill Deadlocks)
- Finding long-running queries based on execution time
SQL Server health checks and optimization is one of the most critical tasks for database administrators (DBAs). While we want to spend more time tuning our server, often we (DBAs) are busy with other tasks like high availability, server patching, and other important maintenance tasks. It would be really nice if instead of investigating the server for performance bottlenecks, our server itself reports inefficiencies.
Here are some key reasons I prefer to use SQL Diagnostic Manager on Cloud. SQL DM supports Azure SQL Database and Amazon RDS for SQL Server.
- Monitoring across multiple cloud platforms
- Easy installation on Cloud VM – Azure or EC2
- Managing mapped cloud network drives
- Monitoring managed SQL Server Cloud database
- Hybrid environments in a single interface
I really like to monitor my multiplatform cloud environment along with my on-premises installation of applications in a single environment so I can easily compare their performance and monitor them in a single view.
If you are interested, I suggest you try out the tool SQL Diagnostic Manager.
Reference: Pinal Dave (http://blog.SQLAuthority.com)
1 Comment. Leave new
Would love to hear what this tool was used by to solve real world problem. Not saying it doesn’t have use but rather I’m just struggling to find a practical use for it in my case.
We have this tool and frankly its been more trouble than it’s worth. It has been a continual support issue where it’s agents stop running, errors (lots of bugs!) when trying to run it’s reports, and having to patch it as well as it’s own process showing up as one of the largest impacts on resources. Meanwhile I have yet to solve anything with it I couldn’t easier find just using SSMS activity monitor.