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

Perf Mon

I want to monitor avg disk queue length and cpu for the
last ten minutes to see if one or the other has exceeded
a certain threshold during that time. If so, I want to
get an email.
1. Can this occur with Perf Mon?
2. Are there any third party tools that can do this?NoMoFlo,
#1. Iam unaware of an alert facility in perfmon.
#2. MS has another tool called Microsoft Operations Manager (MOM)
http://www.microsoft.com/mom/ .
A good third party tool is SiteScope:
'Mercury SiteScope'
scope/" target="_blank">http://www.mercury.com/us/products/...e
scope/
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"NoMoFlo" <anonymous@.discussions.microsoft.com> wrote in message
news:20be901c45a31$7a505980$a601280a@.phx
.gbl...
> I want to monitor avg disk queue length and cpu for the
> last ten minutes to see if one or the other has exceeded
> a certain threshold during that time. If so, I want to
> get an email.
> 1. Can this occur with Perf Mon?
> 2. Are there any third party tools that can do this?|||Hi,
There is anothor best tool from BMC . Name of thre tool is BMC PATROL.
Using this we can monitor the online performance , Email Alert, as well as
see the history .
http://www.bmc.com/products/
Thanks
Hari
MCDBA
"NoMoFlo" <anonymous@.discussions.microsoft.com> wrote in message
news:20be901c45a31$7a505980$a601280a@.phx
.gbl...
> I want to monitor avg disk queue length and cpu for the
> last ten minutes to see if one or the other has exceeded
> a certain threshold during that time. If so, I want to
> get an email.
> 1. Can this occur with Perf Mon?
> 2. Are there any third party tools that can do this?|||Go to Administrative Tools then to Performance. In the
PerfMon console tree, go to the Performance Logs and Alerts
node and then select Alerts. Right click and select New
Alert Settings to create a PerfMon alert. After providing a
name for the alert, you can set up the counters and
thresholds. On the Action tab, you can set up the response
to the counters exceeding the threshold.
You can right click on alerts, select help and get more
information on setting this up.
-Sue
On Thu, 24 Jun 2004 14:23:22 -0700, "NoMoFlo"
<anonymous@.discussions.microsoft.com> wrote:

>I want to monitor avg disk queue length and cpu for the
>last ten minutes to see if one or the other has exceeded
>a certain threshold during that time. If so, I want to
>get an email.
>1. Can this occur with Perf Mon?
>2. Are there any third party tools that can do this?

Perf Mon

I want to monitor avg disk queue length and cpu for the
last ten minutes to see if one or the other has exceeded
a certain threshold during that time. If so, I want to
get an email.
1. Can this occur with Perf Mon?
2. Are there any third party tools that can do this?NoMoFlo,
#1. Iam unaware of an alert facility in perfmon.
#2. MS has another tool called Microsoft Operations Manager (MOM)
http://www.microsoft.com/mom/ .
A good third party tool is SiteScope:
'Mercury SiteScope'
http://www.mercury.com/us/products/application-management/foundation/monitors/sitescope/
--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"NoMoFlo" <anonymous@.discussions.microsoft.com> wrote in message
news:20be901c45a31$7a505980$a601280a@.phx.gbl...
> I want to monitor avg disk queue length and cpu for the
> last ten minutes to see if one or the other has exceeded
> a certain threshold during that time. If so, I want to
> get an email.
> 1. Can this occur with Perf Mon?
> 2. Are there any third party tools that can do this?|||Hi,
There is anothor best tool from BMC . Name of thre tool is BMC PATROL.
Using this we can monitor the online performance , Email Alert, as well as
see the history .
http://www.bmc.com/products/
--
Thanks
Hari
MCDBA
"NoMoFlo" <anonymous@.discussions.microsoft.com> wrote in message
news:20be901c45a31$7a505980$a601280a@.phx.gbl...
> I want to monitor avg disk queue length and cpu for the
> last ten minutes to see if one or the other has exceeded
> a certain threshold during that time. If so, I want to
> get an email.
> 1. Can this occur with Perf Mon?
> 2. Are there any third party tools that can do this?|||Go to Administrative Tools then to Performance. In the
PerfMon console tree, go to the Performance Logs and Alerts
node and then select Alerts. Right click and select New
Alert Settings to create a PerfMon alert. After providing a
name for the alert, you can set up the counters and
thresholds. On the Action tab, you can set up the response
to the counters exceeding the threshold.
You can right click on alerts, select help and get more
information on setting this up.
-Sue
On Thu, 24 Jun 2004 14:23:22 -0700, "NoMoFlo"
<anonymous@.discussions.microsoft.com> wrote:
>I want to monitor avg disk queue length and cpu for the
>last ten minutes to see if one or the other has exceeded
>a certain threshold during that time. If so, I want to
>get an email.
>1. Can this occur with Perf Mon?
>2. Are there any third party tools that can do this?

Perf Mon

I want to monitor avg disk queue length and cpu for the
last ten minutes to see if one or the other has exceeded
a certain threshold during that time. If so, I want to
get an email.
1. Can this occur with Perf Mon?
2. Are there any third party tools that can do this?
NoMoFlo,
#1. Iam unaware of an alert facility in perfmon.
#2. MS has another tool called Microsoft Operations Manager (MOM)
http://www.microsoft.com/mom/ .
A good third party tool is SiteScope:
'Mercury SiteScope'
http://www.mercury.com/us/products/a...ors/sitescope/
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"NoMoFlo" <anonymous@.discussions.microsoft.com> wrote in message
news:20be901c45a31$7a505980$a601280a@.phx.gbl...
> I want to monitor avg disk queue length and cpu for the
> last ten minutes to see if one or the other has exceeded
> a certain threshold during that time. If so, I want to
> get an email.
> 1. Can this occur with Perf Mon?
> 2. Are there any third party tools that can do this?
|||Hi,
There is anothor best tool from BMC . Name of thre tool is BMC PATROL.
Using this we can monitor the online performance , Email Alert, as well as
see the history .
http://www.bmc.com/products/
Thanks
Hari
MCDBA
"NoMoFlo" <anonymous@.discussions.microsoft.com> wrote in message
news:20be901c45a31$7a505980$a601280a@.phx.gbl...
> I want to monitor avg disk queue length and cpu for the
> last ten minutes to see if one or the other has exceeded
> a certain threshold during that time. If so, I want to
> get an email.
> 1. Can this occur with Perf Mon?
> 2. Are there any third party tools that can do this?
|||Go to Administrative Tools then to Performance. In the
PerfMon console tree, go to the Performance Logs and Alerts
node and then select Alerts. Right click and select New
Alert Settings to create a PerfMon alert. After providing a
name for the alert, you can set up the counters and
thresholds. On the Action tab, you can set up the response
to the counters exceeding the threshold.
You can right click on alerts, select help and get more
information on setting this up.
-Sue
On Thu, 24 Jun 2004 14:23:22 -0700, "NoMoFlo"
<anonymous@.discussions.microsoft.com> wrote:

>I want to monitor avg disk queue length and cpu for the
>last ten minutes to see if one or the other has exceeded
>a certain threshold during that time. If so, I want to
>get an email.
>1. Can this occur with Perf Mon?
>2. Are there any third party tools that can do this?

Percentage of total column in Report Builder

Hello,
We are the using the end-user tool Report Builder. I want to create a
'Percentage of total' column to a certain table. For example:
Value Percentage of total
Region A 200 20%
Region B 500 50%
Region C 300 30%
--
Total 1000 100%
How can I achieve that?
Regards,
Jaap MosselmanHello Jaap,
I sugget you add a new field in the Report Build which calculate the
Percentage of the total.
And you could format the column to show as the percentage.
Hope this helps.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Ok, new field is not problem, but how can I retrieve the actual (sub)total
value (in this example 1000) to use as denominator?
Value Percentage of total
Region A 200 20%
Region B 500 50%
Region C 300 30%
--
Total 1000 100%
Regards, Jaap
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> schreef in bericht
news:J3V2QNplHHA.1140@.TK2MSFTNGHUB02.phx.gbl...
> Hello Jaap,
> I sugget you add a new field in the Report Build which calculate the
> Percentage of the total.
> And you could format the column to show as the percentage.
> Hope this helps.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||You should be able to get the sum by doing something like this:
=IIF(sum(Fields!Yourvalue.value), "yourdataset")>0, fields!YourValue.Value /
sum(Fields!YourValue.Value, "yourdataset"))
Or you could do the summing in your dataset, and just use it as a normal
field.
Kaisa M. Lindahl Lervik
"Jaap" <Jaap@.newsgroups.nospam> wrote in message
news:u3lwBX6lHHA.4960@.TK2MSFTNGP02.phx.gbl...
> Ok, new field is not problem, but how can I retrieve the actual (sub)total
> value (in this example 1000) to use as denominator?
> Value Percentage of total
> Region A 200 20%
> Region B 500 50%
> Region C 300 30%
> --
> Total 1000 100%
> Regards, Jaap
> "Wei Lu [MSFT]" <weilu@.online.microsoft.com> schreef in bericht
> news:J3V2QNplHHA.1140@.TK2MSFTNGHUB02.phx.gbl...
>> Hello Jaap,
>> I sugget you add a new field in the Report Build which calculate the
>> Percentage of the total.
>> And you could format the column to show as the percentage.
>> Hope this helps.
>> Sincerely,
>> Wei Lu
>> Microsoft Online Community Support
>> ==================================================>> When responding to posts, please "Reply to Group" via your newsreader so
>> that others may learn and benefit from your issue.
>> ==================================================>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Is that possible in de Report Builder end user tool?
Or only in the VS Report Editor?
Jaap
"Kaisa M. Lindahl Lervik" <kaisaml@.hotmail.com> schreef in bericht
news:%23I4ML46lHHA.3484@.TK2MSFTNGP02.phx.gbl...
> You should be able to get the sum by doing something like this:
> =IIF(sum(Fields!Yourvalue.value), "yourdataset")>0, fields!YourValue.Value
> / sum(Fields!YourValue.Value, "yourdataset"))
> Or you could do the summing in your dataset, and just use it as a normal
> field.
> Kaisa M. Lindahl Lervik
> "Jaap" <Jaap@.newsgroups.nospam> wrote in message
> news:u3lwBX6lHHA.4960@.TK2MSFTNGP02.phx.gbl...
>> Ok, new field is not problem, but how can I retrieve the actual
>> (sub)total value (in this example 1000) to use as denominator?
>> Value Percentage of total
>> Region A 200 20%
>> Region B 500 50%
>> Region C 300 30%
>> --
>> Total 1000 100%
>> Regards, Jaap
>> "Wei Lu [MSFT]" <weilu@.online.microsoft.com> schreef in bericht
>> news:J3V2QNplHHA.1140@.TK2MSFTNGHUB02.phx.gbl...
>> Hello Jaap,
>> I sugget you add a new field in the Report Build which calculate the
>> Percentage of the total.
>> And you could format the column to show as the percentage.
>> Hope this helps.
>> Sincerely,
>> Wei Lu
>> Microsoft Online Community Support
>> ==================================================>> When responding to posts, please "Reply to Group" via your newsreader so
>> that others may learn and benefit from your issue.
>> ==================================================>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>|||Hello Jaap,
Yes, you could use, but with some modification.
In the Report Builder, you may Edit the Formula of a cell. And you could
use the IF function and SUM function.
Hope it helps.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello Jaap,
I reproduce this issue.
The SUM(Total Area) only sum the field in the record.
You may need to aggregate the filed in the raw data and regenerate the
report model.
Hope this helps.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||But in general, you don't know what the 100% value is, the denominator,
because you don't know which selections and filters the end user is
creating.
Please, place it on the wishlist to have an option to do a 'percent of
total' formatting.
OK, for some specific situations, you can do it the hardcodes way you
suggested.
Regards,
Jaap
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> schreef in bericht
news:qyvcwjqnHHA.1144@.TK2MSFTNGHUB02.phx.gbl...
> Hello Jaap,
> I reproduce this issue.
> The SUM(Total Area) only sum the field in the record.
> You may need to aggregate the filed in the raw data and regenerate the
> report model.
> Hope this helps.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Hello Jaap,
The Report Builder is a User end report generate tool. It did not include
all the function which Report Designer has.
If you have any funcional request, please send your feedback to the
following url:
http://connect.microsoft.com/sqlserver.
Thank you!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.