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.
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...
I would take the BOL statement of
Number of writes performed by this request. Is not nullable.
to mean a count of rows written.
If anyone knows it to be different then I have some work to do here ... (!)
