UI slow loading queries

idiot

Environment is SQL Server

What should I be looking out for
1. when a menu button is clicked, it takes a long time for the menu items to be displayed?
2. it takes a long time for the form to be displayed after clicking?

What can be improved to decrease the UI loading time?
Data entry speed is acceptable...

headley27

Perhaps your SQL Data files are fragmented and quite possibly your indexes.

I quite often run the following procedures via SQL Query Analyzer to keep my database in tip-top shape.

I take the database offline and defrag the hard drive, then I rebuild all the indexes using the original fill factor of the database tables.
Search Google for DBCC DBREINDEX for instructions on how to do this.
In my case, I have a 15GB database and DBCC DBREINDEX takes less than 1 hour to complete.

If you can't take the database offline, DBCC INDEXDEFRAG helps.

Whichever way, I also run UPDATE STATISTICS afterwards as it creates more optimal execution plans.

In all cases you can find scripts on the Internet that will run these commands on all tables in your database (instead of manually processing one table at a time).

http://www.sql-server-performance.com is a great resource.
So is http://www.sqlservercentral.com.

I believe that there is also a white paper explaining SQL Server Optimization for Navision in the downloads section.

Hope this helps.

idiot

Thanks