High Performance SQL Server: Consistent Response for Mission-Critical Applications

© Benjamin Nevarez 2021

B. NevarezHigh Performance SQL Serverhttps://doi.org/10.1007/978-1-4842-6491-1_1

1. How SQL Server Works

Benjamin Nevarez¹  

(1)

Santa Clarita, CA, USA

 

SQL Server default configuration allows you to run noncritical applications with little knowledge or administrative effort. This is especially true for applications running the lower Stock Keeping Units (SKUs) of the product such as SQL Server Express edition. However, for most production applications, you need to follow a database implementation cycle consisting of four steps: design, configuring, monitoring, and troubleshooting. This is extremely important for mission-critical applications where areas such as performance, availability, or security are an essential requirement. ...