Return
-
Title
Resource Breakdown chart in SQL Server PI only has CPU Usage -
Description
In the SQL Server PI (SQL PI) dashboard, only the CPU Usage at 100% is displayed for SQL Server agents.
There are no wait event details available.
This is the panel using an Infobright PI repository
This is the same panel for the same agent using a SQL Server PI repository
-
Cause
Pass_Wait_Event_Dim.sql script was not run during the SQL Server PI repository installation -
Resolution
During the initial beta installations of the SQL Server PI repository using the 5.9.3.25 cartridges, the wait event information was inserted manually as a SQL script as a separate final step. When this step was missed the wait event information was not available for SQL PI.
Please run the attached script in the SQL Server PI repository database for SQL Server agents.
-
Attachments