CHAPTER 4

image

Configuring the Instance

The installation and configuration of your SQL Server instance does not end when setup successfully completes. There are many other considerations that you should take into account, both inside the database engine and outside of it, using tools such as SQL Server Configuration Manager. In this chapter, we will discuss many of the most important instance-level configuration options, including SQL Server’s new buffer pool extension technology and important configuration choices for system databases. We will also look at how your instance can communicate through a firewall before finally demonstrating how to uninstall ...

Get Pro SQL Server Administration 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.