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 Index and Unused Index 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

...

For example, when you want to view information on a specific logical file, choose Logical Files from the Association controls. The Association area changes to display all the files groups associated with the selected Logical File. Note that the Tab heading and the Main area remain unchanged. In the Association area, click the row of the logical file you want to view detailed information for. The Tab heading indicates the newly selected entity; the Main area displays an overview of the logical file you want to investigate, and the Association area shows general details on the file groups that are associated with the Logical File you selected.

See “About About Precise for SQL Server tabs” on page 22tabs.

About the Recommend tab

Precise for SQL Server uses the Microsoft® Index Tuning Wizard to achieve recommended indexes or statistics for the selected table. This helps the optimizer choose a better access plan and enhances the performance of the statements or batches that access the selected table. The recommendations are based on a workload. The workload contains all the statements stored in the PMDB that were executed during the selected time period that have an average duration time exceeding the value defined in the registry (where 0 is the default). The recommend indexes process only performs the recommend process on indexes or statistics additions.

...

• the name of the user, object, and database it is associated with
• a summary of the time it spent in SQL Server, during the time frame you selected
• its size (in pages)

See “About About the Table and Table Contain Same Column entities” on page 113 and “About entities and About the Index and Unused Index entities” on page 117entities.

About the Active Objects Association area

...