3 Billion Readings/day recorded on SQL Server - Helping make the planet Greener

  • Article

With the current trend of every untility company rolling out AMI (Advanced Metering Infrastructure), I felt, its worth sharing Itron's solution and SQL Server's Scalability and Performance achievements. Such stunning performance is achieved with Itron's Meter Data Management Solution powered by SQL Server. More info can be found at https://blogs.technet.com/b/sql_server_isv/archive/2011/04/27/itron-3-billion-readings-day-recorded-on-sql-server-helping-make-the-planet-greener.aspx 

The load going through SQL Server could be described several ways, including:

  • Importing 35,000 intervals per second and higher on an ongoing basis
    • Or greater than 3,024,000,000 readings/record inserts per day.
  • Depending on meter data rates, this would support
    • 9 million meters with hourly reporting
    • 4.5 million meters with half-hourly reporting '

For more information, see the solution sheet or the results report.