Skip to Main Content
SQL Server on Azure Virtual Machines
book

SQL Server on Azure Virtual Machines

by Joey D'Antoni, Louis Davidson, Allan Hirt, John Martin, Anthony Nocentino, Tim Radney, Randolph West
June 2020
Intermediate to advanced content levelIntermediate to advanced
200 pages
4h 4m
English
Packt Publishing
Content preview from SQL Server on Azure Virtual Machines

Appendix A

SQL Server Configuration with OLTP

In online transaction processing (OLTP) workloads, much of the workload is made up of thousands of low-cost queries. When a query comes into SQL Server, the query optimizer creates an execution plan for that query. The execution plan determines how SQL Server will gather the data, such as which tables and indexes to use. It also assigns an overall cost to each query regarding how much effort it will take to complete that query. That query cost is known as the estimated subtree cost. SQL Server has a method by which it determines which queries it will process in parallel and those that it won't. It determines this by the cost threshold for parallelism (CTP) value.

By default, the initial value ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Pro SQL Server on Microsoft Azure

Pro SQL Server on Microsoft Azure

Pranab Mazumdar, Sourabh Agarwal, Amit Banerjee

Publisher Resources

ISBN: 9781800204591