On Sunday, November 10, 2013 5:26:32 PM UTC-6, dbaon...@gmail.com wrote:   
   > how can DMV help for performance tuning ?   
      
   DMVs are really useful for analyzing performance related issues.   
      
   They help with below   
   Identify  Resource Consuming Queries   
   query stats   
   CPU consuming queries   
   Index Usage Statistics   
      
   You can refer below article for more information.   
   http://www.techsql.com/sql-performance-tuning-with-dmvs.htm   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)