Precise for Database

Performance intelligence from click to storage

precise screenshot


Mangelen på komplett overvåking skader ytelsen i komplekse systemer med flere nivåer. Virkeligheten for de fleste bedrifter er at landskapet er komplekst og raskt voksende med ulike applikasjoner over flere plattformer som brukes av ulike brukergrupper. Hver prosjektgruppe har sine overvåkingsverktøy, men på tross av alle måleverktøyene kan det være vanskelig å diagnostisere og korrigere ytelsesproblemer over ulike, men fremdeles avhengige av hverandre, teknologier. Dette resulterer ikke i bare dårlig systemytelse, men innebærer at problemløsing tar lengre tid og supportkostnadene blir høyere siden de ulike teamene ikke har et enhetlig bilde av sine systemer.

Med Precise får du:

- "End-to-end" transaksjonssynlighet for å raskt isolere problemer
- Anbefalte korrigeringstiltak for å raskere finne en løsning
- Historisk analyse- og trendmekanisme for å oppdage potensielle problemer innen de oppstår
- Databaselagring med kontekstuelle detaljer for å korrelere transaksjoner med bedriftsrelaterte spørsmål
- Skalerbar ytelse for forretningskritiske prosesser
- Multi-plattform som støtter mange ulike systemklienter.

Preise har støtte for følgende databaser: Oracle, Sybase, SQL Server og DB2



  • End-to-end transaction visibility quickly isolates issues anywhere in the stack
  • Recommended corrective actions speed time to resolution
  • Historical analysis and trending discovers potential issues before they occur
  • Database stores contextual details to correlate transactions with business issues
  • Scalable performance for mission-critical business processes
  • Multi-platform support spans a diverse range of system clients

End-to-End Transaction Visibility
Variations in usage patterns, user demands, platforms, architectures, components, and customizations all play their part in undermining performance. The Precise Platform collects transaction performance information across all key technology tiers including applications,virtualization, server, databases, and storage. This end-to-end view allows IT to have visibility across their entire environment through a single application.

Recommended Corrective Actions
Reduce time to repair issues with the Precise Platform customer problem knowledge base. The knowledge base consists of real customer case data that is constantly updated. By learning from past problems for other customers, the Precise Platform can quickly identify issues, suggest a list of “prime suspects,” recommend corrective actions and even provides answers to “what-if” scenarios to assess the impact before you make a change.

Historical Analysis and Trending
The only thing better than fixing performance problems quickly, is preventing them altogether. The Precise Platform can store and process months of history (quarter-end / year-end closing) in its performance warehouse, tracking and comparing behavior and seasonal trends over long periods of time. This means problems can be identified and fixed before they actually impact performance.

Performance Management Database
The Precise Platform works by tracking the path of transactions through all tiers of virtual and physical infrastructure and stores both the business context and performance details in a centralized repository, the Precise Management Database (PMDB). The platform then automatically correlates transactions with users, databases, devices, files, and objects being accessed to identify performance problems anywhere within the environment.

Scalable Performance
From the world’s largest financial institutions to complex health care organizations, customers trust the Precise Platform to perform and scale to millions of transactions on their most critical business systems.

Multi-Platform Support
The Precise Platform measures the end-user experience starting from the browser and tracks it through all tiers of virtual and physical infrastructure – application to database to storage. The platform empowers IT to intelligently monitor and optimize performance for custom software and for leading enterprise application, such as SAP, Oracle, PeopleSoft, Siebel, and more.

Comprehensive Dashboard
The dashboard is an easy-to-use tool for visualizing the overall health and status of all monitored systems. It provides support for detailed views of individual application servers, organizations, locales and other entities as well as top-level summary views of multiple systems.


Automated Application Management
The Precise Platform automates the manual process of collecting and correlating performance information for business transactions as they pass through complex IT landscapes including third-party applications, databases, and storage. This eliminates the need for invasive, error-prone traces.

Enterprise Resource Planning Applications
Performance issues affecting ERP applications can translate to lost revenue and lost business if not resolved quickly. Many organizations have tools to track performance for ERP applications, yet still find out about slow performance through end-user complaints. The Precise Platform monitors and measures end-user experience from click to storage across SAP, PeopleSoft, and Oracle Applications better than native tools through your technology stack.

Custom Applications
The Precise Platform helps application support teams determine whether or not the root cause of poor end-user experience can be found in the application tier or somewhere else in the technology stack. From there, the Precise Platform can give recommendations on how to resolve issues in the fastest manner possible.

Database Performance Fuels Company Performance
Databases are at the heart of an IT organization and as their performance goes, so go the performance of applications and the business as a whole. Downtime and slow system performance can result in significant lost revenue, lower productivity, and increased support costs if not resolved quickly. When performance problems occur, database administrators are frequently the first called to troubleshoot – often without any proof of where the issue lies. Any number of monitoring tools can extract metrics and provide data alerts, but without context for what is driving these metrics, performance management is hit and miss. DBAs need a solution that provides insight into the real causes of performance bottlenecks to resolve problems no matter where they exist in the stack.

Multi-Platform Database Monitoring
Most organizations today have multiple database platforms supporting their myriad of applications, users, and locations. Typically this consists of a combination of relational databases such as Oracle, SQL Server, DB2, and/or Sybase. Each of these platforms comes packaged with their own set of native tools. However, the operational costs to manage each of those platforms as silos, not to mention the inconsistent performance data and varying service levels to support them, can be a management headache.


Precise Platformer


Precise works by tracking the path of transactions through all tiers of virtual and physical infrastructure and stores both the business context and performance details in a centralized repository, the Precise Management Database (PMDB). The software then correlates transactions with users, databases, devices, files, and objects being accessed to identify performance problems anywhere within the environment.

Once identified, Precise isolates the root cause of the problem and enables you to drill into the transaction details including which server, method call, SQL query, or storage device is causing the problem. These performance issues are then mapped back to the business unit or application experiencing the problem. Precise can also compare the problem against a knowledge base of best practices that has been fine-tuned over years and can automatically recommend fixes to help optimize your application stack.


Independent of applications, Precise has specialized solutions that monitor performance across leading database platforms from Oracle, Microsoft SQL Server, IBM DB2, and SAP ASE (Sybase). The common interface enables a consistent user experience regardless of the underlying database being accessed. Precise for Storage maps important transactions back to the storage devices being used to quickly identify performance problems.
Datasheet - Databases & Storage

Precise for Oracle Databases
Precise for Oracle allows DBAs to drill down in context of the user transaction to pinpoint the problem’s root cause. It can uncover poorly designed SQL statements, programs, database objects, or even bottlenecks due to a resource shortage in the underlying operating system, virtualization infrastructure, or storage device.
Datasheet - Oracle

Precise for Microsoft SQL Server
Precise for SQL shows instance-level resources causing performance problems, such as excessive CPU, I/O, or locks and helps uncover internal SQL Server problems resulting in wait states. Precise analyzes execution plans for heavy statements, pinpointing inefficiencies and recommending next steps.
Datasheet - SQL Server

Precise for SAP AES (Sybase)
Precise for Sybase analyzes SQL statements and database objects to determine whether performance problems are caused by poorly written SQL statements or by inefficient object design. It shows the resources that are causing waits and whether an SQL statement is bound by CPU, I/O, or another SQL statement.
Datasheet - Databases & Storage

Precise for DB2
Precise for DB2 UDB collects detailed statistics in the production environment allowing the DBA to tune the worst performing SQL statements and verify the impact of these proposed changes before they are implemented.
Datasheet - Databases & Storage

Precise for Storage
Precise has partnered with EMC to develop a comprehensive performance management solution. Precise for Storage maps important transactions back to the storage devices being used to quickly identify problems. It helps customers optimize tiered storage for both performance and cost.
Datasheet - Databases & Storage



Precise Application Performance Platform is offered per instance. A license is needed for each (per) Server instance that is being monitored. First year of maintenance is included in price.

Alfasoft offer a price guarantee for the IDERA products. If you find an IDERA product at a lower price before your purchase somewhere else we will match it.