Home Forums SQL Server 2005 Administering /3GB Switch RE: /3GB Switch

  • July 2, 2009 at 5:37 am

    #1019050

    MichaelJasson (7/2/2009)

    Thanks for your response SSCrazy and Gail.

    The reason I want to do that is that my application is running very slow. I want to allocate more memory to sql server because page reads/sec and page writes/sec are really havoc.

    /3GB would help me allocating one GB more to sql server and would help increasing the cache/Buffer by 1 GB.

    I think Cache and Buffer are same thing. Correct me if I am wrong.

    -MJ

    You should give us more information regarding your environment as how much your memory is? what are the min and max memory settings on your SQL server. is it 32-bit or 64 bit? and also the reason that you want to switch on the /3GB? then we would be abel to give you a clearer idea.