lmacdonald (12/5/2014)

---

Do you use LogicMonitor to monitor SQL Server?

Do you monitor lock timeouts and does it often go above the default threshold of 1? I am asking because we...

Luis Cazares (12/5/2014)

---

After analyzing your query and Eddie's, I keep wondering what are you trying to accomplish. This can certainly be a major problem with cartesian products. Could you post...

I'd suggest putting in a request for it. It might not be that hard to implement. I'll put in a request from my side too.

Oh heck, I thought I was on the Data Compare page. Sorry about that.

Yep, no report on the Data Compare command line. Again, sorry.

So script or script file won't work?...

something is seriously baked on that server.

It's pretty abnormal. I've been working with VMs in Azure for years. And, because I'm doing lots and lots of testing and development, not...

Perry Whittle (12/5/2014)

---

ian_massey (12/5/2014)

---

Thank you for the LSN explanation re the proprietary software - that makes sense to me.

But I don't have any access to the log file...

I've usually found single_user to problematic. That's why I prefer restricted_user. But then, you have to have had your apps set up correctly. If everyone is 'sa' or 'dbo' (or...

You should be able to set a switch that outputs as a report. Here's the documentation showing how that works. You would want /Report.

I didn't know we had a command...

I'm with Ed. It looks like they are doing log backups. So, they are right. If you were to introduce a different set of log backups, it could cause issues...

That sounds like they're saying that they are already backing up the log, but if the log is that large, that might not be true (likely isn't).

It's pretty much...

I'd put indexes on the table. The best choice, if you can only have a single index, would be a clustered index on the three columns in the WHERE clause.

The...

If you attempt to delete the file and it appears in any way to be locked, then it is in use even if you haven't identified by what yet. Don't...

Glad to hear you got the answer.

Everything I've done and heard suggests that 2014 is basically a more stable 2012 with many of the improvements of 2012 polished, including more stability in Availability Groups, better behavior...

curious_sqldba (12/4/2014)

---

My apologies, should have specified this. We already have a in-house alerting system, i just need the...