I have a problem with one of the SQL servers I work on. It is a data warehouse server with 1024GB or memory. The server max server memory is set at 512GB. At times the server use memory by sql server goes up to 990GB used memory. At those times it becomes very slow and we get timeouts on connections and running stored procedures. We use a lot of clustered and nonclustered columnstore indexes on the server. I checked on the server and at those times the buffer pool is at 400GB, but the column store object pool is at 500GB. My question is how do we control the size of the column store object pool.