Home / server / Questions / 359815
Accepted
user1034912
Asked: 2012-02-14 17:02:28 +0800 CST

How do you control which portion of SQL Database gets loaded into Server Memory?

  • 772

My SQL Server Machine has 6GB of RAM but the database size is 20GB. The Database is mainly an events log, clustered-indexed by time.

The clients are mostly interested in the latest data. They want it to be super fast when querying these latest data.

As SQL Server loads itself into server memory, is there a way to instruct SQL to pre-load only the latest data into memory?

sql-server performance memory

2 Answers

  1. Best Answer

    Just issue a query that retrieves that data. But most likely, that will actually wind up doing more harm than good. You really just want to let the data fault in as it is needed.

    • 7

  2. Tune the queries and the indexes so that everything performs in an optimal fashion. That would be the most important thing you can do. If you have optimized queries, you should be fine for memory management. If your queries are doing scans where they could do seeks, you're going to see memory get flushed on every query and performance will stink.

    • 0