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 |
|
shilpesh
Starting Member
18 Posts |
 Posted - 2001-11-01 : 00:30:01
|
| I am using "statistics time on" to optimise my procs as "statistics io" seems to be useless (coz of hash matches, etc). My code is utilizing 100% cpu (perf mon) and there are absolutely no physical reads. But still the cpu time and elapsed time shown by the statistics is very less than the actual elapsed time (which i find using getdate). This is happening for around 75% of the queries in the proc. Please help. Or should I go back to Sybase? |
|
|
|
|
|
Statistics Time