Actually, as I think about it, you should be able to capture the process ID of the backup process from sys.dm_exec_sessions and sys.dm_exec_requests.

select s.session_id, s.program_name, s.host_process_id, s.login_name, s.nt_user_name

from sys.dm_exec_sessions s...

Sounds like you have an agent installed for the backups, if the servername comes back as localhost. Poke on through the services on the box, and see if anything...

Instead of a temp table, you could try a CTE as a replacement. Views don't like temp tables very much. Performance wise, it may evaluate to the same...

I kind of doubt that this is related to an OS patch. Have there been any recent code migrations? Check in sys.procedures to see if anything has a...

The number of connections does not look troublesome to me. I have had SQL 2005 server running with 200 - 300 connections with little to no problems (we have...

First questions would be can you use sp_send_mail outside of the procedure? if not, then it could be you have a bad mail server dns name configured. Then...

I would go with the Backup/restore route as well. This has the benefit that nothing that happens in your test environment can have an effect on your production environment....

That is the maddening thing about Kerberos problems. No change you make takes effect immediately, due to the caching that happens all over the place. Whenever you make...

Instead of a dynamic port, you should probably set a static port. I usually start at 1435, and work my way up from there, but you can just as...

Sorry. Double post issue.

Well, I have been using DNS aliases for a while. It has helped me through a number of hardware upgrades. I highly recommend it.

To get through your NTLM...

To see if you really have table scans on those tables, you can break out Profiler, and see if you can get the number of table scans that happen on...

I have not tried FileTables, as yet. I just googled for it, and the technet article says that the technology is built on FileStream. I do know that...

A record of what has been updated is pushed to the log., not the actual pages.

Due to the importance of the log data (for recovery), the log writes are synchronous,...

The estimated cost of a query is not a guarantee to how the query will actually perform (in fact,t he cost value has an er....interesting origin...). Run statistics IO,...