![]() From a SQLOS scheduling engine that minimizes OS context switches to read-ahead scanning to automatic scaling as you add NUMA and CPUs. Maybe you caught my presentation at Microsoft Ignite where I demonstrated 1 million transactions per minute on my laptop using the popular tool HammerDB¹ by simply installing SQL Server out of the box with no configuration changes (with the HammerDB client and SQL Server on the same machine!)Ĭonsider for a minute all the built-in capabilities that power the speed of SQL Server. Based on the incredible work of SQL Server 2016 (See the blog series It Just Runs Faster), SQL Server 2017 is fast: built-in, simple, and online. SQL Server 2017 sets the standard when it comes to speed and performance. It must be fast and perform to the needs of all types of workloads accessing data. It makes me think of one of the top reasons why someone chooses a database engine. That is a quote from the character Maverick, played by Tom Cruise, in one of my favorite movies, Top Gun. This post was authored by Bob Ward, Principal Architect, Database Systems Group
0 Comments
Leave a Reply. |