IBM Tivoli Composite Application Manager for Microsoft Applications, Version 6.3

MS SQL Lock Summary attributes

The MS SQL Lock Summary attribute group contains attributes that you can use to monitor the number of database locks that are currently open.

Exclusive Extent Locks The number of granted Exclusive Extent locks.

Exclusive Intent Locks The number of granted Exclusive Intent locks.

Exclusive Locks The number of granted Exclusive locks.

Exclusive Page Locks The number of granted Exclusive Page locks.

Exclusive Table Locks The number of granted Exclusive Table locks.

Extent Locks The number of granted Extent locks.

Host Name The name of the computer on which the SQL Server is running. The value format is an alphanumeric string with a maximum of 64 characters, for example, Voyager. This attribute is not available for use in situations or for historical data collection.

Hub Timestamp The time when this data was inserted at the hub. This attribute is not available for use in situations. Otherwise, this attribute is available to use like any other attribute, for example it is available for reports, queries, and workspaces.

Intent Locks The number of granted Intent locks.

Originnode The key for the table view in the format serverid:hostname:MSS. This attribute is not available for use in situations. Otherwise, this attribute is available to use like any other attribute, for example it is available for reports, queries, and workspaces.

Page Locks The number of granted Page locks.

Pct Max Locks The percentage of locks on resources of the maximum number of locks allowed by the SQL server. The value format is a percentage with two decimal places allowed; for example, 10.00. Setting a higher limit for the maximum number of locks does not impair performance. If your operations exceed the number of available locks, you can increase this limit. This attribute is not available for use in situations or for historical data collection. Otherwise, this attribute is available to use like any other attribute, for example it is available for reports, queries, and workspaces. To create a situation, use the MS SQL Server Enterprise View attribute group. The following value is valid:

External value	Internal value	Description
Not Collected	-1	The value could not be collected.

Sample Timestamp The timestamp that indicates the date and time the product collected the sample for the SQL server. A sample is the data the product collects about the SQL server. The format is MM/DD/YY HH:mm:SS, where:

MM	Month
DD	Day
YY	Year
HH	Hour
mm	Minute
SS	Second

For example, 01/25/02 08:00:00 indicates that the product collected the data from the SQL server on Friday, January 25, 2002 at 8:00 a.m.

Server The name of the SQL Server.

Shared Intent Locks The number of granted Shared Intent locks.

Shared Locks The number of granted Shared locks.

Shared Page Locks The number of granted Shared Page locks.

Shared Table Locks The number of granted Shared Table locks.

Table Locks The number of granted Table locks.

Table Lock Escalations per Sec The number of times that the locks on a table were escalated.

Total Lock Conflicts The total number of processes involved in lock conflicts. The value format is an integer. This attribute is not available for use in situations or for historical data collection. Otherwise, this attribute is available to use like any other attribute, for example it is available for reports, queries, and workspaces. To create a situation, use the MS SQL Server Enterprise View attribute group. The following value is valid:

External value	Internal value	Description
Not Collected	-1	The value could not be collected.

Update Extent Locks The number of granted Update Extent locks.

Update Page Locks The number of granted Update Page Locks.

Feedback