Page History
This section includes the following topics:
- About the Activity tab
- How the Activity tab is structured
- About the entities you can examine
- How the Activity tab can help you identify performance problems
Anchor | ||||
---|---|---|---|---|
|
The Activity tab allows you to analyze performance behavior over time or within a given time period. When investigating a performance issue, the Activity tab is an excellent place to start. You can easily identify the performance profile of your SQL Server instance and determine who is executing which application, what they are waiting for and how many resources are they consuming. This is the critical information you need to identify the top consumers of your SQL Server Instance and its major latencies. By focusing on the top consumers and latencies (wait states) you can maximize the tuning impact on your system while minimizing the time it takes to obtain results.
...
Info |
---|
If you are working with SAP, PeopleSoft, or Siebel, and ERP support is installed, the Activity tab displays information on the historical SQL Server activity in relation to the ERP application and users, and specific information on executed views and transactions. |
Anchor | ||||
---|---|---|---|---|
|
Figure 6-1 Precise for SQL Server Activity tab structure
...
See “About drilling down in context” on page 27, “About the Precise bar” on page 24, “About the Main area” on page 25, “About the Association area” on page 25, “Focusing on information in overtime graphs” on page 32. See “How most tabs are structured” on page 23, “Tasks common to most tabs” on page 28, and “About the Dashboard tab” on page 46.
Anchor | ||||
---|---|---|---|---|
|
The Activity tab displays information on different entities. This section provides an overview of all entities, their meaning, and their views. By default, all entities open in the In MS-SQL view, with the exception of the Statement, Batch, Collapsed Statement and Collapsed Batch entities which open by default in the Overview view.
...
Table 6-2 Information displayed in the Performance tab
Column Description
Entity Name (such as Instance, Database) Displays the name of the entity.
...
Table 6-3 Information displayed in the Procedure Cache tab
Column Description
Entity name (such as Instance, Database) Displays the name of the entity.
...
Table 6-4 Statement, Collapsed Statement, Batch and Collapsed Batch entities
Entity Description
Statement Displays information on the activity of a specific TSQL statement. A statement is always part of a batch.
...
Table 6-5 Information displayed in the Performance tab
Column Description
Column Description
Click to launch the SQL tab with the Click to launch the SQL tab with the selected entity, to continue your analysis of the selected statement or batch.
...
Table 6-6 Information displayed in the Statistics tab
Column Description
Click to launch the SQL tab with the selected entity, to continue your analysis of the selected statement or batch.
...
Table 6-7 Information displayed in the Procedure Cache tab
Column Description
Entity name (such as Instance, Database) Displays the name of the entity.
...
Table 6-8 Information displayed in the Plan tab
Columns Description
Click to launch the SQL tab with the selected entity, to continue your analysis of the selected statement or batch.
...
Table 6-9 Information displayed in the Performance tab
Column Description
Entity Name Displays the name of the Collapsed Statement or Collapsed Batch.
...
Table 6-10 Information displayed in the Statistics tab
Column Description
Entity Name (such as Collapsed Statement) Displays the name of the entity.
...
Table 6-11 Information displayed in the Procedure Cache tab
Column Description
Entity name (such as Instance, Database) Displays the name of the entity.
...
The following table describes the additional information displayed in the Performance tab in the Association area.Table 6-12 Information displayed in the Performance tabdisplayed in the Performance tab in the Association area.
Table 6-12 Information displayed in the Performance tab
Column Description
SPID Displays the system process ID. The SPID is a unique integer assigned to each user connection when the connection is made.
...
Table 6-13 Information displayed in the Statistics tab
Column Description
SPID Displays the system process ID. The SPID is a unique integer assigned to each user connection when the connection is made.
...
The Locked Object displays the time each object was locked. The collector determines that an object is locked according to its lock type and lock resources. The following lock types are displayed:
Table 6-14 Lock types
Type Description
Database Lock on the entire database.
...
This view displays general information regarding the I/O entity. For example, for a Logical file entity the information displayed is: Logical File, File Database and Physical File name (including the path). In addition, the I/O wait duration over the selected time period is displayed.
Anchor | ||||
---|---|---|---|---|
|
You can identify a performance problem by doing one or more of the following:
...
Table 6-15 Benefits of the Precise for SQL Server Interpoint extension
Type of application Benefit
...