SET STATISTICS IO setting increases CPU time

Question

SET STATISTICS IO setting increases CPU time

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 1

Don't draw conclusions from one execution.

Run either one a few times, you may well see the CPU time vary, it happens.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

ColdCoffee SSC-Dedicated Points: 39972 More actions · Answer 2

Gail, i ran the tests for around 25 times.. i still see that behavior.. any weird bug in the system?

ColdCoffee SSC-Dedicated Points: 39972 More actions · Answer 3

I went on and ran the tests , one at a time, around 50 times. Now i see a difference. Both tests are yeilding more or less the same metrics. Thanks Gail.