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 |
|
harshal_in
Aged Yak Warrior
633 Posts |
 Posted - 2002-12-31 : 02:58:12
|
| hi,While running a profiler where is the temp file saving all the traces created? If i run a profiler on the server for a long time will it affect the performance of the system since the size of the temp file will go on increasing? regards,Happy New Year!Harshal.Expect the UnExpectedEdited by - harshal_in on 12/31/2002 03:01:30 |
|
|
rihardh
Constraint Violating Yak Guru
307 Posts |
Posted - 2002-12-31 : 03:32:53
|
| The .tmp file is created on the machine the profiler is running on. Depending on the selected events to trace it can and will affect the performance, if it is run on the server. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2002-12-31 : 12:33:47
|
| It will definitely affect performance, but you can minimize by selecting only those events that you need.The trace file is saved wherever you have told it to go. It can be a table inside SQL Server or a file on the server's disk. If you have elected not to save the trace file, then you can save it after you have stopped the trace by going to File..Save As. HTH |
|
|
|
|
|
|
Profiler question