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  