Carl Farmer
SSCrazy
Points: 2197
More actions
March 12, 2003 at 10:01 am
#80466
Is it right that I get 1908 times more reads than I do writes when performing an INSERT INTO command? I am getting 13 writes over 24800 reads. This data is taken from a trace file.
TIA,
Carl.
Steve Jones - SSC Editor
SSC Guru
Points: 736162
March 12, 2003 at 10:45 am
#450894
Are there any triggers or constraints?
Steve Jones
sjones@sqlservercentral.com
http://www.sqlservercentral.com/columnists/sjones
http://www.dkranch.net
March 12, 2003 at 11:01 am
#450897
Yes, there is a trigger. I guess that is causing all the reads?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply