7439eb0b   
   From: esquel@sommarskog.se   
      
   ignorant (saurabh.writes@gmail.com) writes:   
   > Thanks Erland for that insight. I have only two filegroups - primary   
   > with one file and secondary with 29 others. Each file is on its own   
   > SAN disk mountpoint. About half of them are twice as busy as the other   
   > half. My conjecture is that the busiest tables are on those 15 files   
      
   That may be a forgone conclusion. The tables could just as well be   
   spread over all 30 files. But the busy part of the tables could be   
   in those 15 files.   
      
   I don't what is in your tables, but in the system I work with, this   
   is likely to be true. We have transactional tables that holds transactions   
   several years back, but most of the queries are of course related to   
   recent data. Not talking about inserts.   
      
   Indeed, getting a perfect mix over all 29 SAN mountpoints is a real   
   challenge.   
      
      
   --   
   Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se   
      
   Links for SQL Server Books Online:   
   SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx   
   SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx   
   SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)