SQL Server Performance Forum – Threads Archive
SQL errorDear friends, I am using SQL server 2005 in Cluster mode.Its taking upto 4GB memeory.When i am using any application on that it goes up to 6GB memroy.I would like to how can i reduce the memeroy size.Because of this clients receiving data very slow.Could anybody help me out to solved this problem. Thank you in advance
First of all you need to check what sort of activity is happening on SQL Server, you can view in QA or use PROFILER to see the underlying queries. Without much information on processess it is hard to confirm what is causing this behaviour. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing.