The Standard Toolset of SQL Server Reports can assist in troubleshooting ClickHome3.


To produce the reports:

Right click on your server
Select Reports
Select Standard Reports
Run the reports listed below.
The useful reports are as follows:
Activity - All Blocking Transactions
Top Transactions by Blocked Transaction Count
Top Transactions by Locks Count
Performance - Top Queries by Average CPU Time
Performance - Top Queries by Total CPU Time



Once these have run, Right click and Export as PDF