Generate SQL Server performance report from PolicyCenter
Generate a SQL Server performance report from the Server Tools SQL Server Performance Report screen.
Procedure
- Log into Guidewire PolicyCenter using an administrative account.
-
In the left-hand navigation pane, navigate to following location in Server
Tools.
-
Select the options to use in creating the report:
Option Description Include Database Statistics Check to include database statistics similar to those on the Server Tools Database Statistics screen. Include Query Store Analysis Check to include analysis based on the SQL Server Query Store tables. -
If you select the Include Query Store Analysis option,
you need to select one to two time intervals from the table as well.
For the chosen time intervals:
- If you select a single time interval, the generated report includes data for that time period only.
- If you select two time intervals, the generated report includes data for the range of time defined by the two time intervals, inclusive.
After you generate the report, SQL Server Performance Report screen indicates the time range involved in the report description.
-
Click Generate Perf Report.
You can view the progress of the report generation in the report table. Click Refresh report list to update the table information
-
After the batch process completes, select one of the following options in the
summary table:
Option Description Download icon Download a DMVReport.zip file that contains the set of database reports. View icon Open a pop-up window from which you can view the same reports contained in the DMVReport.zip file. This option is available on servers that are in development mode only.
- After you download the DMVReport.zip file, unzip the file into its own directory.
- Locate file index.html and double-click it to open it in a browser.
- Use the links on the screen to navigate through the different types of report information.