Extend "SQLResponsedb.trc" lifetime

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

Moderators: eddie davis, david connell, dlkj, Colin Millerchip, priyasinha, Emma A

Extend "SQLResponsedb.trc" lifetime

Postby xexex » Tue Jun 26, 2012 5: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?

Thanks
xexex
 
Posts: 41
Joined: Thu Jun 24, 2010 5:50 am

Postby james.billings » Wed Jun 27, 2012 10: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.
james.billings
 
Posts: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.

Postby xexex » Thu Jun 28, 2012 4: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.
xexex
 
Posts: 41
Joined: Thu Jun 24, 2010 5:50 am


Return to SQL Response 1

Who is online

Users browsing this forum: No registered users and 0 guests