O'Reilly logo

Professional Microsoft® SQL Server® 2008 Administration by Steven Wort, Ross LoForte, Wayne Snyder, Ketan Patel, Brian Knight

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 4. Managing and Troubleshooting the Database Engine

With the server now installed or upgraded, the next thing you need to do is configure it for your environment. In this chapter, you will learn how to configure your SQL Server instance. After configuring the instance, you will learn how to manage the instance with Management Studio and a number of stored procedures or dynamic management views (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 need to know as a database administrator (DBA). Many other chapters in this book cover various aspects of Management Studio, so those points are not duplicated here (backing up your database, for example, is covered in Chapter 18).

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required