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

< Microsoft Certified IT Professional | Exam 70-444

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

Retrieved from "https://en.wikibooks.org/w/index.php?title=Microsoft_Certified_IT_Professional/Exam_70-444/Optimizing_the_Performance_of_Database_Servers_and_Databases&oldid=3332839"