Probably because the new server has an index maintenance job that does ALTER INDEX REORGANIZE, whereas the old server didn't. REORGANIZE needs page locks to be enabled

Why don't you download a CTP now and play with it?

Cache hit ratios are useless counters. A server has to be under sever, long-term memory pressure before buffer cache hit ratio will dip.

Look for queries that run around those times...

Yup, this exactly. Since you shouldn't be logging into...

I already did.... See the other thread you posted on.

Please in future post new questions in a new thread.

CheckDB doesn't check the log, so it wouldn't pick this up.

When you have some downtime:

Switch DB to simple recovery model.

Checkpoint

Shrink log to 0

Regrow log to full...

To get a benefit from an SSD, you need to identify what parts of the workload are IO-bound, what files are under IO pressure and move those files. As usual,...

Full text indexing isn't something that you just create and suddenly everything magically works better. You need to do some design work, planning, code changes, etc.

Grant said you may need...

Keep in mind that it's an estimate.

https://msdn.microsoft.com/en-za/library/ms188300.aspx

What do you mean? Are you trying to include a computed column in a new table definition? Something else?

Yup, they can start as row or page, but if they start as row locks (KEY/RID), they will either stay as row locks or escalate to table/partition. Row locks can...

No they don't.

Escalation is straight to table, no matter whether the locks start as row or page. The...

GilaMonster (11/16/2015)

---

Also, you need to determine why the log is full. Taking a log backup will only help if the reason for the full log is that the DB needs...

No, it is not.

Escalation isn't guaranteed to succeed....