February 19, 2014 at 2:27 pm
I have a SQL2008R2 server that pretty consistently hogs about 47GB of the 48GB of RAM on the box. One of the sys admins has asked me to change the limit. He didn't specify what to set it at. It's currently just the default (dynamic). I've never played with this and I'm iffy about it. It's a critical server. It's our SharePoint database, which houses several business-critical functions and it's hit this hard 24x7x365. My fear is that if it's consistently using all of the RAM, it may be because it needs it. If I crank that limit down, is my server going to crash?
February 19, 2014 at 3:42 pm
duplicate thread
post answers to http://www.sqlservercentral.com/Forums/Topic1543228-1550-1.aspx
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply