Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
spirit1
Cybernetic Yak Master
11752 Posts |
 Posted - 2009-03-09 : 14:46:42
|
| does anyone have any ideas why this would be?i have a query which is one big CTE.it has 8 parts and a select from those 8 parts.with set statistics io ON it shows 30.000 reads.but for the same query run sql profiler SQL:BatchCompleted shows 500.000 reads.why would that be?___________________________________________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.5 out! |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-03-09 : 15:15:16
|
| Mladen,See this: http://support.microsoft.com/kb/314648 |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2009-03-09 : 15:18:39
|
| seen that but i'm testing on SS 2008 so i assumed that it isn't an issue here since it's says it applies to 7.0 and 2000. so which one is correct? profiler or stats io? worktables are reported in stats io as 0 reads.___________________________________________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.5 out! |
|
|
|
|
|
|
set statistics io and profiler reads differ 16x