the instance I'm working on is entirely for SharePoint, the database I'm reviewing though is part of the FAST Search for SharePoint application in case that...
thanks for the advice, I've been trying to get our customer to invest in the SQL Monitor tool instead of me having to constantly review every single thing they have...
I also want to add they all seem to point to the "CommitTransactions" sp within that db i was analysing. the DB itself is part of the MS FAST search...