SQL Server가 업그레이드 할수록 내부적으로 진단할 수 있는 시스템 저장프로시져나 DMV를 제공하는데, SQL2012에서는 진단분석을 할 수 있는 시스템 저장프로시져를 제공합니다. 완전 좋은 기능이죠. 기존에는 DMV나 쿼리로 돌렸으나 내부적으로 제공을 하니 얼마나 좋은 기능입니까?
원본글
MSDN
http://msdn.microsoft.com/en-us/library/ff878233(v=sql.110).aspx
Use master GO EXEC sp_server_diagnostics GO
특정시간 동안 반복적으로 진단 분석하고 싶다면, @repeat_interval값을 0보다 큰값으로 지정하면 반복적으로 진단 정보를 반환합니다.
• System: - It collects information with respect to CPU Usage, Page Faults, Non Yielding Tasks, Latches, Access Violations, Dumps and Spinlock Activity.
• Resource: - It collects data such as Physical and Virtual Memory, Page Faults, Cache, Buffer Pools and other relevant memory related objects.
• Query Processing: - It collects data with respect to Query Processing such as Wait Types, Tasks, Worker Threads, CPU Intensive Requests and Blocking tasks etc.
• IO Subsystems: - It collects data with respect to IO such as IO Latch Time outs, Interval Long IO’s, Longest Pending Requests etc.
• Resource: - It collects data such as Physical and Virtual Memory, Page Faults, Cache, Buffer Pools and other relevant memory related objects.
• Query Processing: - It collects data with respect to Query Processing such as Wait Types, Tasks, Worker Threads, CPU Intensive Requests and Blocking tasks etc.
• IO Subsystems: - It collects data with respect to IO such as IO Latch Time outs, Interval Long IO’s, Longest Pending Requests etc.
• Events: -It collects data such as ring buffer exceptions, ring buffer events about memory broker, buffer pool, spinlocks, security, out of memory, scheduler monitor etc.
'SQL Server 2012' 카테고리의 다른 글
| SQL2012 시작 매개변수 지정 (0) | 2012.05.04 |
|---|---|
| SQL 2012 New Feature - Throw (0) | 2012.04.26 |
| alt+f1으로 스키마 있는 객체 정보 보기 오류 해결되었군요. (0) | 2012.04.04 |
| 결과창 보기 단축키 다시 사용하기~~ CTRL+R (2) | 2012.03.29 |
| SQL SERVER 2012 EDITIONS (2) | 2012.03.23 |