SQL Server Performance

Inapproriate writes observed in PERFMON when a query is issued

Discussion in 'ALL SQL SERVER QUESTIONS' started by Arun Chaitanya, Jul 8, 2012.

  1. Arun Chaitanya New Member


    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
  2. Luis Martin Moderator

    What kind of write are you measuring?. Logical or physical?.
  3. Arun Chaitanya New Member

    Sorry, I didn't exactly understand the difference.

    I have issued a read-only query (does an index lookup over a table and prints the results) and
    observed that its taking more time than it should. So, I checked out PERFMON for any clues.
    I was astonished to see a System process writing to the temp file. I tried several other simpler
    queries and found that such writes are happening after the query is issued.

    I run the query from Management Studio - Does it have to do with this client?

  4. Luis Martin Moderator

    "Does it have to do with this client?"
    Don't think so, but did you try from other client?

Share This Page