Page History
...
- About the Objects tab
- How the Objects tab is structured
- About Objects tab entities
- About the Instance entity
- About the Database entity
- About the Active Objects entity
- About the Table and Table Contain Same Column entities
- About the Partition entity (SQL Server 2005 only)
- About the Column entity
- About the View and View contain Same Column entities
- About the User entity
- About the Logical File entity
- About the File Group entity
- About the Statistics entity
- About the Stored Procedure entity
- About the Function entity
- About the Trigger entity
- About the Statement entity
- About the Batch entity
- About the Physical Disk entity
- About the Logical Volume entity
- About the Disk Partition entity
- About the Storage Unit entity
- How the Objects tab can help you identify performance problems
...
The Change Log Summary view displays changes made to the table and index levels vs. resource consumption, over a selected time period, to enable you to locate schema changes that caused performance problems. The following information is displayed:
- Change Log Summary.
- Sample Date. Indicates the estimated last change date of the table (and/or its sub-objects). This value reflects the date that the change was first identified by the Precise for SQL Server Schema Changes Process, not the date the object was changed.
- Object Type. Indicates whether the object is a table or index.
- Object.
...
- Displays the table or index name.
- Change Type. Indicates the type of change detected. The following change types are reported:
...
- Created. Indicates that the index was created
...
- Dropped. Indicates that the index was dropped
...
- Change in Structure Table. Indicates any change that was made to the table's column(s) and the creation or deletion of the table's trigger(s).
...
- Index. Indicates any change that was made to the index keys of the index or to the index depth.
...
- Change in Properties Table. Indicates any change that was made to one of the following table's properties: Name, Owner or File Group.
...
- Index. Indicates any change that was made to one of the following index's properties: File Group, Fill Factor, Is Auto Statistics, Is Clustered Index, Is Pad Index, Is Page Lock Disallowed and Is Row Lock Disallowed.
- In MS-SQL. Displays resource consumption of the selected table, over a selected time period, based on its contribution to overall performance, when accessed by the execution plan.
- Schema Changes. Displays an overtime graph that indicates whether changes were made to the selected table and a breakdown of its indexes or columns into the following groups:
...
- Table Change in
...
- Property. Indicates any change made to one of the table's properties, such as if the table was renamed.
...
- Table Change in
...
- Structure. Indicates any change made to the table's structure, such as whether a new column was added to the table.
...
- Index Change in
...
- Property. Indicates any change made to one of the index's properties, such as whether the index was changed from clustered to non-clustered.
...
- Index Change in
...
- Structure. Indicates any change made to the table's index properties, such as whether a new key was added to the index.
...
- Index Created/
...
- Dropped. Indicates any addition or deletion of indexes.
About viewing schema changes made on a selected table in the Change Log Detailed view
The Change Log Detailed view details the schema changes made on the selected table and its sub-objects (column, index and index key).
The following table information is monitored by the schema change process:■ Name
- Name
...
- File Group
...
- Exec is ANSI null on
...
- Table has Cluster Index
...
- Insert Trigger Count
...
- Owner
...
- No. of Columns
...
- Table has Index
...
- Delete Trigger Count
...
- Update Trigger Count
...
- Partition Schema
...
- Partition Function
About viewing usage information and access methods in the Usage Report
The Usage Report view displays usage information and access methods based on statements stored in the PMDB. The following information is displayed:
- Report was run with the following parameters
...
- . Displays usage information of the selected index, as follows:
...
- Start Date. Indicates the minimum execution date for a statement, within the selected time period.
...
- End Date. Indicates the maximum execution date for a statement, within the selected time period.
- Statement
...
- Explain. Displays the following items:
...
- Statement Access the
...
- Object. Indicates the total number of statements that were explained successfully in the PMDB that refer to the selected table, within the selected time period.
...
- Statement Not Access the
...
- Object. Indicates the total number of statements that were explained successfully in the PMDB that do not refer to the selected table, within the selected time period.
...
- Statements Not Explained
...
- Yet. Indicates the total number of statements in the PMDB that were not yet explained, within the selected time period.
...
- Statements Explained Unsuccessfully. Indicates the total number of statements in the PMDB that were explained unsuccessfully, within the selected time period.
- Table
...
- Profile. Displays a breakdown, by statement type, of the number of statements that referred to the specified table (SELECT, INSERT, UPDATE, DELETE); for example, 100 statements performed SELECT on the specified table. The In MS-SQL counters (Using CPU and I/O Wait) are also displayed.
About viewing common access patterns for tables or index (SQL Server 2005 only)
The Common Access Patterns view displays information that indicates to what extent a table or index was used. The following information is displayed:
- User
...
- Operations. Displays the number of user seeks, scans, lookups or updates.
- System
...
- Operations. Displays the number of system seeks, scans, lookups or updates.
- User vs. System
...
- Operations. Graph comparing user operations to system operations, over the selected time period.
- Last User or System Seek, Lookups, Scans or Updates
...
- . Displays when the last user or system seek, lookup, scan or update operation occurred.
About viewing operational statistics
The Operational Statistics view displays information that indicates whether or not an index or table is being used. The following graphs are displayed:■ Range
- Range scan vs. Singleton lookups
...
- Physical I/O operations
...
- Locking and Latching contentions
...
- Locking and Latching contention waits
About the Table and Table Contain Same Column entities Association area
You can view general details of the entities associated with the selected Table entity in the Association area. It is possible to associate to the Table entity from the following entities: Database, Column, Index, Physical Disk, Logical Volume, HP Storage Device, HDS Storage Device, Statement, Batch, Stored Procedure, Function and Trigger.
The following additional information is available for SQL Server 2005 objects:Partitions Indicates
- Partitions. Indicates the number of partitions defined for the selected table.
- Table
...
- Partitioned. Indicates whether or not the table is partitioned.
- Partition
...
- Schema. Indicates under which file groups to map the partition.
- Partition
...
- Function. Displays the name of the function that defines how the table should be partitioned.
| Anchor | ||||
|---|---|---|---|---|
|
The Index entity displays general details regarding resource consumption, space utilization and schema changes for the selected index.
...