|
Click here to forward-to-a-friend! Send a colleague the SQLsmarts e-newsletter to keep them up-to-date with current tips and information for managing SQL Server data. |
|
|
|
|
|
|
|
|
|
|
 |
|
Let SQL diagnostic manager monitor, track and analyze all SQL Server performance metrics and issues for you. |
|
SQL diagnostic manager will automatically alert you if there is a performance problem so you don’t have to wait for the phone call. |
|
SQL diagnostic manager will quickly tell you if any servers are having issues. |
|
SQL diagnostic manager will also pinpoint the cause of performance bottlenecks including poorly performing queries. |
|
SQL diagnostic manager will also allow you to drill down to see the actual code being used on your servers. |
Try SQL diagnostic manager today! |
|
|
|
|
| |
|
|
|
Focus on SQL Server Performance Monitoring &
SQL diagnostic manager v5.0
- SQL diagnostic manager v5.0 is now available
- What they are saying about SQL diagnostic manager v5.0
- Reproducing Query Execution Plan Performance Problems
- SQL mobile manager for BlackBerry devices coming soon!
| The quest for the ultimate SQL Server performance monitoring solution is over: |
|
| SQL diagnostic manager 5.0 is here! |
This new generation of SQL diagnostic manager is more powerful than ever before—
helping DBAs save hours of time helping to ensure SQL Servers continually perform as expected. With SQL diagnostic manager, you can monitor and manage the performance of all SQL Servers from a central point of control, quickly find and fix performance bottlenecks, and analyze SQL Server performance over time.
What’s new in SQL diagnostic manager 5.0:
New three-tier architecture providing high performance, scalability and flexibility:
- Allows any or all SQL Servers to be monitored from a central management console or from multiple management consoles
- All database performance monitoring data, from multiple servers, can be collected, analyzed, and stored in a central SQL Server Repository
Powerful, intuitive management console interface:
- Based on the ‘need to know’ design principles used in modern fighter aircraft cockpit displays, the console organizes and maximizes visibility to over 230 critical performance metrics and alerts
- Animated single-server monitor shows the health of SQL Servers at-a-glance
- Customizable console displays warning thresholds to meet personal preferences or Service Level Agreement requirements
Rapid and flexible notification, alerting & reporting:
- Notification messages can be customized with environment-specific knowledge to enable rapid problem resolution
- Send alerts to different groups based on the time of day or type of alert.
- Group servers into logical groups for easier analysis
What they’re saying about SQL diagnostic manager 5.0:
“SQL diagnostic manager has drastically improved the way we manage our SQL Servers across the Department. In our opinion, we felt the tool couldn’t get any better until we saw SQL diagnostic manager 5.0. The new interface is truly impressive and puts a lot of valuable information at our fingertips. We are also impressed with the new alerting functionality which allows us to filter out less critical issues and send specific alerts directly to team members that can troubleshot and solve the problem quickly. Now, we will we be able to diagnose and resolve SQL Server performance issues faster than we did before.”
- Mitchell Bottel, DBA, California Department of Health Care Services
“SQL diagnostic manager is an invaluable tool for our team. Our company relies heavily on SQL Server so we can’t afford to spend hours diagnosing SQL Server issues and cannot tolerate downtime. SQL diagnostic manager keeps constant tabs on the health of our SQL Servers and can tell us just about anything we need to know about their status. Now my team can be proactive and anticipate potential database problems before they arise, rather than just reacting to issues and failed database jobs.”
- Michael Swinarski, DBA, Cox Communications
Reproducing Query Execution Plan Performance Problems
Excerpt from: MSSQLTIPS.COM
Written By: Enrique Garcia
“You get a call from tech support that users are complaining about a report being particularly slow. Tech support says they think the problem occurs when retrieving data from the database. After using SQL Profiler to find out what is happening, you find out that the stored procedure that pulls the data for the report is having very high reads and it is taking several seconds to complete. However, when you execute this procedure on the same database to analyze the query plan and start solving the problem, you can’t reproduce the bad performance the users are complaining about, even when you use the same parameters. How can you reproduce the problem to get the same results as the users?”
GOT BLACKBERRY?
Coming Soon: SQL mobile manager for BlackBerry Devices
Idera will soon announce SQL mobile manager 3.0 which will support Blackberry Wireless Handheld Devices as well as Windows Mobile Devices. This powerful tool for SQL Server management allows you to monitor SQL Server performance and perform SQL Server management tasks, anytime anywhere, from a wireless handheld device such as a PDA. With SQL mobile manager, your can see real-time SQL Server performance metrics, view event logs, see failed jobs, receive alerts for critical events or performance bottlenecks, and take action to fix problems such as start or stop a job, agent, or service or reboot a server.
SQLsmarts is Idera’s monthly newsletter for SQL Server Professionals.
We welcome your questions, comments or suggestions! Tell us more about how you’re using any of Idera’s products and we’ll send you a free Idera “SQL Server Superhero” t-shirt! Email us: SQLsmartseditor@idera.com.
Thank you! |
|
