Profiler

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

anita - 23 Feb 2005 19:15 GMT

Running profiler to catch anything on the server that has
a duration of greater than 30,000 miliseconds(30 sec),
and realisticly we shouldn't have much logged, but in 3
hours we have over 23,000 rows logged and most of the
rows text data is recording 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

What does this mean? And why is this running so long?
Thanks!

Reply to this Message

Andrew J. Kelly - 23 Feb 2005 19:24 GMT

That is most likely coming from the Logout event. Remove that event from
the trace definition and it should go away.

Signature

Andrew J. Kelly SQL MVP

> Running profiler to catch anything on the server that has
> a duration of greater than 30,000 miliseconds(30 sec),
[quoted text clipped - 15 lines]
> What does this mean? And why is this running so long?
> Thanks!

Reply to this Message

Kevin McDonnell [MSFT] - 25 Feb 2005 01:13 GMT

See the following topics in Books Online:

Set Options

User Options;
user options Option
Use the user options option to specify global defaults for all users. A
list of default query processing options is established for the duration of
a user's work session. user options allows you to change the default values
of the SET options (if the server's default settings are not appropriate).
A user can override these defaults by using the SET statement. You can
configure user options dynamically for new logins. After you change the
setting of user options, new logins use the new setting; current logins are
not affected.

Thanks,

Kevin McDonnell
Microsoft Corporation

This posting is provided AS IS with no warranties, and confers no rights.

Reply to this Message