My PM generation takes a very long time. Is there any way to speed it up.

SQL Server makes it possible to index specific tables. This can speed up some operations on those tables. In particular, some versions of SQL Server run into errors where PM Generation fails because of "time-out" problems. You can deal with such problems (and increase the speed of Planned Maintenance generation) by following these steps:

1. Make sure that no one is using MainBoss.
2. Login to an account with SQL Server Administration privileges.
3. Start SQL Server Management Studio (or Management Studio Express) and connect to the server that manages the MainBoss databse.
4. On the left hand side of Management Studio, expand the entry for Databases and find the MainBoss database.
5. Right-click on the entry for the MainBoss database; in the resulting menu, click New Query.
6. The right hand side of the window turns into an area where you can enter a SQL query. Copy the following text from this web page and paste the text into Management Studio's query window:

   CREATE NONCLUSTERED INDEX [ScheduledWorkOrderID] ON [dbo].[PMGenerationDetail] (
   	[ScheduledWorkOrderID] ASC
   )WITH (STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF,
    DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON)
    ON [PRIMARY]
   GO
   

7. Right-click on the window containing the query you just entered. In the resulting menu, click Execute. Management Studio should tell you Command(s) completed successfully.
8. Quit Management Studio. If it asks you whether you want to save the results of your query, you can answer no. (Your query successfully added the index to the database. Saving the query just means saving the text that you pasted in.)

Back to FAQ index