It sounds to me like you've probably got half the problem solved, which is that starting a SQL Agent job is generally asynchronous (i.e. you call sp_start_job, which immediately returns)....

So if I understand, the process that is running slow is the mass delete of the rows, but regular queries do OK? If that's the case, my advice in general...

In that case, I would highly recommend SQL Sentry Plan Explorer. You can use it to measure various metrics around execution of a procedure as well as capturing execution plans....

In general it's hard to answer your question without knowing more, such as what the selectivity of the various columns is. I would start with this: what is it that...

Hi there, not sure what you mean by baselines. Do you mean performance wise, in terms of CPU, logical IO, etc?

I believe you can use the @@SERVICENAME global variable to find the instance name, though you'd have to account for the fact it returns MSSQLSERVER for the default instance.

If I understand correctly, you might be able to use the System.Data.OleDBConnectionStringBuilder class to construct the connection string. There's equivalent classes for SQL Native Client as well in case that...

Hi DBANewbie,

Are all the cluster disks and associated virtual controllers setup according to these guidelines from VMWare? I've seen clusters in VMWare go whacky if everything isn't configured absolutely the...

Hey Grasshopper / TriggerMan, thanks for the kind words. I actually did write a companion article[/url] to this one, originally published a few months after.

Drew Copenhaver (9/24/2013)

---

I don't often comment, but I absolutely loved this. I wish I'd had it a year ago. I mostly just spend my time lurking in the shadows of...

Thanks Andy! Indeed, that is already in the works.

Hey everyone! First off, let me say how awesome it is to see so many great responses to my article. This is the first time I've written for SQLServerCentral, and...

Meaning does the local login I'm attempting to map exist on the remote server?  Nope.  That's why I'm trying to map it to a different login.  See, I want this...