February 17, 2011 at 12:18 pm
Hi, I have build a new Win 2008 R2 server with SQL 2008 R2 edition on a 64-bit platform with 8GB ram. Restored my DB yesterday and deployed reports. The next morning I found that the server has used 98% of the memory. With this I also found that my reports bombed out with HTTP 503 errors. Eventually restarted the SQL services and memory was restored to normal. My original SQL Server memory configuration was min 1024MB and max 7168MB. After reading a few post I changed the memory configuration to min 0MB and max 5120. This was done while the server again peaked with its memory usage. After applying the 5120MB max memory the resource monitor shows the memory releasing and it freeded up 2GB ram. Later that same day I started running a large report that extract 144 excel sheets with some VB code and reporting services and the resportingservices.exe service started eating up the server memory until 0MB left and then the my reports stopped. Event log error below:
Date2011/02/17 05:28:55 PM
LogWindows NT (Application)
SourceASP.NET 2.0.50727.0
CategoryWeb Event
Event2147484957
ComputerRDSDBNSQL01.rds-sa.local
Message
Event code: 3005
Event message: An unhandled exception has occurred.
Could anyone please help me as this has now been hasling me for the last 2 days and I can not get this memory settings configured 100%.
Many thanks
Adrian
February 17, 2011 at 2:47 pm
Posted in wrong forum/topic...might want to repost or request moderator to move it.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
February 18, 2011 at 12:58 am
Hi all, can someone please help me move this question to the correctgroup. I need some urgent replies and help.
Many thanks
Adrian
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply