What you want is SQL Profiler. Set up a log profile to
audit the counters you want and you should be able to get
a pretty comprehensive view. You can have profiler output
it's logging to a table that you could then transform into
some kind of OLAP schema if you want drill-down/drill-
across for analysis.
Note - SQL Profiler has a CPU and Disk IO hit that's more
or less unavoidable.
SQL Server DBA
-----Original Message----- |
actually what I am looking for is data so I can see how
much of the system a
user is using.
Connected at (time)
Disconnected at (time)
I want (need) to be able to see how much the software is
being used so I can
call and help the prospective customer.
I need the cumulative amount of usage. I found some
stuff to do with Cube
Wizards, but I have not figured it out yet.
"Quentin Ran" <ab (AT) who (DOT) com> wrote in message
news:eUylngskDHA.2060 (AT) tk2msftngp13 (DOT) phx.gbl...
in EM, under server, management, current activity,
process info, you can
info for each individual process. See whether that's
what you are looking
"George Collins" <nospan@nothingcom> wrote in message
news:unpq5WrkDHA.3024 (AT) tk2msftngp13 (DOT) phx.gbl...
I have been trying to figure out a way to see user
Connect times (start, stop,usage)
I let people demo VB6 software on my server over the
net and I would
see who is doing what, does SQL 2000 have this