up vote 0 down vote favorite
share [g+] share [fb]

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.

alt text

ADDED PICTURE AND BOUNTY

link|improve this question
80% accept rate
So is that a screenshot of an actual TPS Report? ;-) – Graeme Donaldson Nov 23 '09 at 11:58
Well, TPS from PERFMON when the system isn't in use (Sunday). – SuperCoolMoss Nov 23 '09 at 18:11
feedback

1 Answer

up vote 0 down vote

When you ran the profiler, did you exclude all filters so all events would show?

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.