Large report killing server

We have a report that needs to run 2-3 times day that is fairly large.
The need is to have it in Excel format and it is about 20 columns by
7-8,000 rows. The data is returned by the db server fairly readily, but
when Reporting Services tried to make it an Excel file, the render
object on the web front end timesout. I checked the server during this
time and the CPU usage is 100% and memory usage climbs. Is it normal
for RS to choke on a large report like this?Do you have SP1 installed?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"no one" <noone@.yahoo.com> wrote in message
news:420E4351.E3D5A5CA@.yahoo.com...
> We have a report that needs to run 2-3 times day that is fairly large.
> The need is to have it in Excel format and it is about 20 columns by
> 7-8,000 rows. The data is returned by the db server fairly readily, but
> when Reporting Services tried to make it an Excel file, the render
> object on the web front end timesout. I checked the server during this
> time and the CPU usage is 100% and memory usage climbs. Is it normal
> for RS to choke on a large report like this?
>|||SP1 for what? Reporting Services? SQL Server? Win2k?
"Bruce L-C [MVP]" wrote:
> Do you have SP1 installed?
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "no one" <noone@.yahoo.com> wrote in message
> news:420E4351.E3D5A5CA@.yahoo.com...
> > We have a report that needs to run 2-3 times day that is fairly large.
> > The need is to have it in Excel format and it is about 20 columns by
> > 7-8,000 rows. The data is returned by the db server fairly readily, but
> > when Reporting Services tried to make it an Excel file, the render
> > object on the web front end timesout. I checked the server during this
> > time and the CPU usage is 100% and memory usage climbs. Is it normal
> > for RS to choke on a large report like this?
> >|||SP 1 for Reporting Services. Before digging too much more into this I would
suggest installing SP1. Note that you need to install it at the server and
wherever you develop your reports.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"no one" <noone@.yahoo.com> wrote in message
news:420FB123.1423F27A@.yahoo.com...
> SP1 for what? Reporting Services? SQL Server? Win2k?
> "Bruce L-C [MVP]" wrote:
>> Do you have SP1 installed?
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "no one" <noone@.yahoo.com> wrote in message
>> news:420E4351.E3D5A5CA@.yahoo.com...
>> > We have a report that needs to run 2-3 times day that is fairly large.
>> > The need is to have it in Excel format and it is about 20 columns by
>> > 7-8,000 rows. The data is returned by the db server fairly readily,
>> > but
>> > when Reporting Services tried to make it an Excel file, the render
>> > object on the web front end timesout. I checked the server during this
>> > time and the CPU usage is 100% and memory usage climbs. Is it normal
>> > for RS to choke on a large report like this?
>> >
>|||The server guys tell me they installed it at most 6 weeks ago. Did SP1 come out
after that?
"Bruce L-C [MVP]" wrote:
> SP 1 for Reporting Services. Before digging too much more into this I would
> suggest installing SP1. Note that you need to install it at the server and
> wherever you develop your reports.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "no one" <noone@.yahoo.com> wrote in message
> news:420FB123.1423F27A@.yahoo.com...
> > SP1 for what? Reporting Services? SQL Server? Win2k?
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Do you have SP1 installed?
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "no one" <noone@.yahoo.com> wrote in message
> >> news:420E4351.E3D5A5CA@.yahoo.com...
> >> > We have a report that needs to run 2-3 times day that is fairly large.
> >> > The need is to have it in Excel format and it is about 20 columns by
> >> > 7-8,000 rows. The data is returned by the db server fairly readily,
> >> > but
> >> > when Reporting Services tried to make it an Excel file, the render
> >> > object on the web front end timesout. I checked the server during this
> >> > time and the CPU usage is 100% and memory usage climbs. Is it normal
> >> > for RS to choke on a large report like this?
> >> >
> >|||No, SP1 is older than 6 weeks, but it included some fixes for rendering in
Excel that sound like what your problem is.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"no one" <noone@.yahoo.com> wrote in message
news:42100F1E.8F4DD308@.yahoo.com...
> The server guys tell me they installed it at most 6 weeks ago. Did SP1
> come out
> after that?
> "Bruce L-C [MVP]" wrote:
>> SP 1 for Reporting Services. Before digging too much more into this I
>> would
>> suggest installing SP1. Note that you need to install it at the server
>> and
>> wherever you develop your reports.
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "no one" <noone@.yahoo.com> wrote in message
>> news:420FB123.1423F27A@.yahoo.com...
>> > SP1 for what? Reporting Services? SQL Server? Win2k?
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> Do you have SP1 installed?
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "no one" <noone@.yahoo.com> wrote in message
>> >> news:420E4351.E3D5A5CA@.yahoo.com...
>> >> > We have a report that needs to run 2-3 times day that is fairly
>> >> > large.
>> >> > The need is to have it in Excel format and it is about 20 columns by
>> >> > 7-8,000 rows. The data is returned by the db server fairly readily,
>> >> > but
>> >> > when Reporting Services tried to make it an Excel file, the render
>> >> > object on the web front end timesout. I checked the server during
>> >> > this
>> >> > time and the CPU usage is 100% and memory usage climbs. Is it
>> >> > normal
>> >> > for RS to choke on a large report like this?
>> >> >
>> >
>|||Go to http://yourserver/Reportserver
It should show version 8.00.878.00 if you have SP1 installed.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"no one" <noone@.yahoo.com> wrote in message
news:42100F1E.8F4DD308@.yahoo.com...
> The server guys tell me they installed it at most 6 weeks ago. Did SP1
come out
> after that?
> "Bruce L-C [MVP]" wrote:
> > SP 1 for Reporting Services. Before digging too much more into this I
would
> > suggest installing SP1. Note that you need to install it at the server
and
> > wherever you develop your reports.
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "no one" <noone@.yahoo.com> wrote in message
> > news:420FB123.1423F27A@.yahoo.com...
> > > SP1 for what? Reporting Services? SQL Server? Win2k?
> > >
> > > "Bruce L-C [MVP]" wrote:
> > >
> > >> Do you have SP1 installed?
> > >>
> > >> --
> > >> Bruce Loehle-Conger
> > >> MVP SQL Server Reporting Services
> > >>
> > >> "no one" <noone@.yahoo.com> wrote in message
> > >> news:420E4351.E3D5A5CA@.yahoo.com...
> > >> > We have a report that needs to run 2-3 times day that is fairly
large.
> > >> > The need is to have it in Excel format and it is about 20 columns
by
> > >> > 7-8,000 rows. The data is returned by the db server fairly
readily,
> > >> > but
> > >> > when Reporting Services tried to make it an Excel file, the render
> > >> > object on the web front end timesout. I checked the server during
this
> > >> > time and the CPU usage is 100% and memory usage climbs. Is it
normal
> > >> > for RS to choke on a large report like this?
> > >> >
> > >
>|||Bruce L-C [MVP] wrote:
> Go to http://yourserver/Reportserver
> It should show version 8.00.878.00 if you have SP1 installed.
>
Since I have control of our Dev box, I checked it as well. It did not
have SP1. I downloaded and installed. The report still chokes the
server while trying to render with 100% CPU and memory usage climbing
about actual RAM (on this box it is only 512 MB). Looks like the SP
didn't help.|||As an experiment / workaround try rendering as CSV. If that works then that
can be loaded into Excel. It is possible that SP2 might make a difference
but I don't know.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Bryon" <blape@.whittmanhart.com> wrote in message
news:O3VThA4EFHA.2756@.TK2MSFTNGP15.phx.gbl...
> Bruce L-C [MVP] wrote:
> > Go to http://yourserver/Reportserver
> >
> > It should show version 8.00.878.00 if you have SP1 installed.
> >
> >
> Since I have control of our Dev box, I checked it as well. It did not
> have SP1. I downloaded and installed. The report still chokes the
> server while trying to render with 100% CPU and memory usage climbing
> about actual RAM (on this box it is only 512 MB). Looks like the SP
> didn't help.|||Bruce L-C [MVP] wrote:
> As an experiment / workaround try rendering as CSV. If that works then that
> can be loaded into Excel. It is possible that SP2 might make a difference
> but I don't know.
>
sp2?|||SP2 is supposed to be release before too long (Feb/March). It is always
possible that they have put in somemore Excel rendering improvements.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Bryon" <blape@.whittmanhart.com> wrote in message
news:eOTLcE5EFHA.2456@.TK2MSFTNGP10.phx.gbl...
> Bruce L-C [MVP] wrote:
> > As an experiment / workaround try rendering as CSV. If that works then
that
> > can be loaded into Excel. It is possible that SP2 might make a
difference
> > but I don't know.
> >
> sp2?