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

1. How SQL Server Works

Benjamin Nevarez1  
(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. ...

Get High Performance SQL Server: Consistent Response for Mission-Critical Applications now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.