Recently we have noticed that when updating the table statistics of the SQL database, the OnTime application performance seems to be much better. The following SQL command will update all of the table statistics in the database which should increase the performance of queries that the SQL server performs on daily basis. This command can be used in the SQL Enterprise Manager or the latest SQL 2005 Server Management Studio application.

exec DatabaseName.dbo.spUpdateStatistics @DbName = 'OnTime_db_Name'

NOTE: Replace “DatabaseName” with the name of the database that this stored procedure is created in. And also replace the “OnTime_db_name” with the name of your actual OnTime database.

To create the update statistics stored procedure in SQL; please go to the stored procedure directory using the SQL Enterprise Manager or the SQL 2005 Management studio tools and select “New Stored Procedure”. After you have selected to create a new stored procedure, copy and paste the SQL query from the attached file and select “Execute”. Once the SQL query is executed, the stored procedure will be created. Refreshing the database will display the stored procedure as “dbo.spUpdateStatistics” in the list. Running the above command against your OnTime database will update the statistics of the tables.

NOTE:  It is recommended that this stored procedure is created in an alternative SQL database from OnTime. Upgrading the OnTime application will remove any custom commands and stored procedures from the OnTime database.

Thank you,