1

Is there a method to count total transactions by type (read/write) by day/hour/peak?

Improve this question
1
  • You mean historically, or going forward? If historically, no, SQL Server doesn't track this information for you.
    – Aaron Bertrand
    Commented Jan 29, 2015 at 19:26

1 Answer 1

Reset to default
3

Use the performance counters Transactions/sec and Write Transactions/sec documented here:

https://msdn.microsoft.com/en-us/library/ms189883.aspx

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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