When monitoring the Transactions/Sec using perfmon on one of my SQL2005 replicated databases - I'm seeing the TPS increase to 1000 and then immediately drop back down again - this happens every 5 seconds.
I'm not sure what's causing this - is this something to do with replication?
We also have asynchronous statistics set on this particular database.
I've tried profiling when the users are not connected - but nothing is writing to the database.
ADDED PICTURE AND BOUNTY