locked
Storing time-series data in SQL server 2005 RRS feed

  • Question

  • Hi all,

    I'm wondering what is the best way to store time-series data in an SQL database?? I've done a bit of investigating on the rrdtool (round robin database tool) that is used in a lot of nix based solutions for monitoring network equipment. I have a need to collect performance data from servers and routers and then produces some nice graphs from that data. I'm just not sure who i should store that data without the database growing to some huge size.

     

    Any suggestions?

    Tuesday, May 1, 2007 3:04 PM

Answers

  • The solution that I have employed works like this:

     

    ServerA: Inserts data from various SCADA devices, simple tables, no indexes, a column for archive flag. Regular scheduled process (10 minutes) creates aggregrations and inserts those aggregrations into Reporting ServerB, setting archive flag on. ServerA has throughput of 250M rows/day. Regularly scheduled process (daily) deletes rows with archive flag on.

     

    ServerB Creates frequently refreshing reports.

     

    Tuesday, May 1, 2007 7:07 PM