O'Reilly logo

Professional Microsoft SQL Server 2014 Administration by Brian Knight, Ross LoForte, Steven Wort, Bradley Ball, Adam Jorgensen

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 4Managing and Troubleshooting the Database Engine

WHAT'S IN THIS CHAPTER?

  • Configuring your instance using SQL Server Management Studio
  • Using a dedicated administrator connection to access an unresponsive server
  • Monitoring processes using Dynamic Management Objects (DMOs)

WROX.COM CODE DOWNLOADS FOR THIS CHAPTER

The wrox.com code downloads for this chapter are found at www.wrox.com/go/prosql2014admin on the Download Code tab. The code is in the Chapter 4 download and individually named according to the names throughout the chapter.

In this chapter, you learn how to configure and monitor your SQL Server instance. This is the key to a smooth-running database—proper configuration and active monitoring. In addition, you learn some troubleshooting methods that help you identify what is happening when the instance is not performing as expected. This chapter assumes you already know the basics of SQL Server 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 SQL Server Management Studio, so those points are not duplicated here (backing up your database, for example, is covered in Chapter 17, “Backup and Recovery”).

CONFIGURATION AND ADMINISTRATION TOOLS

After you install SQL Server or upgrade to SQL Server 2014, you will likely need to configure it for your needs. In SQL Server 2014, Microsoft maintained its policy to increase out-of-the-box security established with ...

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