I was running a long query (in SQL Query Analyzer) today and after about 40 minutes, a temp file (qag7a.tmp) appeared on my pc. It seemed as though SQL server was using my local processor (processor was at 100% in the task manager). The temp file quickly used up all available disk space and did not disappear until I disconnected from SQL Server. I thought all of the processing should be done on the server. Does this relate to the SQL Server setup?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
qag7a.tmp
- Thread starter scotward
- Start date
tlbroadbent
MIS
If you are using Query Analyzer to capture and view the data, the results will be returned to your PC. Like nearly all Windows programs, QA makes use of temporary files. If the result set is large and you are returning text to the result window rather than a grid, QA can max out the PC.
It is not the query that the PC is working on. It is processing the result set for display on your PC. I recommend using the grid to return the results and reducing the number of rows returned by the query. Terry L. Broadbent - DBA
Computing Links:
faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.
It is not the query that the PC is working on. It is processing the result set for display on your PC. I recommend using the grid to return the results and reducing the number of rows returned by the query. Terry L. Broadbent - DBA
Computing Links:
faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.
- Thread starter
- #3
- Status