Home Forums SQL Server 2008 SQL Server 2008 - General Having a SQL 2008 R2 Database in Memory RE: Having a SQL 2008 R2 Database in Memory

  • November 5, 2012 at 8:59 pm

    #1556278

    Koen Verbeeck (11/5/2012)

    sanket kokane (11/5/2012)

    Also consider this as your very last options.

    To speed up your DB check,first check if there any scope for Query Tuning.

    I wouldn't consider this the last option. Of course, query tuning is important, I won't deny that.

    In the session "Building the fastest SQL Servers", Brent Ozar - which we can consider a performance guru - had this piece of advice for OLTP systems: "add enough RAM so that your DB fits into memory".

    Original video can be watched here:

    http://channel9.msdn.com/Events/TechEd/NorthAmerica/2012/DBI328

    Hi Koen,

    Thanks for the link, i will go and check this out.

    Apart from performance tuning i think the Server may be suffering from not being setup properly such as the hardware. It is all on a single hard disk including the OS.