IoT Smart Grid code sample

Published Mar 23 2019 02:37 PM 267 Views
First published on MSDN on Jun 15, 2016
This code sample simulates an IoT Smart Grid scenario where multiple IoT power meters are constantly sending measurements to a SQL Server 2016 in-memory database. The sample is leveraging the following features: Memory Optimized Tables , Table valued Parameters (TVPs), Natively Compiled Stored Procedures , System-Versioned Temporal Tables (for building version history), Clustered Columnstore Index , Power BI (for data visualization). The combination of these features could be used to improve performance in High Data Input Rate / Shock Absorber scenarios, as well as to address scenarios where a memory optimized table exceeds available memory (also referred to as memory cliff).





The v1.0 release of the sample, including binaries and easy setup scripts, is available here:
IoT Smart Grid code sample v1.0 Release

The source code along with instructions on how to configure and run the sample can be found here:
IoT Smart Grid Source Code

Please give the sample a try, and let us know what you think!
%3CLINGO-SUB%20id%3D%22lingo-sub-384749%22%20slang%3D%22en-US%22%3EIoT%20Smart%20Grid%20code%20sample%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-384749%22%20slang%3D%22en-US%22%3E%0A%20%26lt%3Bmeta%20http-equiv%3D%22Content-Type%22%20content%3D%22text%2Fhtml%3B%20charset%3DUTF-8%22%20%2F%26gt%3B%3CSTRONG%3E%20First%20published%20on%20MSDN%20on%20Jun%2015%2C%202016%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3E%20This%20code%20sample%20simulates%20an%20IoT%20Smart%20Grid%20scenario%20where%20multiple%20IoT%20power%20meters%20are%20constantly%20sending%20measurements%20to%20a%20SQL%20Server%202016%20in-memory%20database.%20The%20sample%20is%20leveraging%20the%20following%20features%3A%20%3CA%20href%3D%22https%3A%2F%2Fmsdn.microsoft.com%2Fen-us%2Flibrary%2Fdn133165.aspx%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20Memory%20Optimized%20Tables%20%3C%2FA%3E%20%2C%20%3CA%20href%3D%22https%3A%2F%2Fmsdn.microsoft.com%2Fen-us%2Flibrary%2Fbb510489.aspx%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20Table%20valued%20Parameters%20%3C%2FA%3E%20(TVPs)%2C%20%3CA%20href%3D%22https%3A%2F%2Fmsdn.microsoft.com%2Fen-us%2Flibrary%2Fdn133184.aspx%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20Natively%20Compiled%20Stored%20Procedures%20%3C%2FA%3E%20%2C%20%3CA%20href%3D%22https%3A%2F%2Fmsdn.microsoft.com%2Fen-us%2Flibrary%2Fdn935015.aspx%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20System-Versioned%20Temporal%20Tables%20%3C%2FA%3E%20(for%20building%20version%20history)%2C%20%3CA%20href%3D%22https%3A%2F%2Fmsdn.microsoft.com%2Fen-us%2Flibrary%2Fdn817827.aspx%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20Clustered%20Columnstore%20Index%20%3C%2FA%3E%20%2C%20%3CA%20href%3D%22https%3A%2F%2Fpowerbi.microsoft.com%2Fen-us%2Fdesktop%2F%3Fgated%3D0%26amp%3Bnumber%3D1%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20Power%20BI%20%3C%2FA%3E%20(for%20data%20visualization).%20The%20combination%20of%20these%20features%20could%20be%20used%20to%20improve%20performance%20in%20High%20Data%20Input%20Rate%20%2F%20Shock%20Absorber%20scenarios%2C%20as%20well%20as%20to%20address%20scenarios%20where%20a%20memory%20optimized%20table%20exceeds%20available%20memory%20(also%20referred%20to%20as%20memory%20cliff).%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F98031iBB4D1058995A4D20%22%20%2F%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F98032i5499BEEBB6FC680F%22%20%2F%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20The%20v1.0%20release%20of%20the%20sample%2C%20including%20binaries%20and%20easy%20setup%20scripts%2C%20is%20available%20here%3A%20%3CBR%20%2F%3E%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2Fsql-server-samples%2Freleases%2Ftag%2Fiot-smart-grid-v1.0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20IoT%20Smart%20Grid%20code%20sample%20v1.0%20Release%20%3C%2FA%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20The%20source%20code%20along%20with%20instructions%20on%20how%20to%20configure%20and%20run%20the%20sample%20can%20be%20found%20here%3A%20%3CBR%20%2F%3E%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2Fsql-server-samples%2Ftree%2Fmaster%2Fsamples%2Fapplications%2Fiot-smart-grid%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20IoT%20Smart%20Grid%20Source%20Code%20%3C%2FA%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20Please%20give%20the%20sample%20a%20try%2C%20and%20let%20us%20know%20what%20you%20think!%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-384749%22%20slang%3D%22en-US%22%3EFirst%20published%20on%20MSDN%20on%20Jun%2015%2C%202016%20This%20code%20sample%20simulates%20an%20IoT%20Smart%20Grid%20scenario%20where%20multiple%20IoT%20power%20meters%20are%20constantly%20sending%20measurements%20to%20a%20SQL%20Server%202016%20in-memory%20database.%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-384749%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESQLServerStorageEngine%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Version history
Last update:
‎Mar 23 2019 02:37 PM
Updated by: