Oh, and since everyone and their brother will shortly be correcting me, saying that they're uncommitted isn't strictly speaking true. They were committed, but are not yet transmitted, hence they're...

Has the Availability group processed the changes between the databases (Primary to secondary) when you do the backup? It's going to retain changes as uncommitted until they go through the...

Some of the magic phrases you want to use when talking to the business about something like this (and it is absolutely a business question, not a technical one) are...

You've pretty much described standard behavior for PLE. It's one of the reasons why it's not a great measure for performance. I'd focus on other counters, especially wait statistics and...

Without seeing the wait statistics on the server, blocked process reports, etc., it's hard to say for certain why one is behaving differently than the other. It's pretty likely that...

Don't do it.

Upgrading to SQL Server 2014 means making the leap to the new cardinality estimation engine (a very good thing, most of the time). If you hit...

What you've posted is not a normal result of a standard upgrade. Something is seriously hosed on the system. It could be the SQL Server install itself. It could be...

is there a chance that you have row-level security in place? Then the process that is running the automation has different permissions from your login, hence different results? Just trying...

Are there blocked processes on the machine? You may be waiting on something else entirely. Also, how long was it running before you rolled it back? I've seen the rollback...