CirquedeSQLeil (3/2/2011)
Are we sure about that answer?http://msdn.microsoft.com/en-us/library/bb934013.aspx States:
" Disabling Resource Governor has the following results:
All existing workload group and resource pool settings are reset to their default values.
"
The default values for those counters is 0. I checked on several servers and all have Resource Governor disabled and all show 0's in those columns.
Hi,
the quote refers to settings, not statistics.
I can confirm that with my R2 Install, the statistics are not reset when disabling resource governor.
You can reset them with ALTER RESOURCE GOVERNOR RESET STATISTICS though.
Best Regards,
Chris Büttner