SQL diagnostic manager
Identify and resolve SQL Server problems before they happen
- Monitor and manage SQL Servers enterprise-wide
- Find and fix performance bottlenecks
- Analyze performance over time
- Diagnose and resolve issues from the desktop or mobile device
- No agents or database objects required on monitored servers
Key benefits:
Increases SQL Server availability
SQL diagnostic manager continuously monitors the entire SQL Server environment and provides immediate, customized notifications when performance or availability issues are discovered. Once notified, DBAs and other administrators can quickly investigate, diagnose and correct performance and availability problems.
Comprehensive view of current performance
SQL diagnostic manager summarizes current server status across the enterprise and makes this information available on the desktop or mobile device. The server dashboard collects and displays extensive real-time activity, status and performance information for sessions, queries, system resources, databases, services, and logs.
Remote mobile SQL Server access
SQL diagnostic manager mobile provides anytime, anywhere access to monitor, diagnose or resolve issues. Real-time and historical performance data, session details, job data and the ability to take corrective action to resolve issues means you don’t have to be tied to your desk.
Improves the productivity of both skilled and novice DBAs
SQL diagnostic manager’s IntelliFeed™ technology uses a social networking paradigm to build a ‘community’ of DBAs and SQL Servers. IntelliFeed™ allows users to follow, monitor and collaborate with particular SQL Servers, alerts, or co-workers ensuring effective communication and providing the ability to easily share and capture best practices.
Offers easy installation and use
SQL diagnostic manager can be installed quickly with no agents or other database objects required on the monitored servers. A typical installation and configuration will take less than 30 minutes.
From€ 1590,-
SQL diagnostic manager Full version to monitor one instance
Named
users
SQL diagnostic manager 1 year maintenance
Maintenance includes access to email support and includes product updates for the defined period of the agreement.
Named
€319.00
users
Identify and resolve SQL Server problems before they happen
- Monitor and manage SQL Servers enterprise-wide
- Find and fix performance bottlenecks
- Analyze performance over time
- Diagnose and resolve issues from the desktop or mobile device
- No agents or database objects required on monitored servers
Key benefits:
Increases SQL Server availability
SQL diagnostic manager continuously monitors the entire SQL Server environment and provides immediate, customized notifications when performance or availability issues are discovered. Once notified, DBAs and other administrators can quickly investigate, diagnose and correct performance and availability problems.
Comprehensive view of current performance
SQL diagnostic manager summarizes current server status across the enterprise and makes this information available on the desktop or mobile device. The server dashboard collects and displays extensive real-time activity, status and performance information for sessions, queries, system resources, databases, services, and logs.
Remote mobile SQL Server access
SQL diagnostic manager mobile provides anytime, anywhere access to monitor, diagnose or resolve issues. Real-time and historical performance data, session details, job data and the ability to take corrective action to resolve issues means you don’t have to be tied to your desk.
Improves the productivity of both skilled and novice DBAs
SQL diagnostic manager’s IntelliFeed™ technology uses a social networking paradigm to build a ‘community’ of DBAs and SQL Servers. IntelliFeed™ allows users to follow, monitor and collaborate with particular SQL Servers, alerts, or co-workers ensuring effective communication and providing the ability to easily share and capture best practices.
Offers easy installation and use
SQL diagnostic manager can be installed quickly with no agents or other database objects required on the monitored servers. A typical installation and configuration will take less than 30 minutes.
SQL diagnostic manager is a powerful performance monitoring and diagnostics solution that proactively alerts administrators to health, performance or availability problems within their SQL Server environment, all from a central console.
Powerful Performance Monitoring and Diagnostics
Continuous monitoring and analysis: Provides continuous monitoring and real-time analysis of SQL Server and OS health and performance metrics across all SQL Servers enterprise-wide, including clustered configurations.
Adaptive and automated alerting: Automatically identifies alert threshold recommendations based on historical performance data and automatically take corrective action.
History Browser: Quickly and easily diagnose historical SQL Server performance problems by selecting a historical point-in-time to view historical SQL Server and OS performance metrics.
Custom monitoring: Ability to add any SQL, Windows or DMV counter for total flexibility in monitoring and alerting.
Pinpoints session locking, blocking and deadlocks: Identify locks, deadlocks and blocked sessions and see the complete blocking chain for easy identification and resolution.
Query and wait stat monitoring: Identifies performance bottlenecks such as the worst performing queries along with what resource is causing the longest wait time, long-running queries, and most frequently run queries.
Monitor tempdb, replication and mirrored environments: Monitor and alert on performance issues affecting tempdb, mirrored database or replication environments.
Fragmentation statistics: Displays fragmentation statistics to help you identify indexes that may need attention.
Predictive alerting: Forecasts what alerts are likely to occur based on an analysis of past performance and current activity.
Enterprise Management Features
Enterprise-class scalability: Large numbers of servers can be monitored from a single console, providing an unprecedented level of visibility and control of the SQL Server environment.Application security: Flexible customization of server access and security permissions allow DBAs to have full access to one or more servers while other users such as Help Desk Operators are provided read-only access.
PowerShell Snap-in: Quickly and easily script many of the SQL diagnostic manager management tasks using the PowerShell Snap-in.
Central Data Repository: Stores all historical performance data in a central repository, enabling analysis of long-term trends, capacity planning and other strategic analysis.
Powerful reporting: Includes predefined reports highlighting key performance trends, along with an easy to use reporting interface for users to conduct customized historical performance trending, analysis, and forecast reporting.
Mobile and Collaborative Features
Mobile management: View real-time and historical SQL Server performance data, view or kill sessions, start/stop jobs and run queries to resolve or diagnose issues.IntelliFeed™ Technology: Communicate and collaborate using social-networking paradigms to manage your SQL Server environment.
Management Console, Services and Data Repository
- Windows 2000 SP4, Windows XP SP2+, Windows Server 2003 SP2, Windows Server 2008 SP1+, Windows Vista SP1+, Windows 7, Windows 2008 R2
- .Net 2.0 SP2+ and MDAC 2.8
- Monitor capable of displaying 16bit color or greater and a resolution of 1024x768
- Repository: SQL Server 2005 SP1+, SQL Server 2008, SQL Server 2008 R2
Supported monitored SQL Servers
- SQL Server 2000 SP4, SQL Server 2005 SP1+, SQL Server 2008 SP1, SQL Server 2008 R2
SQL diagnostic manager does not install any components, DLLs, scripts, stored procedures or tables on the SQL Server instances being monitored.
Mobile Requirements
- Service and Web Server OS: Windows Server 2003 SP2, Windows XP SP2+, Windows Server 2008 RTM +, Windows Vista SP1+, Windows 7, Windows Server 2008 R2
- .Net Framework: .Net 4.0
- Repository: SQL Server 2005 SP1+, SQL Server 2008, SQL Server 2008 R2
- Web Server: IIS 7.0+
Mobile and Desktop Devices
- Mobile device: Android v2.1+, iOS v3.2+, RIM v6.0+, Windows Phone 7
- Desktop Browsers: IE 9.x+, Chrome, Firefox
- Fast Shipping!
- Real helpdesk!
- Advise by phone!
- High service!
- We care!
Questions? You can phone us directly via +31 23 5422227 or send an email to operations@barnsten.com. We will help you instantly.
