Bad Performance when SQL Server hits 99% Memory Usage

Posted by user15863 on Server Fault See other posts from Server Fault or by user15863
Published on 2011-03-15T20:03:41Z Indexed on 2011/03/16 0:11 UTC
Read the original article Hit count: 545

I've got a server that reports 8 GB of ram used up at 99%. When restart Sql Server, it drops down to about 5% usage, but gradually builds back up to 99% over about 2 hours.

When I look at the sqlserver process, its reported as only using 100k ram, and generally never goes up or below that number by very much. In fact, if I add up all the processes in my TaskManager, it's barely scratching the surface of my total available (yet TaskManager still shows 99% memory usage with "All processes shown").

It appears that Sql Server has a huge memory leak going on but it's not reporting it. The server has ran fine for nearly two years, with this only starting to manifest itself in the last 3-4 weeks.

Anyone seen this or have any insight into the problem?

EDIT

When the server hits 99%, performance goes down hill. All queries to the server, apps, etc. come to a crawl. Restarting the service makes things zippy again, until 2 hours has passed and the server hits 99% once again.

© Server Fault or respective owner

Related posts about windows-server-2008

Related posts about sql-server-2008