Viewing 3 posts - 1 through 3 (of 3 total)
Thanks for the information. i will ignore these alerts.
April 14, 2014 at 5:50 pm
#1705954
No, both options are not enabled. just now i checked in server setting in advanced options both values is set mention below's.
1) Locks value is 0.
2) Optimize for Ad hoc...
April 14, 2014 at 3:55 pm
#1705938
Yes, all counter are good and showing good result. but sql server did not hit any memory related error's.
i have some input's in mind.
1) i have to apply SP2...
April 14, 2014 at 3:33 pm
#1705933