The article is good. The discussion has been even better.

Excellent article. A great example of why I come to SQLServerCentral.com . . . to learn from the best.

Overbilling and underbilling are indeed potential problems, but I'm worried about bigger stuff, like terrorists or another country (think the big C) hacking into the grid system and turning off...

Great article. It should be read by anyone who codes T-SQL.

SSIS has a transfer logins task

OK, just to be clear, the Service Acct for SQL Server on both servers is the SAME account, correct? I know it's in the same domain, but I wanted...

We run SSIS on an active/passive cluster and have no issues related to it being on a cluster.

What are these work arounds you mention? What issues do you think...

Virtualization almost eliminates the need for it and the advantages of it. Improving virtualization will make "scale out" on SQL Server a moot point faster than advances in...

I work in a multi db platform environment. We use both SQL Server and Oracle. I'm just a newbie when it comes to Oracle administration, and am mid-level...

Good stuff. Looking forward to part 2.

Great article, good discussion.

Many thanks to everyone for their comments.

Please see my follow up post "SP_GetApplock - Understanding what is being locked". I did provide the information to my internal customers who...

John, thanks for your feedback.

I have provided my analysis to the Performance Monitoring Team, and they have forwarded my comments to the vendor.

Thanks for the responses, George and Paul.

Paul, the query to sys.dm_tran_locks returns a resource_type of "APPLICATION" for the spids that are waiting. The actual sql stmt being executed by...

I'm sure you're correct. I ran the following query -

SELECT resource_type, request_session_id, resource_database_id, resource_associated_entity_id, resource_subtype, resource_description, request_status, request_owner_type, request_mode

FROM sys.dm_tran_locks

order by resource_type

All the database locks have a...