I recently assisted a CIC with identifying a severe performance problem that was manifesting in Time Matters Enterprise. The problem turned out to be an issue with SQL Server and the Server OS. This problem specifically relates to running SQL Server 64 bit (2005 or 2008) and Windows Server 2003 64 bit.

THE SYMPTOMS:
1. Inexplicable poor performance using Time Matters (occurring intermittently).
2. The SQL Server log will have this message:

A significant part of sql server process memory has been paged out. This may result in a performance degradation.

3. The Windows Event log will throw an "Information" event with ID 17890.

THE CURE:
As it turns out, a gracious consultant has contributed a detailerd explanation and solution for the problem. In essence, the Operating System is stealing too much RAM from SQL Server for system caching. Adding more RAM may put the problem off longer but it will eventually happen again. You can read his post and the solution to the problem on the following URL:

https://msmvps.com/blogs/omar/archive/2007/09/19/a-significant-part-of-sql-server-process-memory-has-been-paged-out-this-may-result-in-performance-degradation.aspx

Maybe this will save you some time in the future!

• < Prev
• Next >