대기 정보 분석을 위한 Best Reference 페이지들 입니다.
Performance_Tuning_Waits_Queues.doc
1. SQL Server Best Practices Article
- http://msdn.microsoft.com/en-us/library/cc966413.aspx
2. Performance Tuning With Wait Statistics
- http://blogs.msdn.com/joesack/archive/2009/04/22/presentation-deck-for-performance-tuning-with-wait-statistics.aspx
3. Wait statistics, or please tell me where it hurts
- http://www.sqlskills.com/BLOGS/PAUL/post/Wait-statistics-or-please-tell-me-where-it-hurts.aspx
4. The SQL Server Wait Type Repository ..
- http://blogs.msdn.com/b/passsql/archive/2009/11/03/the-sql-server-wait-type-repository.aspx
5. Great Resource on SQL Server Wait Types
- http://sqlserverperformance.wordpress.com/2009/12/21/great-resource-on-sql-server-wait-types
6. Tracking Session and Statement Level Waits
- http://sqlblog.com/blogs/jonathankehayias/archive/2010/12/30/an-xevent-a-day-30-of-31-tracking-session-and-statement-levelwaits.aspx
7. Wait Stats Introductory References
- http://blogs.msdn.com/b/jimmymay/archive/2009/04/26/wait-stats-introductory-references.aspx
8. Performance Blog
- http://sqldoctor.idera.com/tag/wait-stats/
'Brain Trainning > DataBase' 카테고리의 다른 글
[MSSQL] DB별 Buffer Memory 사용량 측정 (2) | 2012.04.26 |
---|---|
[MSSQL] 시스템 대기 상태 관련 글 [펌] (0) | 2012.04.05 |
[MSSQL] Database 파일 정보 조회 Script (0) | 2012.04.03 |
[MSSQL] 대기상태 확인 쿼리 (0) | 2012.03.27 |
[MSSQL] I/O 특성을 고려한 스토리지 운영 (0) | 2012.03.20 |