Configuring the Instance

  • Peter A Carter


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 an instance, both from Windows Server Core and through the GUI.


Capacity Planning Port Number Database Engine Snapshot Isolation Dirty Page 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Supplementary material (4 kb)
Chapter (zip 4 kb)

Copyright information

© Peter A Carter 2015

Authors and Affiliations

  • Peter A Carter
    • 1
  1. 1.BotleyUK

Personalised recommendations