I made everything I can in some procedures and queries to tune some processes. So I'm using tuning advisor to see if I missed something, and to my surprise, there's a lot of statistics to be created ( Create statistics...).

But my database is set to auto create and update statistics. why is tunning advisor creating the? why sql server is not creating them during the execution of these queries/procedures?

  • Are the stats it recommends multi column? Auto create won't do those for you. Also most people don't recommend using DTA anymore - so take the results with a grain of salt. – LowlyDBA - John M Jun 7 '18 at 13:51
  • Yes they're multi columns. Oh I know I don't use it frequently. Sometimes I use them just to be sure that I made almost everything possible. it's a really big query and procedures. I'm happy to see only statistics to be created and not indexes and etc ( tha tI made manually ). – Racer SQL Jun 7 '18 at 13:58

Auto Create Statistics will not create multi-column statistics, only single-column. Indexes will create multi-column based on the index automatically, though.

So DTA is simply recommending statistics that don't exist as indexes already.

Most people don't recommend DTA anymore. I don't think it has been maintained for a few years now. Lots of other tools like sp_blitz will recommend indexes a lot more intelligently.

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.