Extend "SQLResponsedb.trc" lifetime

Monitor, diagnose and receive alerts to problems across your SQL Servers.

Extend "SQLResponsedb.trc" lifetime

Postby xexex » Tue Jun 26, 2012 4:20 am

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?

Posts: 43
Joined: Thu Jun 24, 2010 4:50 am

Postby james.billings » Wed Jun 27, 2012 9:54 am

Thanks for your post regarding SQL Response. Unfortunately, the tracing (as described [url=http://www.red-gate.com/supportcenter/Content?p=SQL%20Response&c=SQL_Response\\help\\1.3\\SR_Collecting_Trace.htm]here[/url] 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.
Posts: 1122
Joined: Wed Jun 16, 2010 10:10 am
Location: Red Gate

Postby xexex » Thu Jun 28, 2012 3:11 am

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.
Posts: 43
Joined: Thu Jun 24, 2010 4:50 am

Return to SQL Monitor Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests