Application

Does anyone know of an agent/application that runs on SQL Server that will
allow me to do some sort of process billing? Used to be quite common in the
old days, to bill back users for their usage. Since I have a hosted
application, I want to bill for CPU usage.
I know that I can use SQL Profiler, but was hoping for an agent or service
that would allow me to bill based on DB or User.I would set up a server side trace that logged the the events that you need
to a sql server table. Here is an article I wrote on the subject that
might help you get started with server side tracing:
http://www.dbazine.com/larsen6.shtml
--
----
----
-
Need SQL Server Examples check out my website
http://www.geocities.com/sqlserverexamples
"Kevin Antel" <kevina@.cqlcorp.com> wrote in message
news:%23M5QpgH3EHA.1524@.TK2MSFTNGP09.phx.gbl...
> Does anyone know of an agent/application that runs on SQL Server that will
> allow me to do some sort of process billing? Used to be quite common in
the
> old days, to bill back users for their usage. Since I have a hosted
> application, I want to bill for CPU usage.
> I know that I can use SQL Profiler, but was hoping for an agent or service
> that would allow me to bill based on DB or User.
>