size of sqlservr.exe and ssmsee.exe showing greater than the max memory setting

See more:

SQL-Server-2005

SQL-Server

Dear All,

I have a issue with the max memory setting of sql server 2005 where sqlservr.exe and ssmsee.exe showing greater than the max memory setting in Task Manager.
There is a issue of memory leakage on Live Server.
I am trying to test the same on my local PC with Sql Server 2005 express edition installed.

I set the maximum server memory to 16MB.
Even after that sqlservr.exe showed 40484 KB and ssmsee.exe showed 77464 KB in the task Manager.

After that I opened a query window and written a select statement of infinite loop like,

WHILE 1=1
SELECT 10

After executing the above, the size of ssmsee.exe kept growing continuously and reached 364464 KB till I stopped the running query.

I am confused here on how do I control this scenario.
I have went through a lot of stuff on the net but could not find any thing concrete.

Any help and explanation on memory would be much appreciated.

Regards,
Gopal


I dont know if i m on the right track. On live server the size of sqlservr.exe increases gradually.