MS 2008 R1 Standard.
We have a large database that has a high number of users and access.
We are getting a number of deadlocks.
Installed is SQL Power Tools that monitors and captures alot of performance info.
The deadlocks it had been capturing are on large complex selects.
I know they say it has to be an update on there some where, but it shows none.
Some of the large selects have two or three alias for a table it is re-using another way in the join. The info in the dead lock points to the table not an index and the locks are all IS.
We are trying to get a handle on what is going on but it does not make a lot of sense.
Any suggestions or insight would be greatly appreciated.