Identify Source of Schema Lock

Instead of the generic "Schema Lock" message in ArcGIS, how about alerting the user as to which of the possilbe hundreds of MXD, Web, or Mobile services are actually causing the lock, so that everything does not have to be shut down to remove the lock?

Extremely painful if you don't know who has the lock. Shutting down the instance is a workaround (albeit, the best we have to guarantee an update!).

If you have access to the RDBMS (and some people don't, so a tool WOULD be better), here's a sql statement that will show what machine has the lock (useful for direct connect, really not useful for those utilizing an ArcSDE service or virtualized PCs):

mping wrote, "In version 10.1 there's a new schema lock manger. You'll be able to see a list of all schema locks and who the users are." While this is true, all (or multiple) ArcGIS Server services will have the same name, and that doesn't help. If I only want to stop the services holding the lock I need more granular identification.

Please also improve this situation in Arcpy. I wish would also report a schema lock but instead it reports it cannot create the output feature class or table. Even with overwriteoutput = true there are times when a single user environment creates schema locks and arcpy does not report the correct error.Instead we start chasing down overwriteoutput options when it is not the real issue or cause of the error.

I have so many services that it is very difficult to pin point what service is creating a lock. A tool that shows what service is causing the lock instead of the user would be extremely beneficial and a huge time saver