Trace File Analysis Made Easy
Tired of sifting through millions of trace events? Just point Qure Analyzer to one or more SQL Server trace files (or trace tables) and let Analyzer do the rest!
Automatically Analyze by Multiple Dimensions
Qure Analyzer processes your trace files and builds a mini data warehouse to characterize every aspect of your database workload, in terms of multiple dimensions: query text, batch templates, applications, hosts, databases, users and execution time. Even individual query parameter values can be included.
Workload Summary
The Workload Summary shows overall resource consumption at a glance. For each dimension (batches, applications, hosts, users etc.) the summary highlights the top resource consumers, with links to drill down further.
See Inside Your Workload Like Never Before
Discover what’s really going on inside your trace files. Dynamic sorting and flexible filtering make it easy to zero-in on the trace events that are of most interest to you.
Answer Complex Workload Questions with BI-like Analytics
The hierarchical, multi-dimensional “Group By” feature helps answer complex questions. For example, “Which users of which applications are consuming the most CPU?” or “Which hosts are generating the most queries between 12:00 and 13:00 on Mondays?”
Compare Trace Files (Workloads)
Need to know how a tuning effort, version upgrade, or hardware change has affected the performance of your database? Qure Analyzer allows you to compare workloads before and after the change, revealing the improvements (or degradations) in detail.
Compare Dissimilar Workloads
Often the production workloads compared will be different – many queries may not exist in both workloads, or may be present in different numbers. Qure Analyzer’s built-in equalization feature supports intelligent comparison of dissimilar workloads.