SQL Server Performance

Quick profiler question

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by Kwisatz78, Aug 25, 2009.

  1. Kwisatz78 New Member

    HI there - I am following the guide on using profiler to audit performance issues, and in there it advised to filter out System events. Can anyone clarify which filter I need to apply to do this, is it the NTUserName filter with System in the not like?
    Thanks
    Kwisatz78, Aug 25, 2009
    #2

  2. MohammedU New Member

    Welcome to the forum...
    Filter is depends on what you kind of performance issues you are looking...
    ex: Login running queries will be filtered on DURATION, high cpu queries is "CPU" etc...
    If you are perticularly looking for a longin issue then filter on Nt user name or login name etc...
    Check the following article...
    http://technet.microsoft.com/en-us/library/cc966515.aspx
    MohammedU, Aug 25, 2009
    #3

  3. Kwisatz78 New Member

    HI thanks for the reply.
    Specifically I was reading this article:
    http://www.sql-server-performance.com/articles/per/performance_audit_part8_p1.aspx
    In there it says to filter out system events, along with having duration > 5secs and also specifying a database ID. I can filter on database and duration but am unsure on how to filter out system events.
    Are you able to clarify or am I still being to vague?
    Thanks
    Kwisatz78, Aug 26, 2009
    #4

  4. Luis Martin Moderator

    Profiler itself is system events (or something you don't want to trace). Profiler is already in the filter.
    Also if you have any 3rd party tool then you may want to exclude it.
    Luis Martin, Aug 26, 2009
    #5

  5. MohammedU New Member

    Open the profiler and connect to the server and click on Column Filters... button then in Application Name column you can give application name to exclude/include in the filter...
    ex: sql agent etc...
    MohammedU, Aug 26, 2009
    #6

  6. Kwisatz78 New Member

    Ah I see - thanks for clearing that up. SQL Agent did account for a few of the longer durations, so filtering that out should help.
    Kwisatz78, Aug 27, 2009
    #7

Share This Page