We have an Enterprise Content Mgmt app connected to SQL 2008 R2. Lately we've encountered locked tables. Is it possible to run historical reports on previous locks, or can this only be obtained at the time the table is locked?
I'm aware of sp_who2 but as far as I know that's only helpful at the time of the lock. We're trying to gather information on performance issues from last week.
Thanks in advance.