>There are other methods that don't require that.
>
>
>>I know DBAs who run jobs that read the SQL management views (and other system tables) to view open shared locks/write locks, especially those with a long duration. Bottom line, there's no excuse for not being able to head that off long before it becomes the kind of scenario you're describing.
In the abstract I don't disagree with you. But give the average business has anywhere from a small boatload to a truckload of legacy applications using older/non-optimized approaches, it's a reality