I've only seen that error come up in the event of timeouts, or, when we had an app that was using an older version of OLEDB to connect to the...

Possibly, but SQL Server isn't going to flush the log in a clockwork, every four minutes, fashion. So I can see how external I/O issues can lead to the log...

You have to create an Azure Active Directory service in your Azure account and then federate that with your local Active Directory. AD in Azure SQL DB is in preview...

This is a two year old thread.

You don't have to set the database to...

Do you mean, capture the information? In SQL Server 2008 you can use trace events. In 2012 or greater you use extended events.

I agree with the other answers, so this is just piling on.

Fundamentally, deadlocks are a performance issue. Yeah, if the code is written in such a way that locks occur...

HUZZAH!

Well done.

I have an example on the blog here [/url]that pulls out Missing Index information.

Again, no. There's not enough information to make intelligent suggestions. You've listed an OS and version, SQL Server version, and the fact that you're running on a VM, but not...

For it to be that precise, something is running a process I'd guess. Do you have monitoring in place to capture query executions? If not, try trace (since you're still...

This

Excellent. Glad things worked out.

TomThomson (3/30/2016)

---

Grant Fritchey (3/30/2016)

---

TomThomson (3/30/2016)

---

Can someone who knows how Microsoft has chosen to implement snapshot Isolation take a lppk here? I've answered as best I can, but my answers...

First, I'd determine if there were stored procedures that could, conceivably, be calling that table. If there are any, it complicates this slightly.

The events you want are sql_batch_complete and rpc_complete...

I've been doing it for years. I backed up locally (because it's faster) and the used powershell to copy the files out to Azure blob storage. Done.

You can get fancy,...