The online help states under ther Report Server Execution Log the following
description for the Retrieve, Process, Render counters:
"Percentage of time spent retrieving the data, processing the report, and
rendering the report."
Shouldn't the three numbers added together match to 100%? What units are
these values depicted in?
In order to calculate duration in seconds I have taken the datediff in
seconds between starttime and endtime. I would assume there is a way to
calculate percent of time for retrieval, processing and rendering from this
value. Is this correct?
--
Thanks in Advance,
John KThis is a bug in the documentation. Thanks for pointing this out.
The values represent milli seconds and not percentage.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"John K" <JohnK@.discussions.microsoft.com> wrote in message
news:2CF19C95-BCCA-454D-BF31-F624215B4A6D@.microsoft.com...
> The online help states under ther Report Server Execution Log the
> following
> description for the Retrieve, Process, Render counters:
> "Percentage of time spent retrieving the data, processing the report, and
> rendering the report."
> Shouldn't the three numbers added together match to 100%? What units are
> these values depicted in?
> In order to calculate duration in seconds I have taken the datediff in
> seconds between starttime and endtime. I would assume there is a way to
> calculate percent of time for retrieval, processing and rendering from
> this
> value. Is this correct?
>
> --
> Thanks in Advance,
> John K
Showing posts with label online. Show all posts
Showing posts with label online. Show all posts
Wednesday, March 7, 2012
Saturday, February 25, 2012
Report Server Email Delivery setup
I have Report Server setup and I want to add email delivery functionality.
According to Books Online, to configure a Report Server for email delivery
only the following is necessary in RSReportServer.config:
1) SMTPServer - Note I entered just the mail/smtp server host name, not
fully qualified, not a UNC name...just the servername (i.e: Server1). The
values section of the help info says the entry can be "an ip address, a DNS
resolvable name or the name of the computer hosting the SMTP service. I chose
the latter.
2) SMTPAccountName
I added both the above settings, but under "New Subscription" only "Report
Server file share" shows up under "Delivered By". I restarted the Report mgr
service and iisreset.
What's missing?Under C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\RSReportServer.config
<Extension Name="Report Server Email" ... >
<Configuration>
<RSEmailDPConfiguration>
<From>Type and Email ID Here</From>
Once you add some email id over here which is from email then you will be
able to see the Email Delivery option
"pdx" wrote:
> I have Report Server setup and I want to add email delivery functionality.
> According to Books Online, to configure a Report Server for email delivery
> only the following is necessary in RSReportServer.config:
> 1) SMTPServer - Note I entered just the mail/smtp server host name, not
> fully qualified, not a UNC name...just the servername (i.e: Server1). The
> values section of the help info says the entry can be "an ip address, a DNS
> resolvable name or the name of the computer hosting the SMTP service. I chose
> the latter.
> 2) SMTPAccountName
> I added both the above settings, but under "New Subscription" only "Report
> Server file share" shows up under "Delivered By". I restarted the Report mgr
> service and iisreset.
> What's missing?
According to Books Online, to configure a Report Server for email delivery
only the following is necessary in RSReportServer.config:
1) SMTPServer - Note I entered just the mail/smtp server host name, not
fully qualified, not a UNC name...just the servername (i.e: Server1). The
values section of the help info says the entry can be "an ip address, a DNS
resolvable name or the name of the computer hosting the SMTP service. I chose
the latter.
2) SMTPAccountName
I added both the above settings, but under "New Subscription" only "Report
Server file share" shows up under "Delivered By". I restarted the Report mgr
service and iisreset.
What's missing?Under C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\RSReportServer.config
<Extension Name="Report Server Email" ... >
<Configuration>
<RSEmailDPConfiguration>
<From>Type and Email ID Here</From>
Once you add some email id over here which is from email then you will be
able to see the Email Delivery option
"pdx" wrote:
> I have Report Server setup and I want to add email delivery functionality.
> According to Books Online, to configure a Report Server for email delivery
> only the following is necessary in RSReportServer.config:
> 1) SMTPServer - Note I entered just the mail/smtp server host name, not
> fully qualified, not a UNC name...just the servername (i.e: Server1). The
> values section of the help info says the entry can be "an ip address, a DNS
> resolvable name or the name of the computer hosting the SMTP service. I chose
> the latter.
> 2) SMTPAccountName
> I added both the above settings, but under "New Subscription" only "Report
> Server file share" shows up under "Delivered By". I restarted the Report mgr
> service and iisreset.
> What's missing?
Subscribe to:
Posts (Atom)