-
Title
Should the Database be re-indexed on a scheduled bases? -
Description
MessageStats
Should the Database be re-indexed on a scheduled bases? -
Resolution
Yes the MessageStats database should be re-indexed on a regular bases. The attached scripted can be used the accomplish this task as well as the Database Maintenance that is offered in SQL 2000.
The attached SQL file will create a SQL job that re-indexes the MessageStats database every Sunday at 4:00AM (local SQL server time).
Load it in Query analyzer and execute it.
It can be view/change its properties by expanding "Management/SQL Server Agent" and clicking jobs. A job called "QMSRe-index" will be displayed. It can be double click on to view its information (such as General/Steps/Schedules/Notifications). To change its schedule, go ahead and choose the schedules tab and click edit.
NOTE: SQL Server Agent must be running to do this. It might have to run as a valid account (rather than local system account). -
Attachments