This is an old post, which I came across when looking to find which job was running. I ended up creating the following script:

http://www.rbvandenberg.com/t-sql/running-processes-including-job-step-name/

I found the cause, so I thought I'd let you know. Between the small diffs and the larger diffs was a failed full backup (due to the backup share being...

I ran the code from Jacob. This is the result for last nights backup:

backup_start_datebackup_MBfile_type

2016-10-17 21:40:38.0001723566.125000D

2016-10-17 21:40:38.0001.609375L

That is what I would expect, since the log file is practically empty, and all...

Hello Kevin,

"No" to all three.

Greetings,

Robert

@jeff: yes, the TR and CDC were in place several weeks before we've been having this problem.

@kevin:

1) What is the exact script you used to identify...

You can also look at the preferred owner list list of the cluster resource group. You can modify the order of this list.

Though that list is a great starting point, I'd suggest you only add counters you actually understand. Imho, there is no use collecting data if you don't know what value...

For formatting, instead of buying a tool, you can also use the following web site: http://www.dpriver.com/pp/sqlformat.htm

I only learned about this function after I spent numerous frustrating hours casting, concatenating, adding quotes, troubleshooting & starting over. Oh well, you live and learn...

Is this what your looking for?

SELECTdbo.agent_datetime(run_date, run_time)

FROMsysjobhistory;

Did you check the waitresource? That should tell you exactly which table a process is waiting for.

It's only a problem if the end result is that the application is too slow for your users. But if these are average values, they are definitely not good. Especially...

Hello JB,

This is an interesting question! I can't give you an answer on this one. Personally, I'd be more concerned about preventing failure than improving the failover time, and I...

If configured correctly, replication will resume after a SQL Server restart, and a failover can be seen as a SQL Server restart. So, if you replicate from instance 1 to...

A CU is a cumulative update. This means that you only have to install the latest Cu to get all the updates contained in earlier CUs. But do you really...