My SQL server 2008 R2 is currently running on a server with 16GB RAM , and its currently using almost all the 16GB Ram and at some point it does use all the memory and causes the database not to be available. The Minimum and maximum server memory have been set to
13500 MB - Max
on the server properties page
Yet sql server is currently running on 15738 MB, exceeding the Max memory setting on the database server and atimes reaches 16000 MB and the database server becomes unavailable.
Who can point me to what is causing this pls?
My investigation shows that it might be COM ,extended stored procs, non-shared DLLs etc but how do I make them not to eat up all the memory on the server?