Sunday, January 22, 2017

Azure SQL Database In-Memory Performance

Improving Azure SQL Database Performance using In-Memory Technologies  @ InfoQ
9 times improvement of CPU, 3 times on IO with using in-memory option!



Azure SQL Database In-Memory technologies | Microsoft Docs

Release IoT Smart Grid sample v1.0 · Microsoft/sql-server-samples @ GitHub
Good example how to efficiently add data to database (batch, native compiled stored procedures)

SQL 2016 – It Just Runs Faster Announcement – CSS SQL Server Engineers
"DBCC scales 7x better
Various spatial patterns execute 100s of times faster with specific paths up to 2000x faster"

No comments: