Hi :
We have a setup reporting services for reporting...and our reports are working fine for 100-200 thousand records which is basically 1 year worth of data.
The reporting server fails when it starts processing beyond 200 thousand records...when I check the reporting log I see System outof memory exception. The reporting server has 8GB of ram and its a blade server. I dont know how to solve this issue.
Please let me know where I am doing wrong....
Thanks,
Pramod
Are you sure that SQL Server has not been restricted in how much memory is available for it to use?
Also as a general rule, I try to return as little data in the dataset for RS to process as possible. So it's better to do some GROUP BY clases in your query rather than returning all records and letting RS do the Sums.
|||You'll want to make sure SQL Server is actually "seeing" all 8 gig of ram ... I've seen a lot of admins forget to configure AWE.|||Yep sql server is made available all 7 gb of 8 gb ram...by setting /7gb in boot.ini.|||Yes adam...the RS is after group by of all fields....other wise i would get a million records without group by....
No comments:
Post a Comment