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: 588
windows-server-2008
|sql-server-2008
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