Measuring Login Times

I'm looking for a way to measure how long it takes to log into a SQL 2005
server from a web server running IIS 6. Does anyone have any ideas?
I've tried using the Profiler, but I haven't been able to think of a way to
capture this info
TIA
--
MGMGeles wrote:
> I'm looking for a way to measure how long it takes to log into a SQL 2005
> server from a web server running IIS 6. Does anyone have any ideas?
> I've tried using the Profiler, but I haven't been able to think of a way t
o
> capture this info
> TIA
> --
> MG
AFAIK, SQL 2005 tracks only when a login is successful or unsuccessful,
not the time it takes to make the connection. You may need to use a
network sniffer to capture traffic between the servers, if that's what
you're trying to measure.
Stavros

Measuring Login Times

I'm looking for a way to measure how long it takes to log into a SQL 2005
server from a web server running IIS 6. Does anyone have any ideas?
I've tried using the Profiler, but I haven't been able to think of a way to
capture this info
TIA
--
MGMGeles wrote:
> I'm looking for a way to measure how long it takes to log into a SQL 2005
> server from a web server running IIS 6. Does anyone have any ideas?
> I've tried using the Profiler, but I haven't been able to think of a way to
> capture this info
> TIA
> --
> MG
AFAIK, SQL 2005 tracks only when a login is successful or unsuccessful,
not the time it takes to make the connection. You may need to use a
network sniffer to capture traffic between the servers, if that's what
you're trying to measure.
Stavros

Meaning of datacode in sysdtslog90?

The documentation says:

"An integer value that identifies the event associated with the log entry. The value 0 indicates the event provided no identifier."

When I look at the sysdtslog90 table and I filter for 'PackageEnd' events, I see a value of 0, 1 or 3 in the datacode column. Is there any information I can glean from these values, e.g. package success or failure?

Did you ever get an answer to this question? I'm interested.

Thanks!

Meaning of datacode in sysdtslog90?

The documentation says:

"An integer value that identifies the event associated with the log entry. The value 0 indicates the event provided no identifier."

When I look at the sysdtslog90 table and I filter for 'PackageEnd' events, I see a value of 0, 1 or 3 in the datacode column. Is there any information I can glean from these values, e.g. package success or failure?

Did you ever get an answer to this question? I'm interested.

Thanks!