我的理解时间探查器中writes就是指多少次写操作,
但是为何我的insert,update语句执行时,虽然reads值不为0,但writes的值为何都为0?
但是为何我的insert,update语句执行时,虽然reads值不为0,但writes的值为何都为0?
解决方案 »
- 在SQL2005中 只能用Windows身份验证 咋不能用sa用户啊??
- 求SQL两个字段相加
- 如何在触发器中更改文件名称?(生手问题,在线等,问题解决马上送分)
- 怎么选择除了某某记录的所有记录?
- SQL select数据问题
- 统计出现的次数
- 能不能修改现行表的字段为非空字段?
- SQL SERVER数据库,这个语句太复杂了,实在头疼,谁能帮帮我啊
- 根据参数从1-n个表中检索某个字段的值的问题,请教高手!
- 求高手高手高高手解决两个表(销售、退货)数据冲减问题,不要用游标
- 算出一年中有几个周日,或是有几周
- 有张产品价格数据表,要求不同的产品价格根据设定的时间过期和用人工的方式设定过期,把它保存到另一张表中怎么做啊
http://blogs.sqlserver.org.au/blogs/greg_linwood/archive/2006/12/11/492.aspx
Writes is the last of the major query performance measurements offered by SQL Trace. Whilst it provides some useful information about how many 8kb write a query performed, I rarely find this terribly useful when query tuning as there is little scope for much to go "wrong" with write characteristics. This is a very different picture to Reads because many factors can (& often do) cause query read behaviour to degrade (indexes, statistics etc).
http://msdn.microsoft.com/en-us/library/aa260314.aspx
17 Writes Number of physical disk writes performed by the server on behalf of the event.
set statistics io on
--set statistics time on
来看更细节的io情况
偶的理解是write只是写在了cache里, 然后才会有checkpoint. 如果你写的都是物理写的, 要是你想回滚怎么办? 都再物理读一遍?? 显然不是的.