1. sql server activity monitor, kill all suspending transactions.
2. Go to the Administrations->Periodic->sql administration -index actions->press re-index for all tables
3. Administrations->Periodic->sql administration -table actions->Synchronize your database
4. restart all the servers like: application server, database server, etc,
hope it will increase performance .
http://blogs.msdn.com/b/axperf/archive/2008/03/13/ax-database-configuration-checklist-part-2.aspx
No comments:
Post a Comment