Chapter 4: Managing and Troubleshooting the Database Engine

Overview

With the server now installed or upgraded, the first thing you need to do is configure it for your environment. In this chapter, we discuss how to configure your SQL Server instance. After configuring the instance, we show you how to manage the instance with Management Studio and a number of stored procedures or DMVs. The chapter also covers how to monitor connections on your SQL Server and how to troubleshoot problems.

This chapter assumes you already know the basics of Management Studio navigation and focuses on what you'll need to know as a DBA. Many other chapters in this book spend much of their time driving into certain areas of Management Studio, and those points have been left out of this chapter (backing up your database, for example, is covered in Chapter 18).