SQL Server 2008 CSS Microsoft Korea SQL Server

성능 튜닝 도구 SQL Server 2008 CSS Microsoft Korea

SQL Server 2008의 성능 튜닝 도구 Data Collector Management Data Warehouse Performance and Configuration Reports Activity Monitor Graphical Showplan SQL Profiler Dynamic Management Views Resource Governor (Enterprise Only) XEvents Database Engine Tuning Advisor

순서 � SQL Server 2008의 성능 튜닝 도구 � Activity Monitor • Management Data Warehouse

Demo � Activity Monitor

Demo � Data � MDW Collector ◦ System collection set ◦ Custom collection set

Q&A

Reference � � � � Performance Monitoring and Tuning How-to Topics http: //msdn. microsoft. com/en-us/library/ms 187830. aspx Performance (Database Engine) http: //msdn. microsoft. com/en-us/library/bb 510669. aspx Monitoring and Tuning for Performance http: //msdn. microsoft. com/en-us/library/ms 187830. aspx http: //blogs. msdn. com/joesack/ Top 10 SQL Server 2008 Features for the Database Administrator (DBA) http: //sqlcat. com/top 10 lists/archive/2009/01/30/top-10 -sql-server-2008 -features-for-the-databaseadministrator-dba. aspx Diagnosing Transaction Log Performance Issues and Limits of the Log Manager http: //sqlcat. com/technicalnotes/archive/2008/12/09/diagnosing-transaction-log-performance-issues-andlimits-of-the-log-manager. aspx Statistics Used by the Query Optimizer in Microsoft SQL Server 2008 http: //msdn. microsoft. com/en-us/library/dd 535534. aspx http: //msevents. microsoft. com/cui/Web. Cast. Event. Details. aspx? Event. ID=1032349947&Event. Category=4&culture =en-US&Country. Code=US