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.
