Post reply

SQL Profiler andFiltering

  • July 6, 2008 at 6:58 am

    #154503

    Hi

    I want to just monitor my procedures on server but don;t know how to set the filtering.

    Any Idea is appreciated

  • July 6, 2008 at 10:46 am

    #838609

    there is a section for stored procedures in the events tab or filter by object type 8272

  • July 6, 2008 at 11:23 am

    #838616

    Could you explain a bit more what kind of filtering you're trying to do?

    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

  • July 6, 2008 at 9:41 pm

    #838659

    Thanks for the reply 🙂

    I'd like to monitor my stored procedures on another server. I think I should use SP_Counts or TSQL_SPs templates but what if I need a combined result of the two templates?

    Where can I find an explanation for stored procedures events?

    P.S. I love this statement: "Have a nice day, unless you have other plans" would you mind if I use it in my email signature?:)

  • July 7, 2008 at 12:29 am

    #838695

    peace2007 (7/6/2008)

    Thanks for the reply 🙂

    I'd like to monitor my stored procedures on another server. I think I should use SP_Counts or TSQL_SPs templates but what if I need a combined result of the two templates?

    I never actually use the templates. I set up the events and columns I want by hand. Normally the two I use are PRC:Completed and T-SQL:Batch Completed.

    From what you said, you probably want either RPC:completed or SP:Completed

    Where can I find an explanation for stored procedures events?

    Books online has some info on the events. If it's not enough, ask here for clarification. Someone should know.

    P.S. I love this statement: "Have a nice day, unless you have other plans" would you mind if I use it in my email signature?:)

    Go wild. I didn't write it. I found it somewhere and liked it enough to use it.

    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

  • July 7, 2008 at 12:35 am

    #838697

    Thanks for the comments 🙂

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

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