You've never really put together the set of wait statistics that Gail asked for, let alone gathered them one day and then another day and compared between the two (using...

You...

Strong recommendation, if you're upgrading from 2012, don't go to 2014. Go straight to 2016. There are a lot of reasons for this, but I'll give you one big one....

Everyone,

Thanks for all the wonderful feedback. I appreciate the discussion.

I will add one point to the editorial. I'm not a fan of how Microsoft handles their...

Reinforcing what Gail said and adding one more wrinkle. The nice thing about the side-by-side install is that you can use log shipping to set up a  process that will...

There just isn't a single answer here that's going to satisfy all situations. I've maintained systems that had statistics maintenance running anywhere from weekly to daily to, for one table...

Absolutely directly.

Slower and fewer CPUs mean less processing power. Less memory means more disk I/O to process data. Slower and fewer disks means slower disk reads and writes....

You have to look at the T-SQL within the extended event. There isn't a tool out there that captures metrics by table. Any given query or batch can be hitting...