Optimizing SQL Server 2005 Performance
This course is included in our On-demand training solution.
To identify ways of optimizing the performance of SQL Server 2005
Professionals pursuing a career as a Database Administrator
Candidates for the MCITP: Database Administrator certification should have taken and passed exam 70-431 to be certified as an MCTS: SQL Server 2005.
Optimizing SQL Server 2005 Performancerecognize how to optimize server performance using memory configuration options in a given scenario.recognize how to optimize server performance using I/O configuration options and Windows options in a given scenario.recognize how to troubleshoot database performance in a given scenario.troubleshoot the performance of SQL Server 2005 in a given scenario.troubleshoot and analyze query performance in a given scenario.optimize database indexes in a given scenario.recognize how to optimize stored procedures in a given scenario.identify considerations when managing concurrent data access in a given database scenario.identify and troubleshoot query performance issues in SQL Server 2005.