Clarity

Lately we have been experiencing performance problems with Clarity. Ours is 8.1 version with SP2. Database: SQL server 2005.

The users generally reporting performance problems while working in the Finance module. Generally during month ends when there is tons of invoices the clarity performance dips. Mostly in demand billing and post to wip job causes these.

We clear the cache count or some times restart the clarity services to speed up. But I wish to know the exact places where I should check for reasons which cause these performance problems.

Regards
Abhi

You might start with
How do make sure Clarity is "healthy?"
at the top of this category.

Then see if
White Paper - Clarity SQL Server Maintenance
https://support.ca.com/phpdocs/7/7799/whitepaper_sqlmaint.pdf
in CA Clarity Implementation Document Index
https://support.ca.com/irj/portal/anonymous/phpdocs?filePath=7/7799/7799_imp_techdocindex.html
has anything for you.

KB Document ID: TEC439209 refers to a document with a slightly different name
Title: Microsoft SQL Server Maintenance for Clarity (Niku KB ID: 7709)
https://support.ca.com/phpdocs/7/7799/infodocs/Whitepaper_Clarity_SQL_Server_Maintenance.pdf


Then you could see how do you compare to
Clarity 8.1 SP1 Windows SQL Server 2005 Performance White Paper
https://support.ca.com/phpdocs/7/5590/5590_SQLServer_WhitePaper.pdf
in
CA Clarity whitepapers Index
https://support.ca.com/irj/portal/anonymous/phpdocs?filePath=7/5590/5590_whitepaperindex.html

and then you could search the Knowledgebase for SQL Server documents.

Martti K.

Thanks Martti.