Welcome to SQLsmarts, Idera’s newsletter for SQL Server Professionals!

We welcome your questions, comments or suggestions.
Email us at SQLsmartseditor@Idera.com.

In this issue:

News
Play Idera 5IQ Today and Win!
SQLServerCentral.com Review of SQL diagnostic manager Review

Product News
Announcing the new SQL diagnostic manager Web Console – now get SQL Server performance monitoring anytime, anywhere!

Tips & Tricks – SQL diagnostic manager
Compare SQL Server performance data on two different days
Display multiple views in the SQL diagnostic manager Web Console

Play Idera 5IQ and win! Test your knowledge of SQL Server 2005 and you could win $100 per day or a $2005 grand prize!

Being prepared for SQL Server 2005 can really pay when you play Idera 5IQ! Simply answer a trivia question based on SQL Server 2005. If your answer is correct, your name will be entered into the daily drawing. One lucky DBA will win $100 each day! Then, at the end, one really lucky SQL Server 2005 guru will win $2005!

So play everyday – the more you play the more you could win!
Game ends on NOVEMBER 18, 2005!

Sign up now to play at www.idera5iq.com

Sponsored by:

SQLServerCentral.com Review of SQL diagnostic manager Review

by Kathi Kellenberger

SQL diagnostic manager (SQLdm) is a fantastic tool from Idera for monitoring SQL Server performance and diagnosing server and database problems. Think of SQLdm as an extra DBA who doesn’t have to go to meetings and never takes a day off while it watches your servers and warns you about real and potential problems. Unlike many vendors which sell monitoring software for SQL Server, Idera only sells products for SQL Server.

Read more...

Announcing the new SQL diagnostic manager Web Console: Now get SQL Server performance monitoring information anytime, anywhere!

Thousands of companies worldwide have come to depend on Idera’s SQL diagnostic manager to help diagnose & solve SQL Server performance issues. Now the SQL diagnostic manager Web Console gives you access to real-time SQL Server performance monitoring and deep diagnostics – anytime, anywhere – from a simple Web browser. Now you’ll be able to respond even more quickly and accurately to issues with your SQL Server databases, regardless of your location.

The SQL diagnostic manager Web Console will help you take control of your SQL Server environment with these key benefits:

• Allows multiple DBAs to monitor the overall health, performance and availability of their SQL Servers anytime, anywhere from a Web browser. Requires no terminal session.
• Facilitates monitoring of hundreds of SQL Server instances in real-time with easy-to-define custom server groups
• Offers drill-down views into individual SQL Server databases to provide deep diagnostic data
• Deploys quickly and is easy to learn with a familiar Microsoft Outlook 2003 style user interface
• Helps to improve productivity of DBA staff – read only Web Console can be safely delegated to less experienced DBAs or help desk staff to help reduce SQL Server response times and unnecessary calls to the DBA staff

Learn more about the SQL diagnostic manager Web Console
Try it FREE for 30 days!

Use SQL diagnostic manager to compare SQL Server performance data on two different days

Ever wonder if all of those upgrades, tweaks, or new hardware you’ve installed have really improved the performance of a specific SQL Server? Now you can get proof. SQL diagnostic manager allows you to easily compare SQL Server performance data from two different days – for example, two months ago and today. You can even view this data – anytime, anywhere -- through the new SQL diagnostic manager Web Console.
Find out how...
 

How to display multiple views in the SQL diagnostic manager Web Console

This handy feature allows users to quickly and easily compare SQL Server data from two different points in time or on two separate SQL Server instances. With the SQL diagnostic manager Web Console, you can see multiple views simultaneously in order to analyze data collected on multiple panes.The Web Console uses views that persist within an individual session. This means that when you open multiple Internet Explorer windows, you will see the same information refreshed on each view.
Find out how...
 

We want to hear from you!

Have an interesting story about how Idera product(s) have helped you?
Want to share a product tip, trick or hint?
Have product suggestions or questions?

Your feedback helps us ensure that our solutions continue to best serve your SQL Server management and administration needs. You may even find your input published here in future newsletters.

Please send your comments and suggestions to SQLsmartseditor@idera.com

• Visit Idera at an upcoming Microsoft Ready Launch Tour 2005,
  Register Now!
  - San Francisco, Nov 7
  - Toronto, Nov 8
  - Chicago, Nov 10
  - Philadelphia, Nov 17
  - New York, Nov 22
  - Seattle, Nov 29
  - Dallas, Nov 30
  - Denver, Dec 6
  - Houston, Dec 6
  - Orlando, Dec 8
  - Boston, Dec 15
  - Wash D.C., Jan 11
   

• SQL Server Performance Monitoring & Optimization Tips –
   
  Find out about how to monitor your SQL Server, configuration suggestions, get tips on how to troubleshoot throughput issues, and how to spot and correct issues with your server. Sponsored by Idera and the SQL Server Worldwide Users Group
   
  VIEW NOW!