SQLServerCentral » Latest topics
Query Store Performance Burden too high in my production environment
Hi All
We have recently upgraded all our production SQL servers to 2016 Sp1-CU2
On some of the load balances servers, we have enabled query store with the below settings
Data Flush Interval - 25 min
Statistics Collection Int
We have recently upgraded all our production SQL servers to 2016 Sp1-CU2
On some of the load balances servers, we have enabled query store with the below settings
Data Flush Interval - 25 min
Statistics Collection Int
No comments:
Post a Comment