Page History
This section includes the following topics:
- About Precise for SQL Server
- Components of Precise for SQL Server
- How Precise for SQL Server works
- What you can do with Precise for SQL Server
- Where to get more information
| Anchor | ||||
|---|---|---|---|---|
|
Addressing the needs of DBAs, system administrators, managers, quality assurance specialists and planners, Precise for SQL Server provides a complete view of application performance by capturing, measuring, and correlating performance metrics from all critical system components.
...
- Insight. Insight monitors the response times of systems and breaks these times down into the various Tiers and components. Insight also provides tier-specific metrics to help understand the activities in each tier. For more information, see the Insight User's Guide or Online Help.
- Insight SmartLink. Insight SmartLink pattern recognition engine correlates end-to-end activities and provides information on the application’s performance, from the user’s perspective. For more information, see the Insight User Guide or Online Help.
- Alerts. Alerts provides a notification system that will alert you to application response time problems and enables you to launch Precise for SQL Server in context to view more detailed data. For more information, see the Alerts User Guide or Online Help.
- Report Manager. Report Manager gathers and organizes historical information that enables the IT team to focus on infrastructure hot spots. Report Manager is a reporting tool that resides on a Web server. You can use Report Manager to compare period-to-period performance against a baseline and identify response time problems “at-a-glance”, before they affect your bottom-line. It queries the PMDB and displays the results in reports that are generated on a scheduled basis or on demand. For more information, see the Report Manager User Guide or Online Help.
- Precise Custom Portal. The Precise Custom Portal is a lightweight, configurable portal application that provides access to various types of data from different applications. The Precise Custom Portal features a Web-based view. It is highly customizable and extensible, allowing you to build a dashboard for each user or each function within your organization. For example, you can build a dashboard for all the information that a system administrator or director of IT operations would need to constantly follow up on. This component is automatically installed as part of the Precise framework installation. For more information, see the Precise Custom Portal User Guide.
- Precise for SAP. Precise for SAP offers a wide range of data presentations that provides you with the information necessary to manage SAP client/server systems. Precise for SAP analyzes SAP system performance and applications and helps you to effectively direct resources and enhance system use. For more information, see the Precise for SAP User Guide or Online Help.
- Precise for Microsoft .NET. Precise for Microsoft® .NET, is a comprehensive performance management product for .NET applications that addresses the needs of system operators, managers, quality assurance specialists, and planners. It provides the specialized data collection and analysis capabilities demanded by the critical role of the .NET in application performance and scalability. For more information, see the Precise for Microsoft .NET User Guide or Online Help.
- PMDB. The PMDB is the repository of the Precise for SQL Server suite which stores application performance data for long-term analysis and trending reports. The data is collected by the Precise product suite. For more information, see the Precise Administration Guide or AdminPoint Online Help.
| Anchor | ||||
|---|---|---|---|---|
|
Precise for SQL Server employs a web-based architecture to provide high performance database monitoring and tuning. Precise for SQL Server consists of the following components:
...
- Other storage systems. Other storage systems supported by Precise for SQL Server include storage systems that work with Microsoft® SQL Server™ 2000 and Microsoft® SQL Server™ 2005, running on Microsoft Windows® 2000 and Microsoft Windows® 2003 servers. For these storage systems, I/O wait mapping does not extend into the storage units; it ends at the host data level.
For example, if you have a Network Appliance™ storage system installed, you can see the I/O wait on LUNs (Logical Unit Number), which are the physical disks in a Microsoft Windows® operating system, but you cannot see how these disks are actually allocated and used.
| Anchor | ||||
|---|---|---|---|---|
|
Precise for SQL Server stores a complete history of your SQL Server instance activity in the PMDB. This provides you with a performance tracking tool that gives you the ability to assess SQL Server instance performance trends and analyze changes in SQL Server instance activities over long periods of time. This data is vital for identifying patterns in resource consumption and predicting future resource consumption in your SQL Server instance.
...