August 10, 2010 at 7:19 am
i have 8 GB ram in my production server, but it always cosumes around 7.8 or 7.9 means 95 % memory of total, i checked the sql server take around 5.5 GB.
and rest memory taken by other things, how wud i knw that sql server is taking worth memory?? should i set max memory server for sql server. or should i require more ram to add in that server???
my organization is asking for suggetion
pls help its urgent
August 10, 2010 at 7:43 am
Please read the following and post back with detailed questions;
Server memory options - http://msdn.microsoft.com/en-us/library/ms178067.aspx
Monitoring memory usage - http://msdn.microsoft.com/en-us/library/ms176018.aspx
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 11, 2010 at 12:52 am
i am sending some important counter report, please have a look on it and let me knw what this report is saying and what kind of action shud i take,
this is the report of one minute counter
Physical disk
Disk Transfer/sec 8.412
Process
Page Fault/sec 744.79
Page file Bytes 9059104164
Virtual bytes 30,765,241,269.797
Working set 8,328,829,927
Sql Serv Buffer Manager
Buffer Cache Hit Ratio 99.908
Checkpoint pages/sec 0.00
Lazy Write/sec 0.00
Sql Server Memory Manager
Target Server memory (KB) 5,247,366.377
Total Server momory (KB) 5038865.778
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply