Goal of the Seminar: To provide the database developers and administrators with knowledge on how to monitor and tune performance of Microsoft SQL Server 2008 and SQL Server 2005. The seminar addresses CPU, Memory, Disk, Query and Lock monitoring and tuning techniques. Agenda: - 9:00-10:15 Monitoring and Tuning CPU, memory & Disk utilization to reduce Total Cost of Ownership (TCO) Part I - break - 10:30-11:45 Monitoring and Tuning CPU, memory & Disk utilization to reduce Total Cost of Ownership (TCO) Part II - break - 12:00-13:15 Monitoring and Tuning Query Execution and Locking Part I - Lunch - 14:15-15:30 Monitoring and Tuning Query Execution and Locking Part II - 15:30-16:00 Q&A Content:  Monitoring and Tuning CPU, memory & Disk utilization to reduce Total Cost of Ownership (TCO): - Identifying internal and external CPU Pressure. Using Resource Governor to manage scheduling priority. - Best practice guidelines on Partitioned Tables & File Groups, Data Compression and Snapshot Database. - Utilizing the available memory with Resource Governor. Monitoring and Tuning Query Execution and Locking: - Memory grants for sort and hash joins. - Tuning parallel query execution performance. - Understanding  prefetch in query plans. - Hints to avoid some deadlocks. Target Group Developers, Database Administrators and Database Architects. This seminar is equally designed for application developers and database administrators.