How can we help you today? How can we help you today?

Extend "SQLResponsedb.trc" lifetime

We're using SQL Monitor 1.3 and enable "collection of trace data", trace files are obtained in "C:\Program Files\Microsoft SQL Server\MSSQL\Data", they will be kept 20 mins.

Can I extend the lifetime of those files without copying to another location every 10 mins, e.g. keep files 1 day or longer?

Thanks
xexex
0

Comments

2 comments

Sort by
  • James B
    Thanks for your post regarding SQL Response. Unfortunately, the tracing (as described here cannot really be configured in any way. I double-checked the config file to see if there was a hidden option, but nothing appeared.

    Unfortunately, SQL Response was discontinued almost 2 years ago and no further development will take place, so this isn't a change you're going to see in the future I'm afraid.
    James B
    0
  • xexex
    Thanks for reply, I create a job which will copy the trace files to another location.
    The UI of SQL response is better than SQL monitor, there are more details, icons and color in "Performance Snapshot => Statement", so there're no planning for upgrade.
    xexex
    0

Add comment

Please sign in to leave a comment.