Microsoft Certified IT Professional/Exam 70-444/Optimizing the Performance of Database Servers and Databases

From Wikibooks, open books for an open world
< Microsoft Certified IT Professional‎ | Exam 70-444
Jump to: navigation, search

Optimizing the Performance of Database Servers and Databases

  • Troubleshoot physical server performance.
  • Troubleshoot instance performance.
  • Troubleshoot database performance.
  • Troubleshoot and maintain query performance.
    • Identify poorly performing queries.
    • Analyze a query plan to detect inefficiencies in query logic.
    • Maintain and optimize indexes.
    • Enforce appropriate stored procedure logging and output.
    • Troubleshoot concurrency issues