InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 20 Jun 2013 02:33:58 GMT20http://www.sqlservercentral.com/Forums/Topic590404-17-1.aspxAlso, if the result set is large. Try using the NON EMPTY clause.Wed, 02 Mar 2011 23:44:07 GMTRaunak Jhawarhttp://www.sqlservercentral.com/Forums/Topic590404-17-1.aspxUsually happens when you have a textual dimension key or selecting on a wide attribute hierarchy with many members.Wed, 02 Mar 2011 07:46:02 GMTbbullard 90070http://www.sqlservercentral.com/Forums/Topic590404-17-1.aspx[b]Problem Description[/b]We are working on one data warehouse project for one of our client. Data warehouse database is in SQL server 2005. Microsoft Analysis service 2005 is used to create a Cube. Microsoft SQL Server 2005 Reporting Services is used as a reporting tool; the data for the reports is being taken from Cube. While generating some high record (600,000 thousands) volume reports through Reporting Services we get the following error message: An error occurred during local report processingAn error has ocurred during report processing .Exception of type 'system.outofmemoryexception'was thrown On executing the MDX query in SQL Server management studio, we get the below error message. Executing the query ...Exception of type 'System.OutOfMemoryException' was thrown.Execution complete We found one fix related msmdsrv.exe through http://forums.microsoft.com/msdn/showpost.aspx?postid=1234336&siteid=1&sb=0&d=1&at=7&ft=11&tf=0&pageid=1This fix resolves the memory consumption of msmdsrv.exe which is used by analysis service. We downloaded this patch from http://support.microsoft.com/default.aspx/kb/933097/ but it was already applied on our servers and still we are facing the same problem. In our case msmdsrv.exe is not consuming more memory but the overall memory consumption on the machine is more. Once you run the report the memory remained on the server is around 1.5 GB. The only solution we found so far is restarting the machine to release the memory. [b]Hardware configuration[/b]Intel (R) XEON (TM) CPU: 2 Quad 4 processorRAM: 8GBHARD DRIVE [b]Software configuration[/b]Windows Server 2003 Standard 64 EditionMicrosoft SQL Server Enterprise Edition (64-bit) [b]Data Size[/b]Data warehouse database size for one month: No of fact tables: 1Number of rows in fact table: 80 MillionNumber of dimension: 26Average records in dimensions: 6,000 thousands1 Dimension containing maximum records: 130,000 thousandsCube database size for one month: 3GBThu, 23 Oct 2008 06:24:25 GMThemant B Hindlekar