Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 Other SQL Server 2012 Topics
 Inapproriate writes observed in PERFMON when a que

Author  Topic 

chaitan64arun
Starting Member

1 Post

Posted - 2012-07-08 : 07:49:08
Hello,

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,

Arun Chaitanya
   

- Advertisement -