Skip to Content
Sep 02, 2021 at 08:26 AM

How to quickly consume database memory such as Data Cache or Procedure Cache?


I need to simulate a database out of memory scenario.

To do this, what SQL statements can be executed concurrently in the database to efficiently consume database memory?

The target memory type is the (Default) Data Cache or Procedure Cache.