Showing posts with label online. Show all posts
Showing posts with label online. Show all posts

Wednesday, March 7, 2012

Report Server Execution Log (Retrieve, Process, Render

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

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?