Chapter 3. Manage and monitor SQL Server instances
This chapter deals with a database administrator’s core responsibilities, covering what you do every day, and managing and monitoring SQL Server instances you are responsible for. Unlike the other chapters in this book, this chapter is more operational than design and implementation focused. So, for the exam on this topic you should expect more questions on what tools to use, what objects to query, and what commands to run. You should also be prepared for what approaches and techniques to use to solve a specific issue or problem.
The chapter uses a “funnel approach,” which is a process you can use to narrow down the cause of performance problems. Skill 3.1 starts at a broader scope where you ...
Get Exam Ref 70-764 Administering a SQL Database Infrastructure now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.