Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
notalian
Starting Member
8 Posts |
 Posted - 2007-03-27 : 09:36:01
|
| Hello,We run an application in SQL server 2000 that generates a data feed. The end result is out of memory error:XmlPackage Exception: Exception=Exception of type 'System.OutOfMemoryException' was thrown.<br/>System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown. at System.String.GetStringForStringBuilder(String value, Int32 startIndex, Int32 length, Int32 capacity) at System.Text.StringBuilder.GetNewString(String currentString, Int32 requiredLength) at System.Text.StringBuilder.Append(String value) at AspDotNetStorefrontCommon.AppLogic.RunXmlPackage(XmlPackage2 p, Parser UseParser, Customer ThisCustomer, Int32 SkinID, Boolean ReplaceTokens, Boolean WriteExceptionMessage)<br />I have two questions:1)When the feed starts building, memory starts increasing for processes w3wp.exe and sqlsvr.exe which is understandable but is it normal to go from 75,455 k range to over 1 GIG?2)After this error, SQL does not seem to release the memory. It stays at those higher ranges. Is that normal?ThanksNotalian |
|
|
|
|
|
Out of memory exception in SQL 2000