SQL Server Performance

Using Profiler

Discussion in 'Performance Tuning for DBAs' started by loiter99, Dec 15, 2005.

  1. loiter99 New Member

    Hello,
    What is a better gadge to finding items in sql server eatting up the processing time:

    1) Duration
    2) Writes
    3) CPU
    4) All of the above

    Also, I set my duration to 10,000 and I am seeing an awful lot of commands like this:

    -- network protocol: TCP/IP
    set quoted_identifier on
    set implicit_transactions off
    set cursor_close_on_commit off
    set ansi_warnings on
    set ansi_padding on
    set ansi_nulls on
    set concat_null_yields_null on
    set language us_english
    set dateformat mdy
    set datefirst 7

    It is doing it for more than one application name. What is going on here and is it something I can set so the system doesn't have to keep doing it?

    Thanks
    J
  2. Luis Martin Moderator

    I´ll add reads to the counters.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    One of the symptoms of an approaching nervous breakdown is the belief that one's work is terribly important
    Bertrand Russell


    All postings are provided “AS IS” with no warranties for accuracy.



  3. joechang New Member

    the --network is from the login or existing connections, go ahead and remove those events, unless of course your cpu problems are from excessive login/logouts

Share This Page