Tuesday, November 10, 2015

SQL Server 2005 Memory

SQL Server 2005 is a complete memory hog. Keep in mind this problem is fixed in newer versions, though I've seen those suck up a lot of ram as well. Today I was working on a server with 32 gigs of ram, tried to delete a few million rows, and watched as SQL Server memory allocation ticked up from 2.5 gigs, to 3, to 5, all the way to 9 gigs. Basically it takes up all that ram trying to do its deletion, but never releases it. So after five minutes when I noticed the deletions were completed, SQL Server was still using 9 gigs of ram. Old problems still exist I guess.

No comments:

Post a Comment