Viewing 2 posts - 1 through 3 (of 3 total)
Thanks again for the reply...
We don't have 3rd Party backup software as we are using Maintenance Plans for our backup. As with extended stored procedures also. Will...
January 20, 2013 at 11:20 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
MEMORYCLERK_SNI016
CACHESTORE_STACKFRAMES08
OBJECTSTORE_SNI_PACKET08
OBJECTSTORE_SNI_PACKET08
OBJECTSTORE_SNI_PACKET08
OBJECTSTORE_SNI_PACKET08
OBJECTSTORE_SNI_PACKET08
OBJECTSTORE_SNI_PACKET08
CACHESTORE_STACKFRAMES08
OBJECTSTORE_SNI_PACKET08
OBJECTSTORE_SNI_PACKET08
OBJECTSTORE_SNI_PACKET08
OBJECTSTORE_SNI_PACKET08
OBJECTSTORE_SNI_PACKET08
OBJECTSTORE_SNI_PACKET08
From the information gathered, how could I actually pinpoint which processes is consuming VAS. Which clerks actually...
January 20, 2013 at 7:55 pm
Viewing 2 posts - 1 through 3 (of 3 total)