SQL Profiler in SQL2000
-
2012년 6월 27일 수요일 오전 7:46
What are the purpose of the columns in SQL Profiler 2000 version.
I am bit confused with this columns - Reads, Writes and Duration
Which unit denoted for these measurements ?
모든 응답
-
2012년 6월 27일 수요일 오전 8:51중재자
Duration is in milliseconds. The logical reads is the number of pages (8k blocks) read from cache, whereas physical reads is the number of pages read from disk.
Here is a good thread on the topic with some links to further documentation:
Thanks,
Sam Lester (MSFT)This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you. This can be beneficial to other community members reading the thread.
- 답변으로 표시됨 Samuel Lester - MSFTMicrosoft Employee, Moderator 2012년 6월 27일 수요일 오전 8:51
- 답변으로 표시 취소됨 ssa2010 2012년 6월 27일 수요일 오전 10:01
- 답변으로 제안됨 Naomi NMicrosoft Community Contributor 2012년 6월 27일 수요일 오후 8:28
- 답변으로 표시됨 Samuel Lester - MSFTMicrosoft Employee, Moderator 2012년 7월 2일 월요일 오후 6:59
-
2012년 6월 27일 수요일 오후 7:51답변자
I am bit confused with this columns - Reads, Writes and Duration
Reads are logical page (8k) reads, the target of optimization. Common optimization is very likely reads reduction.
Writes are usually not targeted in optimization.
Duration can also be target of optimization especially when stored procedure reengineering required. However, you have to make sure that blocking is not the cause of high duration. For example, a stored procedure with a normal duration of 100 msec, may have on occasion 6 sec duration due to blocking. As such, it does not require optimization, but the blocking sproc has to be investigated.
Optimization article:
http://www.sqlusa.com/articles/query-optimization/
Kalman Toth SQL SERVER 2012 & BI TRAINING
- 편집됨 Kalman TothMicrosoft Community Contributor, Editor 2012년 6월 27일 수요일 오후 7:54
- 답변으로 표시됨 Samuel Lester - MSFTMicrosoft Employee, Moderator 2012년 7월 2일 월요일 오후 6:59
-
2012년 7월 4일 수요일 오전 6:58OK, Thanks
.png)
