After first creating our XenApp 6.5 farm, The App Center was quite quick to load. In particular when creating/editing Citrix Policies. However over time it is running slower & slower. Eg any type of Citrix Policy change can take anywhere between 40-60 seconds to complete & refresh the console. It's not the end of the world, but as you can imagine when making large scale changes, it becomes a very long process.
Since the farm went live (about 12 months ago), we have had to restore the Database a few times from backup. mainly from junior administrators opening the AppCentre from a host other than a data collector, being impatient during editing a citrix policy & trying to click around. This resulting in crashing the console. After trying to reopen, we find all the policies had disappeared except for the one that was being created/edited.
What sort of maintenance should I be doing on our Data Collectors & the Database Server?
The Data Collectors are both Win 2008 R2 SP1 with XA65 RP4 installed.
Database Host is Win 2008 R2 SP1 with SQL 2008 R2