SQL 2005 x64 memory usage (and leakage)
Posted on 2008-10-10
I just set up a new SQL2005 server standard edition x64 on win 2003 server x64. The box is a quar core xeon with 4 gigs of ram and a 6 gig swapfile on a partition other then the sql install or the db partitions. Our developers moved applications from a SQL2000 (Standard, x32) server on to the 05 box. What has been happening is that over the course of the day, page file useage rises. It gets up to about 3.9gigs, even though the CPU's activity is nill (1-2% or so). Once it gets that high, I start panicing and restart the SQL service (late at night, as not to drop active sessions) and it drops to about one gig. Then it begins it's rise again.
Now, the server hasn't crashed, or become unresponsive yet, but historically, when our SQL2000 boxes started a rise like this, it ended badly...
So my initial assessment was a memory leak in one of the applications using the server, but none of the developers can identify any problem with their code (all asp.net web apps). So my thoughts went to x64 SQL 2005, that maybe this is a normal condition?