SQL Server Performance

SQL error

Discussion in 'SQL Server 2005 General DBA Questions' started by mateentaj, Nov 29, 2006.

  1. mateentaj New Member

    Dear 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
    Mateen
  2. satya Moderator

    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
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing.

Share This Page