title: How to store many years worth of 100 x 25 Hz time-series - Sql Server or timeseries database
body: <p>I am trying to identify possible methods for storing 100 channels of 25 Hz floating point data. This will result in <strong>78,840,000,000 data-points per year</strong>. </p>
  
  <p>Ideally all this data would be efficiently available for Web-sites and tools such as Sql Server reporting services. We are aware that relational databases are poor at handling time-series of this scale but have yet to identify a convincing time-series specific database.</p>
  
  <p>Key issues are compression for efficient storage yet also offering easy and efficient queries, reporting and data-mining.</p>
  
  <ul>
  <li><p>How would you handle this data?</p></li>
  <li><p>Are there features or table designs in Sql Server that could handle such a quantity of time-series data?</p></li>
  <li><p>If not, are there any 3rd party extensions for Sql server to efficiently handle mammoth time-series?</p></li>
  <li><p>If not, are there time-series databases that specialise in handling such data yet provide natural access through Sql, .Net, and Sql Reporting services?</p></li>
  </ul>
  
  <p>thanks!</p>