Memory allocation RRS feed

  • Question

  • Hello all,

    We have a production server (SQL 2005 standard) which has in total around 65 GB of data with one database 50 GB. The server is fairly busy and the queries are sometime slow, especially when accessing large tables with 9-10 millions of rows.

    Now since the OS is Windows 2003 standard, we can only have 4 GB RAM. Will it help if we can change the OS and add more memory with the server? Is it a big issue?


    Wednesday, December 21, 2011 3:32 PM


  • Gaining better performance is either to throw hardware at the problem or tune the app/queries/indexes to that the work your apps do requires less resources. Mose benefits are frequently from the app side, but if you can't do that, then throwing hardware is what you have left. Adding memory will likely make the situation better, seen from a hardware perspective.
    Tibor Karaszi, SQL Server MVP | web | blog
    Wednesday, December 21, 2011 5:00 PM

All replies