Q: OnTime is running slow, my server specs are above the recommend specs and I've watched all of the Fear The Bug Podcasts on performance located HERE, HERE and HERE, is there anything else that I should look at?

A: In some instances where the database is not managed properly the log file can grow so large that it affects the performance of OnTime, in some extreme cases we've even seen this cause timeouts. This can be resolved by simply shrinking the Log File in SQL. While this is an operation normally performed by your Database Administrator and is usually even scripted to be performed automatically, we do offer an option for shrinking the log file through the OnTime Metrics Tool.

• In the OnTime Windows, logged in with the Administrator Security Role, click on Help>OnTime Metrics. Enter in your SQL credentials and load the OnTime Metrics Tool.
• Click on the Cleanup Menu>SQL>Shrink Log File.

Consult your Database Administrator before shrinking the log file as SQL Administration is a complex subject and we've just scratched the surface here.

Here's a link that covers the subject a little bit more in-depth: http://support.microsoft.com/kb/873235

---

Regards,
Sean McHugh
Axosoft Support
Click HERE to take our support survey.