Home Forums SQL Server 2005 Administering SQL TRACE RE: SQL TRACE

  • July 6, 2009 at 6:24 am

    #1020310

    vinothd (7/6/2009)

    Hi Lowell,

    Thanks for u'r prompt reply.I went and viewed the trace thru the view created.

    I have a couple of questions.

    1.Is there any Option to Run the trace for a selected DB

    2.Where does the trace file gets stored physically?can we view the trace file?

    Thanks ,

    Vinoth.D

    the actual folder depends on your machine; run this statement to get the actual path:

    SELECT REVERSE(SUBSTRING(REVERSE(path),CHARINDEX('\',REVERSE(path)),256)) FROM sys.traces WHERE is_default = 1

    on my machine, the path is C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG

    physical files named MyDMLtrace.trc, and eventually MyDMLtrace_1.trc,MyDMLtrace_2.trc, etc will get created in the folder below; you can open them in notepad or a good text editor, but it looks a little funky sometimes. the view is MUCH better for reviewing the details.

    take a look at the level of detail in he view; since it has some of the performance statistics in there as well, you can also use it to see what queries are running the slowest, to help you evaluate those types of factors as well.

    yours may be slightly different.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!