And for reference, here's the documentation on synonyms.

Ah, so you're not after locks as such, you're looking for blocking and what's causing the blocking?

If so, here is a great article on exactly how to do that.

One thing that few consider is that it might be "recompiles".  We had a query that was taking "only" (way too long in my eyes) 100ms to execute.  The...

First, you'll need to detail exactly what it is you're hoping to see, which events you're capturing and how what you want for filtering.

Second, just so you know, Profiler has...

You'll see tons of variation on the duration even if every other thing about the query is identical, the rows returned, the parameter values used, everything exactly the same. Why?...

The restore operation using WITH MOVE will allow you to rename the database and create new data files. However, the only thing that will change the code is changing the...

In addition to what Jeff says, be carefule when you say things like "similar execution plans". Similar is not the same as identical. Small differences in an execution plan can...

The duration only includes the time that the query ran on the server. It doesn't include any transfer times or waits at the start of execution.

Since the perfmon counters are part of the OS, I'd lean heavily towards capturing them from the OS. It's one less layer of processing necessary. The values will be the...

A failover would only fix an overloaded server by forcing people off of it. In short, that's no fix at all. You need to monitor the server and the resources...

2008R2? Ugh. Well, that limits your choices for monitoring down to one, Trace Events. These things do not filter well. However, you can set up a server side trace to...

This seems like one of the times where triggers are the right mechanism.  There's no complex logic in the trigger, there's nothing complicated happening to the table, updates/delete etc.......

Take a look at the Azure measurement DTU. This is how Microsoft was primarily charging, per database, for Azure. Now, the DTU is largely a secondary measure and they're primarily...

I haven't set up something like this, so let's get that out of the way up front.

First thing that comes to mind is simple INSERT triggers. However, generally, I don't...

That one is simple. Not enough memory in the system for the query in question. That means also, not enough disk space to swap stuff out. Sounds like the data...