Precise's historic repository is available for trend reporting, dashboards, and analysis. On Precise's Application screen, in the top right corner,...
Dashboards
read more
billellis
A Simple Test (for geographically distributed systems)
Here is a simple test that might save you a lot of heartache. If Oracle is a long distance from the application server, open SQLplus, set...
Bad Index – use Clustering Factor to determine when a range scan is expensive
Oracle's Optimizer attempts to pick the most efficient plan for resolving a SQL statement. Most of the time, it succeeds and execution time is...
The best problem is no problem.
Many DBAs begin Oracle tuning by focusing on the slow SQL statements. Time to tune is often made only when there is an issue. We believe...
Oracle Performance Tuning Practice
Transaction performance is business performance. SQL statement execution is the foundation of transaction performance. Business performance has an...
Triangle of Oracle Optimization Success
Any change carries risk and reward. Every change has a price to implement. Adding a hint to a SQL statement is less expensive than a...
Oracle Optimization, Proactive Oracle Tuning
Many DBAs begin Oracle tuning by focusing on the slow SQL statements. Time to tune is often made only when there is an issue. We believe that...
Precise Ranks Tables and Indices By Activity | right indexes & right defragmentation schedule
Precise ranks the busiest objects (tables and indices) for Oracle, SQL Server, and DB2. The right indexes and the right de-fragmentation schedule...
I/O Efficiency – Storage Performance Optimization
In a typical business application, data builds over time as sales are recorded. Data is stored in blocks for tables and leaf pages for indices....
Precise Upgrade – Release Cadence 2X per year | It pays to stay current
Precise is on a release cadence of twice per year. Precise version 9.7.0's theme is infrastructure modernization. The release notes...
Precise Detects Problem In VMware Storage
Our demo environment had a storage hardware outage. Here is the timeline and how the issue appeared in Precise for SQL Server. 1/9/17- Data Center...
Storage Performance Optimization, I/O Efficiency
Over time, the blocks in a relational database will typically contain fewer and fewer rows of data making each I/O operation less efficient. ...
RUM – Real User Monitoring & Optimization
Precise can show the real end-user experience from "click to disk" aka RUM | Real User Monitoring. Precise automatically injects (no...
Precise for SQL Server Findings Report | automatic problem identification with recommendations
Precise elevates the IT professional to the next level with automatic problem identification and recommendations. Precise detects everything in SQL...
DB2 Monitoring and Optimization – Index Recommendations & Modeling
This blog post explores a strategy for improving processing efficiency within IBM’s DB2 on LUW. The Precise product line is designed for...
DB2 Monitoring Tools | Precise for DB2
The Precise product line brings its high resolution monitoring to DB2 with Precise for DB2. Precise alerts on availability, displays the top...
Precise Alerting: duration of history & GUI speed
Precise keeps a rolling three year history. Some shops value this duration because it includes multiple quarter-end and year-end processing...
The Bloor Group: Hot Technologies with Dr. Robin Bloor, Dez Blanchfield and IDERA
Precise is an Application Performance Management solution. It solves a frustrating, time consuming, and expensive problem. When...
End Users Complaining About Screen Freeze
Few things are more frustrating than not being able to complete a task because the computer screen froze. Screen freezes are particularly...
Peoplesoft 9.2 Upgrade – Fluid User Interface Performance
PeopleSoft version 9.2 offers new functionality to improve processes and productivity. Per PeopleSoft 9.2, there are over 1,000 enhancements. This...