Page History

...

It is based on the same collection technology, but there's a completely new UI, and it is designed from the bottoms up to be extremely easy to install and to use. SQL Workload Analysis is focused on SQL Server performance tuning, stemming from 20 years' R&D and DB tuning experience - all packaged in a user-friendly and effortlessly-deployed application. Precise for SQL Server Enterprise Edition complements SQL tuning with full-blown enterprise functionality including alerts, reports, up-stream application context, and network monitoring.

How can I pause monitoring an instance?

...

This column shows the number of rows in the access table. It may appear when the Operator name is: Table scan, Index seek, or Clustered index seek. Table cardinality should be used in conjunction with the value of Returned row column. Returned rows shows how many rows were returned after applying all the filter predicates for the selected operation. It allows calculating filtering ratio and assessing the potential of using an index. Let's assume: Operation name is Table scan, Table cardinality is 1000000, and Returned rows is 50. It means that SQL Server sequentially scans a 1000000-row table while only 50 rows were qualified after applying relevant filter predicates. Normally an index may help when the filter ratio (Returned rows / Table cardinality) is less than 1%. You may view filter predicates applied by an Operation by hovering on the Operation and then clicking the More properties link in the presented tool tip.

Locks trending graph shows lock types including "

...

MD" prefix – what is it?

"MD" stands for METADATA. It means that the locked object is not user data such as table row or index key. The locked object is some dictionary object that describes user objects. In most cases METADATA locks are caused by DDL (create, alter, drop) rather than DML (insert, update, delete) statements. "MD Partition Lock" means that the partition function of a partitioned table is locked. It may happen when adding / removing partitions. During that time, any application trying to access that partitioned table will be locked. "MD Statistics Lock" means that the lock is due to trying to gather statistics on user objects and update the statistics in system tables. Updating stats in system tables may lock the optimizer when trying to generate an execution plan for queries that access objects on which statistics were gathered. "MD Other Lock" stands for any other METADATA lock (not one of the two mentioned above). The full list of METADATA sub types reported by SQL Server is documented as part of column resource_subtype of table sys.dm_tran_locks.

...

SQL Workload Analysis provides deep visibility past the database and into the EMC storage array, including the ability to detect contention on physical disks or virtual pools. In order to enable this extended visibility, some EMC software needs to be installed on the SQL Workload Analysis server as well as the database hosts. Please consult the following document for the full details of how to extend SQL Workload Analysis' visibility into EMC Storage: SQL Workload Analysis – Installing and Verifying EMC Solution Enabler.

Why do certain statements show zero execution counts?

Idera IDERA SQL Workload Analysis computes the top SQL statements in terms of time spent in the database from one source of such data in the system tables of SQL Server and correlates this with the execution count of that statement from another source (i.e another set of system tables in the SQL Server). Because of sampling rates, sampling errors, and the transient nature of the latter source, the correlation is sometimes not possible for certain statements with very few executions in any given time frame.

...

Save