Performance counters

Performance counters
I have noticed that on my server (on which I am a 'co'-
administrator), the SQL Server specific performance
counters are not available in the performance monitoring
tool. Did I overlook something when I installed SQL
Server? (My development server does in fact show these
performance counters.) Or, could they have been removed?
If so, how? And, finally, can I get them in there without
having to re-install SQL Server?
Any assistance/feedback is greatly appreciated.> I have noticed that on my server (on which I am a 'co'-
> administrator), the SQL Server specific performance
> counters are not available in the performance monitoring
> tool. Did I overlook something when I installed SQL
> Server? (My development server does in fact show these
> performance counters.) Or, could they have been removed?
> If so, how? And, finally, can I get them in there without
> having to re-install SQL Server?
See my answer on microsoft.public.sqlserver.setup
sincerely,
--
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.|||Ask your 'co'-administrator what had he/she ran on that server before you
started SQL Server setup.
It seems like you missed one or two error messages in Windows NT Error Log
when you were installing SQL Server.
It might be one of those HP/Compaq "smart monitoring utilities" that holds
perfh009.dat and/or perfc009.dat files.
Check the following article with your 'co'-administrator and be careful if
this is a production server.
http://support.microsoft.com/defaul...kb;en-us;300956
Regards,
Igor
"/.dz" <anonymous@.discussions.microsoft.com> wrote in message
news:d61901c3ef48$efda49d0$a401280a@.phx.gbl...
> Performance counters
> I have noticed that on my server (on which I am a 'co'-
> administrator), the SQL Server specific performance
> counters are not available in the performance monitoring
> tool. Did I overlook something when I installed SQL
> Server? (My development server does in fact show these
> performance counters.) Or, could they have been removed?
> If so, how? And, finally, can I get them in there without
> having to re-install SQL Server?
> Any assistance/feedback is greatly appreciated.
>

Performance counters

Performance counters
I have noticed that on my server (on which I am a 'co'-
administrator), the SQL Server specific performance
counters are not available in the performance monitoring
tool. Did I overlook something when I installed SQL
Server? (My development server does in fact show these
performance counters.) Or, could they have been removed?
If so, how? And, finally, can I get them in there without
having to re-install SQL Server?
Any assistance/feedback is greatly appreciated.> I have noticed that on my server (on which I am a 'co'-
> administrator), the SQL Server specific performance
> counters are not available in the performance monitoring
> tool. Did I overlook something when I installed SQL
> Server? (My development server does in fact show these
> performance counters.) Or, could they have been removed?
> If so, how? And, finally, can I get them in there without
> having to re-install SQL Server?
See my answer on microsoft.public.sqlserver.setup
sincerely,
--
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.|||Ask your 'co'-administrator what had he/she ran on that server before you
started SQL Server setup.
It seems like you missed one or two error messages in Windows NT Error Log
when you were installing SQL Server.
It might be one of those HP/Compaq "smart monitoring utilities" that holds
perfh009.dat and/or perfc009.dat files.
Check the following article with your 'co'-administrator and be careful if
this is a production server.
http://support.microsoft.com/default.aspx?scid=kb;en-us;300956
Regards,
Igor
"/.dz" <anonymous@.discussions.microsoft.com> wrote in message
news:d61901c3ef48$efda49d0$a401280a@.phx.gbl...
> Performance counters
> I have noticed that on my server (on which I am a 'co'-
> administrator), the SQL Server specific performance
> counters are not available in the performance monitoring
> tool. Did I overlook something when I installed SQL
> Server? (My development server does in fact show these
> performance counters.) Or, could they have been removed?
> If so, how? And, finally, can I get them in there without
> having to re-install SQL Server?
> Any assistance/feedback is greatly appreciated.
>

Performance counter on Report.

Our company used Reporting Services for a certain months.

One day, my administrator ask me if he can know each report's processing status.

For example, the average processing time of report name "Order Report".

Can the performance counters of reporting services do that?

Thanks alot!

As Benni said, using the DTS package we provide to export the contents of the ExecutionLog table is the best way to go (it is not a best practice to query this table directly, though)

There are no perfmon counters that you can use that will allow you to say "Specifically, give me information about report 'XZY'". However, there are some undocumented counters that will give you some of the same information as the execution log about the last run report. You can find info about them here:

http://blogs.msdn.com/bimusings/archive/2005/07/26/443511.aspx

|||

I haven't found anything about that in the api, but there is a nice table in ReportServer-Database.

Take a look at dbo.ExecutionLog (and for getting the reportnames dbo.Catalog). dbo.ExecutionLog has some TimeXYZ columns wich give you the time in millis..