Setting the max server memory to a sensible value as Gail put it worked.

The SQL server memory utilization is now going beyond the previous 6.5GB mark.

Thank you one and...

Gail ,

The server has a total of 24GB RAM

I set it to 14GB /14336 MB

Will report back after the holidays.

Thanks.

PS: I am going through your book...

Thanks Gail will check the book out.

Luis Thanks for the response, please see below for output of query, but note we did not set it , the server set...