Page History
...
The File Group entity displays general details and space utilization, over the selected time period, for the selected file group.
About the Overview
The Overview displays general File Group details such as whether the file group is read-only and information regarding the file group's space utilization, over the selected time period, as follows:Properties Displays
- Properties. Displays general File Group details such as whether the file group is read only, or whether this is the default file group.
...
- Storage. Displays the amount of free space and used space of the selected file group, over the selected time period, based on the data collected by the Collect Space Utilization process.
About the File Group entity Association area
You can view general details on the entities that are associated to the selected File Group in the Association area. It is possible to associate to the File Group from the following entities: Database, Table, Index, Logical File, Physical Disk, Logical Volume, HP Storage Device and HDS Storage Device.
...
The statistic entity displays distribution statistics on the selected collection (set of columns). The following views are available:■ Overview
- Overview
...
- Statistics
About getting an overview of the selected statistic
The Overview displays general details of the selected Statistic such as keys and an indication when the statistics were last calculated.
About viewing distribution statistics
The Statistics view displays distribution statistics for the selected statistic. see “About viewing distribution statistics for a selected index” on page 120.
About the Statistics entity Association area
You can view general details on the selected Statistics entity in the Association area. It is possible to associate to the Statistics entity from the Table and Column entities.
...
The stored procedure entity displays general details and resource consumption of the selected stored procedure. The following views are available:■ Overview
- Overview
...
- Text
About getting an overview of a stored procedure
The Overview displays general properties of the stored procedure, provides resource consumption information, in addition to the number of times the selected stored procedure's statements were executed, based on the data collected by the Precise for SQL Server Collector for the selected time period.
The following information is displayed:Properties Displays
- Properties. Displays general details of the stored procedure such as whether the stored procedure is an extended procedure, and whether the stored procedure was created during installation.
- In MS-
...
- SQL. Displays the resource consumption of the selected stored procedure, based on the data collected by the Precise for SQL Server Collector for the selected time period.
...
- Attributes. Displays selected attributes that exist for each stored procedure, such as if the stored procedure has the flag
Anis Null Onset to On or Off. - Statement
...
- Execution. Displays the number of times the selected stored procedure's statements were executed, based on the data collected by the Precise for SQL Server Collector for the selected time period.
About viewing the text of a stored procedure
The Text view displays the stored procedure's text.
About the Stored Procedure entity Association area
You can view general details on the entities associated with the selected Stored Procedure entity in the Association area. It is possible to associate to the Stored Procedure entity from the Database, Table, View, User, Stored Procedure and Function entities.
...
The function entity displays general details and resource consumption of the selected function. The following views are available:■ Overview
- Overview
...
- Text
About getting an overview of the Function entity
The Overview displays general details of Function entity, as follows:Properties Displays
- Properties. Displays general properties of the function, such as type of function (inline, scalar, etc.), and whether or not the function was created during installation.
- In MS-
...
- SQL. Displays the resource consumption of the selected function, based on the data collected by the Precise for SQL Server Collector for the selected time period.
...
- Attributes. Displays selected attributes that exist for each stored procedure, such as if the stored procedure has the
...
- flag
Anis Null Onset to On or Off. - Statement
...
- Executions. Displays the number of executions of the selected function's statements, based on the data collected by the Precise for SQL Server Collector for the selected time period.
About viewing the text of a function
The Text view displays the text of the function.
About the Function entity Association area
You can view general details on the entities associated with the selected Function entity in the Association area. It is possible to associate to the Function entity from the Database, Table, View, User, Stored Procedure and Function entities.
...
The trigger entity displays general details and resource consumption of the selected trigger. The following views are available:■ Overview
- Overview
...
- Text
About getting an overview of general trigger properties
The following information is displayed in the Overview:Trigger Displays
- Trigger. Displays general trigger properties such as trigger name, and the name of the table on which the trigger is defined, and whether this is the first trigger fired when data is deleted from a table.
- In MS-
...
- SQL. Displays resource consumption of the selected trigger, over a selected time period, based on the data on trigger statements collected by the Precise for SQL Server Collector.
...
- Attributes. Displays selected attributes that exist for each stored procedure, such as if the stored procedure has the
...
- flag
Anis Null Onset to On or Off. - Statement
...
- Executions. Displays the number of times the selected trigger's statements were executed, based on the data collected by the Precise for SQL Server Collector for the selected time period.
About viewing the text of a trigger
The Text view displays the text of the trigger.
About the Trigger entity Association area
You can view general details on the entities associated with the selected Trigger entity in the Association area. It is possible to associate to the Trigger entity from the Database, Table, View and User entities.
...