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

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