newbieuser (7/10/2013)
Thanks. I'm confused with this one.. I set the maximum server memory(in MB): 2147483647 on the database server. But i the task manager sqlservr.exe is using 3349316K memory. So logically SQL server should only use the max set memory of 2G? Why is it using up over 3G and the memory goes to 96%? Please helpThanks a lot
The default setting is an insanely high value...2048 Terabytes, not 2048 megabytes like you think it is;
for me, that's more ram than i can afford to buy.
could that be contributing to your issue?
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!