Ignite™ for SQL Server Performance

• Actionable results based on proven Wait-Time Analysis
• Multi-vendor or SQL Server-only Environments
• Precise problem origination
• Optimized impact on end users
• Agentless solution
• Immediate results (download and monitor in 30 minutes)

The leader in Wait-Time based performance management, Confio Ignite™ for SQL Server is for DBA's, managers and developers focused on improving the service delivery of their SQL Server databases and the applications they support. Ignite for SQL Server incorporates Performance Intelligence, a method of analyzing millions of granular data points captured in the Ignite Performance Data Warehouse to identify the most important performance issues and their root causes. By mining multidimensional data, Ignite identifies trends and correlates events to expose the specific conditions impacting IT end users.

New in Ignite™ PI for SQL Server is the availability of the Ignite Performance Data Warehouse on SQL Server, allowing monitoring of dedicated SQL Server environments without use of an Oracle repository. With Ignite PI, all that is required is a server to run PI and a SQL Server database to capture the monitored data.

Actionable results based on proven Wait-Time Analysis

Wait-Time analysis, a best-practice method widely used for optimizing Oracle database performance, is now available for SQL Server performance. Since analysis is based on Wait-time methodology, problems can be isolated down to the specific SQL statements causing delays, providing the deepest and most actionable level of SQL Server performance detail. This level of data offers DBAs unparalleled insight into the true sources of database issues that affect IT system performance and customer service levels within heterogeneous SQL Server and Oracle database environments.

Multivendor Databases or SQL Server-only Environments

The Igniter Suite installs self-contained on SQL Server, or can be used in a multi-vendor environment to monitor SQL Server, Oracle, Sybase and DB2 from a single interface and data warehouse. Ignite for SQL Server monitors any application dependent on the SQL Server database. With a common Performance Data Warehouse for all captured performance statistics, it provides a consistent method for teams to optimize performance across all of their database types. New in PI is the ability to be configured on SQL Server-only, without any external clients or non-Microsoft components.

Click for a larger view.

Unlike tools that take a snapshot of a single session at one point in time, Ignite PI for SQL Server performance shows all sessions all of the time, monitoring databases from a common repository on 24/7 basis. Problems can then be isolated within the database and down to specific SQL statements.

Precise problem origination

Ignite for SQL Server with Performance Intelligence analyzes performance problems to find the root cause and the true owner of the issue.

Performance issues can be traced to a departmental level so the appropriate owners can be engaged, such as the application owners, developers, DBAs, system and network administrators, consultants or outside vendors.

Optimized impact on end users

Unlike traditional system management tools that focus only on internal IT impact, Ignite for SQL Server performance includes proactive monitoring designed to optimize the impact on the customer experience, the most relevant goal of performance analysis. Custom alerts and notifications empower DBA's to quickly address mission-critical problems and minimize or eliminate customer impact.

Confio's Wait-Time approach to analysis measures the time spent waiting on each Oracle and SQL resource, illuminating causes of both database and SQL statement delays. By isolating bottlenecks between database instances as well as inside the statement layer, improvements can be quickly identified and addressed. Impacts can be tracked over time to gauge effectiveness of modifications.

Agentless solution

Ignite for SQL Server performance requires no installed software on the production server so performance tool contributes no load or process burden on the server. All Ignite for SQL Server PI software is installed on a non-critical server, which can be the same or a separate system from the SQL Server database used as the Performance Data Warehouse. For multivendor monitoring of both SQL Server and Oracle, an Oracle database can be used for the warehouse.

No client software is required for Ignite PI – all functions are accessible from a web browser.

Immediate results (download and monitor in 30 minutes)

Waiting for installation, complex integration and results only compounds the frustration of existing delays and performance bottlenecks. Ignite for SQL Server performance can be downloaded, installed and providing data within 30 minutes. Click here to download a free trial now.

Download/View the Confio Ignite for SQL Server performance datasheet