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 ...