This may help

http://www.mssqltips.com/tip.asp?tip=1564

Some info...

http://legeronline.blogspot.com/2009/03/evils-of-slow-paramaterized-query-plans.html

Mirroring is database based not server based so they are all independant of each other. This means that you can have some databases fail over and others not fail over....

You want to export using a SELECT with the 'FOR XML' clause

I assume you have checked that you have correct indexes and they aren't really fragmented etc

You could use database triggers to capture the events to a table. You can capture DML events and log those with the time and login with time but I don't...