Actually, very good questions.

Yes, other SQL shows on this spid, it is constantly issueing SP_RESET_CONNECTION.

This is an item, that if my memory serves correct, is used by an instantiating connection...

Let me post how this looks in profiler. The DBCC SHOW_STATS appears to be instantiated by the main sp, sp_table_statistics2_rowset . Here's an example of how it looks in profiler....

Ok, but here's what I'm trying to understand..

The statement

"never acquires more memory than the level specified in max server memory."

Does that mean, that it will not ever use the...

This was perfect guys, not sure I understand why it works. The cast appears to be the key, but it works like a charm. THANKS!