Could be quite a few things. My best guess is that you don't have a max memory set for the server and you are getting starved for RAM.

1) Upgrade all stats with full scan? I am pretty sure this is old information from prior upgrades, but still could be applicable for that level of jump.

2)...

1) There is no 3rd-party tool that I know of that will make index rebuilds go faster.

2) Ola.hallengren.com can and should be used for all maintenance tasks. You...

Use sp_whoisactive to see both blocking issues as well as work actually done by a spid. You can also run it in differential mode and see work deltas.

I honestly have no idea what you are asking for. But I do know that an easy way to help us help you is to provide a create table statement,...

The easiest way is with the following script. Note this just creates the login. It does not do anything with any settings concerning that login. It doesn't do 'sa' either...

A) in general, "secondary" SQL Server instances that are not used for ANYTHING other than a failure of the primary do not require licensing. 

B) Licensing is a VERY...

Anchelin, please don't post on 3 year old posts. If you have a similar question that hasn't been answered here please post a new thread. Thanks!

In addition to Jeff's comments about functions around columns in WHERE clause (DEVASTATINGLY BAD, BTW, and possibly not even needed here depending on the actual data - I have seen...

Sorry for the confusion, Yomet. I mentioned 20, which is the "issue" and limit that crops up in a similar situation related to an ENTERPRISE license. I had recently fixed...

A) I don't think I ever said anything about blocking being an issue. It wouldn't with this wait type.

B) Adam Machanic, the mastermind behind the awesome sp_whisactive, did...