Inapproriate writes observed in PERFMON when a query is issued

Question

Inapproriate writes observed in PERFMON when a query is issued

chaitan64arun

Newbie

Points: 2
More actions
July 8, 2012 at 5:55 am

#258569

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

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

do you have fulltext enabled?

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

You're running the query in Management Studio on the same machine as the SQL service. That's SSMS's 'scratchpad' for query results (it's how it can display results that exceed the size of memory)

It's not SQL Server doing the writes, which is why you don't see it in profiler, it's the client tool.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

chaitan64arun Newbie Points: 2 More actions · Answer 3

Hello,

I think that answers my problem.

Anyways, I will confirm it soon.

I should try the following link:

http://msdn.microsoft.com/en-us/library/ms190078.aspx

Thanks a lot