RE: What process is consuming my VAS Reservation

SSC Enthusiast

Points: 151

January 20, 2013 at 7:55 pm

Thanks for the reply.

Did run the query and got the these result:

typevirtual_memory_committed_kbmulti_pages_kb

MEMORYCLERK_SQLBUFFERPOOL68481144

OBJECTSTORE_LOCK_MANAGER40960

MEMORYCLERK_SQLSTORENG115256

MEMORYCLERK_SQLUTILITIES2400

MEMORYCLERK_SOSNODE06072

MEMORYCLERK_SOSNODE02800

MEMORYCLERK_SQLGENERAL02456

CACHESTORE_SQLCP0344

MEMORYCLERK_SQLSERVICEBROKER0192

CACHESTORE_OBJCP0112

MEMORYCLERK_SQLOPTIMIZER088

MEMORYCLERK_HOST064

MEMORYCLERK_SNI016

CACHESTORE_STACKFRAMES08

OBJECTSTORE_SNI_PACKET08

CACHESTORE_STACKFRAMES08

OBJECTSTORE_SNI_PACKET08

From the information gathered, how could I actually pinpoint which processes is consuming VAS. Which clerks actually relates to dblinks, CLR, etc.

Thanks in advance.