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

    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
    Arun Chaitanya, Jul 8, 2012
    #1

  2. Luis Martin Moderator

    What kind of write are you measuring?. Logical or physical?.
    Luis Martin, Jul 9, 2012
    #2

  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?

    Thanks,
    Arun Chaitanya, Jul 9, 2012
    #3

  4. Luis Martin Moderator

    "Does it have to do with this client?"
    Don't think so, but did you try from other client?
    Luis Martin, Jul 10, 2012
    #4

Share This Page