Identify the
CAUSES of your worst performance bottlenecks The
most common source of SQL Server performance bottlenecks are
poorly performing queries. Systems which display stressed
hardware characteristics such as high CPU, disk or memory
utilisation are simply trying to process queries, which may be
running inefficiently. SQLBenchmarkPro "listens" to query
activity occurring within SQL Server (tm) via its TraceAPI,
collecting information about the performance of those queries.
An easy to use analytical user interface then allows you to
easily identify which queries are consuming the most resources
over any given period of time.
|