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.
    
        | 
                
                    | 
                            
                                | Author | Topic |  
                                    | chaitan64arunStarting 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 |  |  
                                |  |  |  |