-1

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

Improve this question
2
  • So is that a screenshot of an actual TPS Report? ;-)
    – ThatGraemeGuy
    Nov 23, 2009 at 11:58
  • Well, TPS from PERFMON when the system isn't in use (Sunday).
    – SuperCoolMoss
    Nov 23, 2009 at 18:11

1 Answer 1

Reset to default
0

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

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .