title: View the waiting/suspended queries between a time period in the past
body: <p>I am trying to optimize an SQL process using the dmv <code>([sys].[dm_os_wait_stats])</code>. </p>
  
  <p><em>Is there any way that we can see the waiting/suspended queries between a time period in the past?</em>. Like want to have records only from 3pm today.</p>
  
  <p>Currently I clean the instance every time before running the process using </p>
  
  <pre><code>DBCC SQLPERF ('sys.dm_os_wait_stats', CLEAR);
  GO
  </code></pre>