May 25, 2010 at 7:03 am
Dear Master,
I have question in my sql server 2005 64 bit, why in memmory to use very high, about 6GB sql server specification is:
1. Windows 2003 standard 64 bit
2. SQL 2005 Standard 64 bit
3. RAM server 8GB
4. Processor Xeon Dual Quad core
5. MDF file 4GB
in memmory process always increase starting from 3GB to 6GB, and if it exceeded the 6GB, the system will slow down, and I check in sql perfmon disq queue length very high.
what should I do about this problem.
for helping me say many thanks
Regards,
Anton I Setiawan
May 25, 2010 at 9:02 am
antoniset (5/25/2010)
Dear Master,I have question in my sql server 2005 64 bit, why in memmory to use very high, about 6GB sql server specification is:
1. Windows 2003 standard 64 bit
2. SQL 2005 Standard 64 bit
3. RAM server 8GB
4. Processor Xeon Dual Quad core
5. MDF file 4GB
in memmory process always increase starting from 3GB to 6GB, and if it exceeded the 6GB, the system will slow down, and I check in sql perfmon disq queue length very high.
what should I do about this problem.
for helping me say many thanks
Regards,
Anton I Setiawan
1) You WANT sql server to take ram, because it keeps you from having to hit the disks for every activity.
2) You MUST set a max memory limit for sql server to keep it from taking too much ram
3) disk queue length is not a valid metric for most modern systems. use avg disk sec/read and avg disk sec/write instead. But in any case, if you are having an IO problem it is because you a) need MORE ram and b) have a slow IO subsystem.
4) There are many things that can and should be done to improve your performance. I HIGHLY recommend you get a performance tuning professional on board to help improve your system and mentor you on how to be better at that job yourself.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply