Post reply

Trace Profiler GUI

  • September 14, 2009 at 5:43 pm

    #133950

    I ran a trace using the GUI expecting it to run continuously,only to find out that it stopped due to unknown error. Is it designed to run continuously everyday or just a period of time, say, limit in the number of hours of tracing?

    How can I make it run continuously, because I'm trying to save all traces on a certain stored procedure to a table for audit purposes. The vendor of the system we are using are not keen to change their table structure to add 'changeByName' and changeByDate', so I'm trying to capture it from the parameters supplied to that SP i'm monitoring. Any ideas?

    Thanks

  • September 14, 2009 at 8:00 pm

    #1053527

    I'd say lookup sp_trace_create and see if that would work for you..

    CEWII

  • September 15, 2009 at 8:55 am

    #1053850

    dont they like that "their" table is changed or dont they like that you add a table for auditing purposes ?

    if it's the first situation i would consider triggers which log to a dedicated table for logging (with a cleanup procedure).

    i found an article about using traces:

    Default trace - A Beginner's Guide

    By Adam Haines, 2008/11/11

    http://qa.sqlservercentral.com/articles/SQL+Server+2005/64547/

  • September 15, 2009 at 6:45 pm

    #1054203

    Edward, they don't like to change the structure for simple requests from users like that. Fortunately I was able to grab a tutorial on tracing, made it as a stored proc, and now extracting all parameters to the update stored proc that I'm trying to monitor.

    Thanks for the link. Good day.

  • September 16, 2009 at 8:36 am

    #1054489

    In general you should not run the GUI profiler continuously. a) it has a MUCH more significant overhead on the server than profiling to a local disk file and b) it can miss events if things get busy

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply