What are the challenges you face when working across database platforms? Take the survey
Options

Trace files?

PwalesPwales Posts: 9
edited December 3, 2008 10:05AM in SQL Monitor Previous Versions
I'm new to SQL Repsonse :P

I have enabled one server to keep trace files, but they seem to get deleted off the server withing about 60 minutes. I guess they are being sent to the Response Server, but if so, where is it stroing them? Nothing in the repository database directory.

any ideas? thanks.

Comments

  • Options
    Also, I wonder why it doesn't keep SQL/RPC Batch completed so it can display actual duration etc?
  • Options
    Hi PWales,

    SQL Response will store trace files on the server, it will store either a maximum of 20 files or 1GB in size for each instance before they are deleted/recycled.

    Relevant sections of the trace files are transferred to the Alert Repository before being deleted from the SQL Server. The trace data is kept on the alert repository for the time specified in the alert repository options dialog.

    The location of the trace files is :

    [All Users]\Application Data\Red Gate\SQL Response 1\Alert Repository\\[nn]\[nn]\[nn]\[nn].trace

    I hope this helps.
    Matthew Flatt
    Redgate Foundry
Sign In or Register to comment.