If you mean who will set up the service account and give it the right permissions, that would be your Active Directory/Windows Server/Infra/sysadmins depending on what you call them.

Steve Jones - SSC Editor (2/9/2016)

I'd certainly continue to brush up on, and improve, my skills on SQL 2005 if I were there. Lots of T-SQL to get better at...

Can I ask why?

Are they UTC?

I guess you've already seen this, but just in case not: https://support.microsoft.com/en-us/kb/217395

Have you ticked the box in the log-shipping restore screen that says Disconnect users in the database when restoring backups?

If you miss that, you sometimes get this problem.

Hi. I've looked at that, and you're right, I'm on SQL 2014, but thanks. I haven't hada chance to make any progress with this yet because I'm working on it...

It will fail. In-flight transactions don't fail over. After crash-recovery, the database will roll back any uncommitted transactions.

Perfmon counters: https://www.brentozar.com/archive/2006/12/dba-101-using-perfmon-for-sql-performance-tuning/

Thanks, both. I'll have a look and get back to you.

Why did you try to kill it if you don't know what it's doing?

try dbcc inputbuffer(74) to see what it's up to.

Hi, yes it does, it has view server state.

Thanks for the reply.

I'm sorry, it's a rubbish position to be in. I do think that it's important to get out and not be dragged down with the rest.

I've asked and they won't. It's like the early 90s round here. I've taken to watching Brent Ozar's training videos on my own phone. Even Microsoft Virtual Academy is blocked!

I'm...

We're not allowed to install anything on our PCs (yeah), but it's a sound idea. I'm doing my best to stay motivated, but when nobody else cares it's quite difficult...