September 12, 2008 at 9:02 am
Due to what's probably a poorly written application, the Page File increases throughout the day and affects CPU performance especially during peak transaction processing. We seem to have enough RAM now on the server but there's a direct relationship between CPU performance and the Page File.
The only way I can reduce it is to restart SQL Server which purges it. This reduces CPU utilization but it's a little "risky" to have to always restart SQL Server for this reason.
We're running SQL Server 2005 SP2 Version 9.00.3050, 64-bit Standard, have 18gb RAM available to SQL, and 4-dual core AMD64 processors.
Has anyone experienced this and how did you take care of the problem? Thanks!
September 12, 2008 at 9:34 am
please do not cross-post
http://qa.sqlservercentral.com/Forums/Topic568621-360-1.aspx
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply