It's a wait class. It tells you where the instance is spending its time waiting.

See this post by Paul Randal for more information: http://www.sqlskills.com/blogs/paul/wait-statistics-or-please-tell-me-where-it-hurts/

There's a tool called "Upgrade Advisor" that does exactly this.

See here for more information http://msdn.microsoft.com/en-us/library/ms144256.aspx

However, I don't recommend switching to 2005. While you're at it, use a newer SQL Server...

I'm afraid it can't work.

Actually, it doesn't make sense, if you are using your AG replica for HA purposes.

If the AG failed over to the secondary (2014), it would never...

As far as I know, there's a good amount of questions to choose from.

I do not think the system is smart enough to exclude the questions you had last time.

What you're describing is the behaviour of an application, not of a database.

Databases don't work like that.

I suggest that you search for a programming resource.

Some more things to look at:

1) Since DBCC FREEPROCCACHE fixes the issue and you don't see slow performing queries, it might be that your cache is bloated by single-use plans...

See CAST AND CONVERT in BOL

Bad parameter sniffing probably.

Are your stats updated regularly?

I have no idea.

You're asking how to remove a virus that has something to with Google, in an Oracle forum, on a SQL Server site.

How are you expecting to get...

When you add a new table to a publication, the snapshot runs only for the newly added article (if your snapshot hasn't become obsolete, obviously).

Because it's modifying the database, which is not allowed since it is read-only.

AG secondaries support copy_only full backups.

See Active Secondaries: Backup on Secondary Replicas (AlwaysOn Availability Groups) for reference.

The reason is that full backups reset the diff bitmap on the database, which...

Express can be used for commercial software. For reference, search the microsoft site.

Don't. That would be looking for trouble.

Install from scratch, you won't regret it.

Nice catch!