Why do i see writes in profiler trace when my query is only a select?

Question

Why do i see writes in profiler trace when my query is only a select?

curious_sqldba

SSC-Dedicated

Points: 36494
More actions
September 19, 2013 at 11:09 am

#282679

I just noticed that i see some writes under Writes column on sql profiler trace. These writes are physical writes. My query might be writing some data to tempdb, is that the reason?

Viewing 5 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: 1004504 More actions · Answer 1

TempDB.

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

curious_sqldba SSC-Dedicated Points: 36494 More actions · Answer 2

GilaMonster (9/19/2013)
TempDB.

Thanks . Then comes my second question, is there any way ONLY to filter on "Reads" in profiler, i mean i basically want queries thats DONT change the data...

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

You could filter for Writes = 0, but that will exclude anything that touches TempDB, so maybe not what you want. Why do you want to exclude anything that writes?

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

curious_sqldba SSC-Dedicated Points: 36494 More actions · Answer 4

I guess i could . I am trying to replay transactions from prod to my test, but then i cant replay or wont have any value to the one's which are making data changes for various reasons.