March 16, 2012 at 11:25 am
I have installed SQL Server 2008 r2 installed on Windows 2008. I have 64 gig of memory available.
Does anyone have a formula/calclation for sizing memory. I want to avoid the trial and error approach.
old versions had a calc such as:
Minimimum Memory = System + User Memory + DB Process Area
where DB Process Area = Log Area and DB Cache size
DB Cache Size = DBCache Block Size * DB Block Elements
March 16, 2012 at 12:55 pm
Try with exploring dbcc memorystatus().
March 16, 2012 at 1:04 pm
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply