August 28, 2008 at 9:47 am
Hi,
We have a Sql 2005 64 bit EE server , 16 G RAM that runs SQL server, Analysis Services and application processes.
We have 12G allocated to SQL and the analysis services constantly uses ~ 6.5G. SqlService uses 0.2G on an average.
The page file is 4.5G and paging file usage is constantly at 100%
During the weekends, we are seeing performance slowness on the application processes while running the SQL processes and cube refreshes simultaenously. The memory usage for SQL also shoots upto 11G and the PF usage on task manager shows 17.8G.
The VM reserved from DBCC memorystatus shows a constant 16.8G.
Qns:
How does SQL reserve the VM?
Are the setting configured for optimal performance or should they be reconfigured ? Shou;d we allocate lesser memory to SQL and SSAS, so that application processes have more to run on?
Should we use the lock pages in memory option? Is using this option ALWAYS beneficial for SQL 2005 64 bit?
Please advise ..
Thanks!
August 28, 2008 at 9:54 am
It is not considered a good practice to have sqlserver and analysis server on the same physical box.
Exactly for the reasons you see.
They are different by nature and will compete for cpu, ram, disc, io-capacity.
With sql2005 x64 I always grant "lock pages in memory" to the service account. Just keep in mind to set your "max servermemory" configuration option for sqlserver.
Maybe Windows system resource manager (WSRM) can help you get control over your Analysis server memory consumption.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
August 28, 2008 at 9:59 am
Thank you
Does the VM reserved by SQL have an impact on memory available to other processes?
How does SQL reserve the virtual memory? Can that be controlled in anyway?
August 28, 2008 at 10:06 am
you can check the -g parameter option for incresing memory area for application , not good practice but can be helpfull sometime
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply