cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

8.4 Microsoft SQL Azure and MS SQL Highlights

Highlighted
Level 13

8.4 Microsoft SQL Azure and MS SQL Highlights

Why?

  • Reduce or eliminate hardware costs
  • Get database portability across on-premise and cloud compatible virtualization
  • High speed and minimum downtime
  • Optimize performance

Three deployment options:

  • Single: best for apps requiring resource guarantee at database level
  • Elastic pool: SAAS apps with multiple databases achieving better cost efficiency
  • Managed instance: best for modernization at scale

MS SQL Improvements:

  • Ingest millions of data items/day with imrpoved MS SQL
  • 150% improvement  ingestion throughput with MS SQL persistence provider
  • Optimized indexing to achieve better peformance for the same compute at the same price

ThingWorx with Microsoft database solution:

  • Azure SQL logical server (single instance and elastic pool) v12
  • Azure SQL managed server v12
  • MS SQL sever 2016
  • Azure PostgreSQL 9.6 and 10

Q: What is the rate as compared to PostgreSQL?
A: We are in process launching new sizing guide that will be out in a few weeks. MS SQL is around 15-22K writes per sec. Comparable to Postgres.