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

Collecting Trace Data

I have enabled the collection of trace data on both servers which are being monitored. However, I am yet to see any trace data appear in the performance snapshot for any alert. I have checked deadlocks, blocks, long running queries and so on, and all I see is "No SQL Statements to Display".

I have looked for the [All Users]\Application Data\Red Gate\SQL Response 1\Alert Repository directory on both the montored and repository machines, however no such folder exists.

It looks like there's some SQLResponse*.trc files sitting on my monitored server in the L drive where the DB Log files are kept.

Is there a setting somewhere to tell the repository where to pick the trace files up from?
Scott Herbert
0

Comments

2 comments

Sort by
  • dlkj
    Hi Scott,

    [All users] can be found at C:\Documents and Settings\All Users on Windows XP/Server 2003 and earlier and C:\ProgramData on Vista and Server 2008.

    Which version of the Alert Repository do you have installed?

    Could you please zip up and send your Alert Repository Log Files

    You can find your alert repository log files at: C:\Documents and Settings\All Users\Application Data\Red Gate\Logs\SQL Response Alert Repository 1
    dlkj
    0
  • Scott Herbert
    Just one thing which might be helpful in FAQs, manuals etc for this product is making clear which machine is being talked about when file locations are given. The monitored server? The machine on which the repository is located? etc.

    I've sent an email containing the logs which were stored on the repository machine.
    Scott Herbert
    0

Add comment

Please sign in to leave a comment.