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.
See my post in the microsoft.public.sqlserver.server thread.
----
-
Need SQL Server Examples check out my website
http://www.geocities.com/sqlserverexamples
"Kevin Antel" <kevina@.cqlcorp.com> wrote in message
news:%23IBOkgH3EHA.1192@.tk2msftngp13.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.
>

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

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

Anyone written an end user guide to using the Reportbuilder?

For those using the ReportBuilder, has anyone put together any sort of end-user guides to getting started with the tool? I'm not referring to articles and docs written from the perspective of introducing the tool and feature set to developers and DBAs but rather something we could all then give our end users when they first start using the tool to build and run reports.

I realize there's lots (and lots) of online help within the tool, but we all know that some users never read that. Again, I'm thinking of something ranging from a 1-2 page quick intro to the use and features, to perhaps even a several page guide.

Even if someone's written one for their company and so it's branded as such, if you're open to sharing it, I won't mind rebranding and modifying it (and happy to share that result then with others).

Indeed, is there perhaps something from MS that I've not thought of?

Raising this again to see if there are any takers. :-)|||I am also looking for the same thing- let me know if you have any luck.

Anyone written an end user guide to using the Reportbuilder?

For those using the ReportBuilder, has anyone put together any sort of end-user guides to getting started with the tool? I'm not referring to articles and docs written from the perspective of introducing the tool and feature set to developers and DBAs but rather something we could all then give our end users when they first start using the tool to build and run reports.

I realize there's lots (and lots) of online help within the tool, but we all know that some users never read that. Again, I'm thinking of something ranging from a 1-2 page quick intro to the use and features, to perhaps even a several page guide.

Even if someone's written one for their company and so it's branded as such, if you're open to sharing it, I won't mind rebranding and modifying it (and happy to share that result then with others).

Indeed, is there perhaps something from MS that I've not thought of?

Raising this again to see if there are any takers. :-)|||I am also looking for the same thing- let me know if you have any luck.