Posted - 07/08/2012 : 07:49:08
I was using SQL Server 2012 RC0 to take some performance measures.
I observed an inappropriate file write in PERFMON, whenever a query is being run.
It is strange that there are no reads/ writes found in the profiler against the query.
The writes are being done to a file at AppData/Local/Temp/tmpxxx.tmp at a rate of 900,000,000 B/min (as shown in PERFMON)
by a System Process with PID 4.
Does any one know about this ?
Thanks in advance,