We have quite some issues going on for one of our SQL server 2014 SP3 after compatibility change to 120 from 100.

Yes i am aware of few hints to make use of legacy CE and have implemented as success. However i am trying to understand exaclty what changes with stats for table over 1 Billion rows and approx some 500 Gb size

For the database in question we have some 8-10 VLtables starting with 500 M rows gows all the way to 4 billion rows. Update stats had been a problem with higher sample rate so we just do default sample rate. like UPDATE STATS "IX_NAME"

I have couple of questions - does new CE prefers to have better stats like updating stats on higher sample rate?

If yes how better can i plan to update stats for very large tables so that they do not run for hours and just finish in time if we go with daily stats?

FYI- Auto update stats is on but for VLTB they hardly come into effect because of old algorithim


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy