-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

Community
  • 1
SuperCoolMoss
  • 1,262
  • 11
  • 20

1 Answers1

0

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

Mark S. Rasmussen
  • 2,138
  • 2
  • 21
  • 31