sakthikumar
asked on
Sql trace file
I have enabled Sql trace, I want to know like by what frequency this file will be created.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Mark Geerlings
Only one trace file will be created per process/session that you have it enabled for. So, depending on which level you enabled trace at, you may get one file, or many. But, it (or they) will continue to grow until the session/process being traced either logs out, or explicitly disables tracing.