question

mariusk avatar image
mariusk asked

SQL Server 2005

Hi We have a SQL server 2005 32bit with about 60GB of ram. Is it normal for SQL server to consume 60GB of ram after running for a couple of hours? My answer would be no it should not. I know that SQL Server is memory intensive but it should not consume so much ram for a 20GB database. According to our database guy, it is normal. He is also unwilling to load any service packs on SQL server as he says it would be to complicated and risk full. I would just like some opinions on this for me to create a good argument for them to load the service packs. Regards Marius
sql-server-2005service-pack32-bit
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton avatar image
ThomasRushton answered
Yes, it's normal. SQL Server will run and gradually consume all the memory allocated to it (by default: all the memory). This is to allow for more efficient running of SQL Server, making it more able to respond to queries from the buffer cache rather than having to fetch the data from disk each time. As to whether it's normal for a 20GB database to cause a SQL server to use 60GB of RAM - well, it depends. It's not just a data buffer, but also cached query plans, overhead for user connections, your data isn't the only data being used... If you're worried about it, and want to limit SQL Server to only use an amount of memory, then look at properly [configuring your memory settings within SQL Server][1]. TL;DR exec sp_configure 'show advanced options', 1 reconfigure with override exec sp_configure 'max server memory', 57344 -- set to 56GB RAM reconfigure with override [1]: http://msdn.microsoft.com/en-us/library/ms178067(v=sql.90).aspx
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton avatar image
ThomasRushton answered
As for the Service Packs bit. Well. You're running SQL Server 2005, which is old, and [no longer in Microsoft's Mainstream support][1]. You would be better off looking at migrating to SQL Server 2012. [1]: http://support.microsoft.com/lifecycle/search/default.aspx?sort=PN&alpha=sql+server+2005&Filter=FilterNO
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.