What does the Writes columns in the DMV sys.dm_exec_requests show?
I have tried to Google it, but failed. BOL does not tell what it is.
Is it 8kb pages, or rows written, or ?
I have a MERGE command running.
I know how many rows needs inserting and how many updating (aprox), so I had hoped that I could see how far it is.
Answer by Matt Whitfield ·
I've just done a bit of testing with
[sys].[dm_exec_sessions], and the
[writes] column in that seems to show pages, not rows. So I don't know if they would be consistent, but I would expect them to be.
To be honest, it's worth waiting until later and hoping Grant answers - because this is certainly an area where his knowledge makes the rest of us look like kids at play school...