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
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.
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