Post reply

Can I upload the profiler trace file into reporting services to get a report...

  • June 1, 2011 at 12:40 am

    #237196

    I have the Trace file of profiler wih all securiy logins enabled.

    can I upload the profiler trace file into reporting services to get a report...

    Thanks

  • June 1, 2011 at 1:20 am

    #1332390

    Typically you dump the trace file output into a SQL server table and then query against that

    USE Mydb

    GO

    SELECT * INTO mytracetable

    FROM fn_trace_gettable('c:\temp\mytrace.trc', default);

    GO

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • June 1, 2011 at 1:51 am

    #1332396

    Thanks

    I have not the IIS on Database machine can I work on reporting services..

    Thanks

  • June 1, 2011 at 2:22 am

    #1332399

    Yes

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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