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 using OSISoft PI system with SSRS?

Have any of you interfaced with OSI Soft PI system? This is a proprietary database which is said to support OLEDB and ODBC. OSISoft PI is a common "historian" for time-series data storage in process control systems and real-time control systems.

Thanks

The PI Sytem does indeed support OLEDB and ODBC access. For more info, please contact OSIsoft Technical Support at techsupport@.osisoft.com for assistance. Reference the system number of the PI Server which you are inquiring on behalf of when you send in your question.

Thanks, Steve Nye, OSIsoft Technical Support

Anyone using OSISoft PI system with SSRS?

Have any of you interfaced with OSI Soft PI system? This is a proprietary database which is said to support OLEDB and ODBC. OSISoft PI is a common "historian" for time-series data storage in process control systems and real-time control systems.

Thanks

The PI Sytem does indeed support OLEDB and ODBC access. For more info, please contact OSIsoft Technical Support at techsupport@.osisoft.com for assistance. Reference the system number of the PI Server which you are inquiring on behalf of when you send in your question.

Thanks, Steve Nye, OSIsoft Technical Support