title: Azure Sql Database Log I/O Seems High
body: <p>I've been optimizing our Azure Sql Database and started getting really good performance.  The main concern now is the Logging that it does.  When running a insert/update load test, everything is low except the CPU which is peaking around 15% and the logging which is peaking around 25%.  Since the logging IO is hitting 25%, this causes the DTUs to be 25%.  I turned off Auditing in the settings for the database but that did nothing.  Is there a way to reduce the logging that is being done?  I'm not even sure where the logs are being saved.</p>
  
  <p>Any insight on this would help as I've googled and couldn't locate anything worth mentioning about the logging that is happening.</p>
  
  <p><em>Here is a screen shot of the metrics...</em></p>
  
  <p><img src="https://i.stack.imgur.com/66zvm.png" alt="Azure SQL Database Metrics"></p>
  
  <blockquote>
    <p><strong>Workflow Details:</strong></p>
  </blockquote>
  
  <p>I don't have byte sizes on me as I'm not in the office atm.  Every <code>Task</code> is a <code>SELECT</code> and either <code>INSERT</code> or <code>UPDATE</code>, a typical add or update flow using Entity Framework.  These tasks fire off and finish at a rate of 63 tasks per second to create those metrics.</p>