title: How to figure the read/write ratio in Sql Server?
body: <p>How can I query the read/write ratio in Sql Server 2005?  Are there any caveats I should be aware of?</p>
  
  <p>Perhaps it can be found in a DMV query, a standard report, a custom report (i.e the Performance Dashboard), or examining a Sql Profiler trace. I'm not sure exactly.</p>
  
  <p><strong>Why do I care?</strong></p>
  
  <p>I'm taking time to improve the performance of my web app's data layer. It deals with millions of records and thousands of users.  </p>
  
  <p>One of the points I'm examining is database concurrency.  Sql Server uses pessimistic concurrency by default--good for a write-heavy app.  If my app is read-heavy, I might switch it to optimistic concurrency (isolation level: <code>read committed snapshot</code>) like <a href="http://www.codinghorror.com/blog/2008/08/deadlocked.html" rel="nofollow noreferrer">Jeff Atwood did with StackOverflow</a>.</p>