| Groups | Blog | Home |
sql server reporting services : Large report killing server
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 [quoted text, click to view] "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?
[quoted text, click to view] "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 [quoted text, click to view] "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? [quoted text, click to view] "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 [quoted text, click to view] "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? > > >> > > > > >
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 [quoted text, click to view] "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? >> >> > >> > >
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 [quoted text, click to view] "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.
[quoted text, click to view]
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
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 [quoted text, click to view] "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?
[quoted text, click to view]
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. >
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |