Oracle SQL Forum
May I know that how to identify and resolve memory leak problem in sql server?
Kindly share your valuable views here, so i can proceed further.
Thanks in advance.
Memory leak can be identified by running select * from sys.dm_os_memory_clerks and select *from sys.dm_os_memory_objects look for object or clerk increasing there memory consumption when you run queries every couple of minute. Actually it's bit more deep I gave you tentative way how you can gauge it
Sign up for STechies