SQL Server database options

To filter the information in the Server Tools Database Storage Information screen, select one of the following options from the Storage Set to Display drop-down filter:

Storage Set to Display	Description
Data Spaces	Lists the filegroups taken up by the data and the amount of space taken and allocated by PolicyCenter.
Database Space	Details about the amount of disk spaced taken up by the database.
Guidewire Version	Guidewire product-specific information such as application and platform version. See Understanding Guidewire software versioning.
Index Physical Statistics + Estimated Database Compression Savings for Page Level Components	Lists the statistics about indexes on the physical table. Includes information such as minimum, average, and maximum record size. To change which tables and indexes the Index Physical Statistics filter shows, select a new index. The information that you see depends on the filter options that you set: If you select the Include Estimation of Compression Savings for Tables and Indexes option, PolicyCenter modifies the storage set name to indicate that fact and provides the requested information. If you do not select the Include Estimation of Compression Savings for Tables and Indexes option, you see only Index Physical Statistics as the storage set name. PolicyCenter does not show compression estimation savings information.
Index Usage Stats	Information on the usage of an index on a table, selectable by table name.
Indexes with High Fragmentation	Display average percentage of fragmentation for indexes in the database.
Queries Executed to Build Download	List of SQL queries used to generate the data. The data includes the SQL used to generate the query and other information such as the number of rows returned the time it took for the query to run.
Summary of Queries Executed to Build Download	Simple summary of the number of queries involved in generating the data and the total database time that the queries took to execute.
Tables and Indexes	Lists paging and allocation type of a table and its indexes. To change which table the Tables and Indexes filter shows, select a new table.
TempDB Summary	Shows paging information for the database.