Idera, a provider of management and administration solutions for Microsoft SQL Server, announced the availability of version 4.0 of SQL diagnostic manager, the real-time performance monitoring and diagnostics solution for SQL Server. This new version provides the SQL diagnostic manager Metrics Repository, a central repository engine that captures and stores SQL Server performance analysis data from multiple instances of SQL Server across the enterprise.

As SQL Server continues to gain momentum in the enterprise, SQL Server DBAs are faced with rapid expansion of their SQL Server Infrastructures from tens to hundreds and sometimes thousands of SQL Server instances. They require powerful, scalable solutions to help them more effectively manage and administer these environments. SQL diagnostic manager offers performance and availability monitoring, problem diagnosis and remediation facilities. Now SQL diagnostic manager v4.0 offers reporting and analytics capabilities that enable SQL Server DBAs to analyze and manage their entire SQL Server infrastructure strategically - including trend analysis, capacity planning, data comparison, data correlation and forecasting.

New features in SQL diagnostic manager v4.0 include: Metrics Repository - Captures and stores SQL Server performance and availability metrics in a central repository from SQL Servers across the enterprise. Using data stored in the Repository, DBAs can easily create custom reports to perform a variety of functions, including trend analysis, capacity planning, data comparison, data correlation and forecasting.

Best Practice Reporting - pre-defined reports, sample reports and a guide to writing custom reports are provided 'out of the box' with the metrics repository. In addition an on-line community is available for all SQL diagnostic manager users to share best practice reports.Enhanced Web Console - The SQL diagnostic manager Web Console now enables real-time, anywhere, anytime monitoring of SQL Server 2005 instances from a Web browser.

SNMP Alerting - SQL diagnostic manager now dispatches alerts directly to enterprise management frameworks like Tivoli, HP OpenView and CA.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access