Versions Compared

Old Version 8

changes.mady.by.user Nadja Pollard

Saved on

compared with

New Version 9

changes.mady.by.user Nadja Pollard

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • 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 Precise Insight User 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 Precise 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 Precise 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 “atat-a-glance”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 Precise 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.

...

  • Application Performance agent. Precise for SQL Server provides a complete view of application performance management by capturing, measuring and correlating performance metrics from all critical system components.
  • SAP™SAP, PeopleSoft and Siebel Collectors. If ERP support is installed, the Collector also includes the Interpoint for PeopleSoft, SAP or Siebel agents. This agent provides data on the activities and resource consumption of packaged application entities. This data can help you identify ERP users, transactions, reports, and so on, that are heavy users of SQL Server resources. The current version only supports SAP, PeopleSoft, and Siebel Collectors.
  • COM+ Collector. If COM+ support is installed, the COM+ Collector provides data on COM+ applications that originate in SQL Server activity. It can help you correlate your SQL Server instance and COM+ activity.
  • Storage agents. EMC Storage, HP Storage, Hitachi Storage, and Storage for Windows. See Storage systems.

...

  • Other storage systems. Other storage systems supported by Precise for SQL Server include storage systems that work with Microsoft® Microsoft SQL Server™ 2000 and Microsoft® SQL Server™ 2005Server 2005 and later, running on Microsoft Windows® Windows 2000 and Microsoft Windows® 2003 later 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™ 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® Windows operating system, but you cannot see how these disks are actually allocated and used.

...

  • Resolve performance problems by identifying their root cause and improving statement performance.
  • Proactively monitor, analyze, and tune SQL Server instances.
  • Analyze and tune locking problems.
  • Determine whether an I/O problem is caused by a SQL Server application.
  • Tune a database object rather than a specific statement that accesses the database object.
  • Perform I/O tuning of storage devices.
  • Identify the most resource-consuming SQL statement and view a detailed explanation of the execution plan of the SQL statement.
  • Monitor your system's current state as well as previous states.
  • Recommend which index would provide a better execution plan and reduce resource consumption. If you are running SQL Server 2005 or later, you can also test and evaluate the cost of implementing statement tuning recommendations with the What-if option.

...