SQL Server Performance

Traces

Discussion in 'Getting Started' started by lara99, Oct 10, 2007.

  1. lara99 New Member

    Hi, gurus
    Is there a way to see the traces set on a particular instances.
    Thanks.
  2. MichaelB Member

    Are you talking about sql2005 default traces? if so, yes, they will be in different directories like:
    C:SQLDATAMSSQL.1MSSQLLOG
    C:SQLDATAMSSQL.2MSSQLLOG
  3. satya Moderator

    What Mike referred is best one to go to see the basic processing information, if you need further dig out on a specific set of queries then PROFILER or server side trace using SPs will help you a lot.
    But be clear on what you want.
  4. lara99 New Member

    Thank U guys, for the reply, I was asking like is there any command in QA which give us the present trace enabled not the default one but user defined - user defined in the sense set by the person who is interacting with QA , I hope I am clear enough Thanku.
  5. satya Moderator

    SELECT * FROM fn_trace_getinfo(0) to view the data in that trace file, formore information on what users are running SP_WHO2 will get you more.

Share This Page