Profiler Question (Setting Filters)

Ask a Question related to Microsoft SQL / MS SQL Server, Design and Development.

  1. #1

    Default Profiler Question (Setting Filters)

    I would like to set a filter such that if Reads, Writes and Duration are all
    zero, the event shouldn't be logged. I can easily do this for any
    individual field, but I want to do it for all three fields combined. Any
    way to do this?

    Thanks.


    Amos Soma Guest

  2. Similar Questions and Discussions

    1. Profiler Question
      Hi, In debugging ActionScript 3.0 application shows with 43% of the CPU However I can't find an explanation of what is. And why it takes so...
    2. Setting up mass filters, brushes, etc....
      How can I do this effectivly? The way of loading on dmeand would work great, but I am talking about 600 different effect and filters. I know someone...
    3. Profiler Question (Stored Procedures)
      I'm confused on the difference between RPC and SP. In a trace I set up, I track both RPC:Completed and SP:Completed. When I run an app that makes...
    4. Profiler Question (Scans)
      I have a couple questions regarding understanding Scan profiler output. 1) Sometimes the IndexID data column will contain a value that does not...
    5. Profiler Question (Profiler Message)
      If you click the box that says 'server processes trace' (or something like that...) I don't think you'll get the message. I'm not sure about that......
  3. #2

    Default Re: Profiler Question (Setting Filters)

    there is no way to do this in profiler today...

    --

    Brian Moran
    Principal Mentor
    Solid Quality Learning
    SQL Server MVP
    [url]http://www.solidqualitylearning.com[/url]


    "Amos Soma" <amos_j_soma@nospam.com> wrote in message
    news:uObsiwXQDHA.1560@TK2MSFTNGP12.phx.gbl...
    > I would like to set a filter such that if Reads, Writes and Duration are
    all
    > zero, the event shouldn't be logged. I can easily do this for any
    > individual field, but I want to do it for all three fields combined. Any
    > way to do this?
    >
    > Thanks.
    >
    >

    Brian Moran Guest

Posting Permissions

  • You may not post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139