data-konzept

'Recently on one of our staging servers had a memory consumption issue and

even 32 GB of RAM was looking insufficient and application performance was being impaired. Initially I thought the cause would be poorly designed queries, but after a thorough investigation this turned out not to be the case. I
noticed that whenever the Re-indexing and Update Statistics jobs executed
against the database the memory consumption increased considerably.
The size of the database was 155 GB, the server had 32 GB of RAM as well as 8
CPU’s on it.

While performing the investigation of the system, I decided
to test the performance of the Re-indexing and Update Statistics tasks
separately.

The T-SQL used for performing the Re-indexing of the
database is as shown below...'...

http://www.sql-server-performance.com/2016/trouble-shooting-sql-server-ra-memory-consumption/