?? ????? ????? ????? "System.OutOfMemoryException" ??? ??????? "????? SQL Server ???????"

?????? ????????? ?????? ?????????
???? ???????: 909678 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

???????

??? ??????? "????? Microsoft SQL Server 2000 ???????" ?? ??????? Microsoft SQL Server 2005 ??????? Services ? ?? ????? ????? ????? ???????:

??? ??? ????? ?? ?????? ???????.
???? ??? ??????? ?????? ??? ???? ?? ????????. (rsInternalError) ?????? ??? ??????? ??? ??????
?? ??? System.OutOfMemoryException ??????? ???.
???????? ??? ???? ?? ????? ?? ??? ????? ????? ????? ??????? ?? ??? ??? "????? SQL Server ???????" ?? ????? ????? ????:

System.OutOfMemoryException: ??????? ??? System.OutOfMemoryException ?? ???.
?? ????? ????? ??? ??????? ??????? ?? ??? ????? Windows Microsoft:

??? 1


????? aspnet_wp.exe (???? ???????: <PIDNumber>) ?? ????? ??????? ???? ????? ??????? ??????? ?? <SizeLimit> ???????? (<Percentage> ?????? ??????? ?? RAM ????????).

??????? 2


????? ???? ???? ????????? 'DefaultAppPool' suffered ??? ???? ????? ?? "???? ??? ???". ??? ????? ??????? '9132'. ????? ??? ???????? ??? ??? ?????.

?? ???? ??? ??????? ?? ???? ?? ???? ?? ??????? ???????:
  • ??? ?????? ??? ????? ??? ?????? ???????.
  • ???? ????? ?? ?????????.
  • ??? ?????? ??? ????? ??? ??? ???? ?????.
  • ???? ????? ????? ???????:

    ????? ??????? ???????
  • ?? ??? ????? ??????????.

?????

???? ??? ??????? ???? ??? ??? ????????? ????? ????? ?????? ??????? ????????.

???? ???? ???? ?? "????? SQL Server 2000 ????????" ????? ????? ?? ?????? ???? ??????? ???? ?? ??? ???????. ??? ???? ??????? ?????? ????? ????????? ??????? ???? ?????? ?? ??????? ????.

??? ??? ????????? ????? ????? ?????? ??????? ???????? ??? ???? ?? ???? ?? ??????? ???????:
  • ????? ???? ???? ?? ???? ????.
  • ??? ???????? ??? ??????? ?????? ????.
  • ??????? ??????? ????????? ?????? ???? ????.
??? ?????? ????? ?? ??????? ?????. ????? ????? ???? ????? ???????. ???? ?? ???? ??? ??????? ????? ????? ??????? ?? ????? ????? ???????.

?? ???? ???? ??? ??????? ????? ????? ??????? ???? ??? ??????? ?????? ???? ????????? ????? ???? ?? ????? ??? ???????? ???? ??? ??????? ?? ????? ?????????. ???????? ??? ???? ???? ??????? ??????? ??????? ??????? ????? ????? ???????:
  • ???????
  • ?????
  • ???????
  • ?????
  • ??????? ?????? ?????
?? ???? ???? ??? ??????? ????? ????? ??????? ????? ????? ?? ?? ????????? ???? ??????? ? ??? ???? ??????? ?????????. ??? ???? ??????? ??????? ??????? ???? ??????? ??????? ????? ????? ???????:
  • "???" ? "????? ????? ??????
  • ??????? ??? ????? ??????
  • ???????
  • ????? ???????? ???? ??? ?????
????? ?? ????????? ??? ?????? "??????? ?????" ?? ?????? ???? ???? ????? Microsoft (MSDN) ?????? ??? ?????:
http://msdn2.microsoft.com/en-us/library/aa179471(SQL.80).aspx

????

??? ??? ???????? ?????? ???? ????? ???????.

??????? ??????

????? ????? ?? ??????? ??????? ??? ?????????.

?????? ??? ??? ???? ???? ?? ? ???????? (GB) ?? ??????? ???? ??????? / 3 GB ??????? ?? ????? Boot.ini ?????? ??? ???? ????. ?????? ??? ???? ?? ????????? ??? ????? ??????? ??? ???????/3 GB ?? SQL Server "? ???? ??? ??? ??????? ?????? ?????? ??" ????? ??????? ?? Microsoft:
274750????? ????? SQL Server ??????? ???? ?? ? ???????? ?? ??????? ???????

??????? ???????

?????? ???? ??????? off-hours ????? ???? ?????? ????? ???.

??????? ???????

??? MemoryLimit ????? ????? ????.

?????? ??? ????? ????? ??? "????? ??? ???????" ???? "??????? ?? ????? ???" ???? ?????? ??? ??????? MemoryLimit ?? ????? Machine.config. ??? ???? ??? ????? ????? ?????? ?????? ???? Windows Server ?????. Windows Server ????? ???? ?????? ??????? MemoryLimit ?? ??? RSReportServer.config.

?????? ??? ???? ?? ????????? ??? ????? MemoryLimit ???? ??? "???? ?? ?????????".

??????? ???????

??????? ??? ????? 64-?? ?? Microsoft SQL Server 2005 ??????? Services.

??????? ???????

????? ????? ???????. ?????? ????? ?????? ???? ????? ???????.

??????? ?

????? ????? ??????????? ???????. ????? ????? ??????? ??????? redesigning ????????? ????? ?????? ???????:
  • ????? ??? ?????? ?? ????????? ???????.
  • ??????? ????? ???? ??? ???? WHERE ?? ??????????? ???????.
  • ??? ???? ????????? ??? ???? ????????.

??????? ?

????? ??????? ??? ????? ???. ????? ????? ??????? ??????? ???????? ????? ????? ???? ???????. ???? ?????? ?????? ??? ?????? ?? ??????? ??????? ???????? ?? ??????? ??????? ???? ??? ??????? ??????? ??? ?????.
?? ??? ??????????? ??? ??????
????????
Microsoft Excel???? ????? ?? Excel
???? (TIFF)???? ????? ????? ????? ?? ????? ????? ??? ??????
pdf???? ????? ?? "????? ??????? ???????" (PDF)
html???? ??????? ?? HTML ??? ??????
csv???? ????? ?????? ??????? ??????; ??? ??????? ?? ???? ??? ???????? ??????? ??? CSV
xml???? ????? ?? XML; ??? ??????? ?? ??????
?????? ??? ?? ??? ????? ????? XSLT ??? ?????? ??? ??????? ????? ??? ?? ?????? ????? CSV.

????? C

????? ????? ???????. ????? ????? ??????? ??????? ????? ????? ??????? ?????? ???????:
  • ????? ????? ?????? ??? ?? ????? ?????? ?? ???????.
  • ??????? ????? drillthrough ???? ????????.
???????? ??? ???? ??? ??? ??? ??????? ????? ???????? ???, ????? ??????? ?????? Microsoft ?????? ?????? ??? ???? ????. ??? ???? ??????? ????? ??????? ????? ????? ???????? (DTS) ?? Microsoft SQL Server 2005 ????? Services.

??????

???? ?????? ?????? ????? ?? ??? ???????. ?? ???? ???????? ?????? ??????:
  • ????? ????? ????? ????? ????? 160 ?? "????? ???????? ?? ????? PDF ? ?? ????? Excel. ?? ?????? ??????? ???? ??????? 250 ??? ??????? ??? ???? 8.5-??? - 11 ????.
  • ????? ???? ???????? ??????? 500 ???? ???? ?? ???????? ??? ???? ???????. ?????? ????? "????? SQL Server 2000 ????????" ???? ???? ????? ??????? ????????? ?? ??? ???? ?????. ????? ????? "????? SQL Server 2000 ????????" ??????? 1.5 ???????? ?? ??????? ????? ???????.
??? ??? ??????? ?? ??? ?????? ????? ????? ??????? ???? ???? ??????? ?????? ??????? ??? ?? ??? ?????? ?????? ?? ??? ???? ???????. ???????? ??? ???? ???? ?? ?? ???? ??????? ?? ??????? ????? ???????? ???? ???? ?????? ????? ?? ??????? ??? ????? ????. ????? ??? ????? ????? ???? ???????? ???? ??? ??????? ??? ?????? ???????. ????? ??? ????? ??????? ????? ? ????? ????.

??????? ????

??? ??????? "????? SQL Server 2000 ????????" ?? ????? ????? ????? ??????? ???? ???? ??? ?????? ????? ???????:
  • ???? ??? System.OutOfMemoryException.
  • ?????? ??? ???? ?????? ???????.
???????? ??????? ??? ?????? ????? ?? ????? ???? ?????? ??? ?????? ???? ????????.

??? System.OutOfMemoryException ?? ??? ???? ??? ??? ?????? "????? SQL Server 2000 ????????" ??? ????? ??? ?????? ?? ??????? ?? ?????? ? ????? ??? ?????? ????? ???????. ??? ??? ???? ??? ?????? "????? SQL Server 2000 ????????" ????? ??????? ?????? ??? ????. ????? ??????? ??? ??? ??? "????? SQL Server 2000 ????????" ??????? ??????? ??? ??????? ??? ???????. ????? ?? ???? "????? SQL Server 2000 ????????" ???? ?? ???? ???? ???? ????? ????????.

???? ??????? ?????? ?? ??????? ???????? ??? ????? ?????? ?? ??????? ?? ???? destabilizing ??????. ??? ???? ??????? ?????? ??????? ???? ???????? ?? ??? ???? ????? ?? ??????? ????? ???? ?? ?????. ??? ????? ?????? ?????? ??????? ???? ????? MemoryLimit ??? ???? ??????? MaximumMemoryLimit ???? ?? ??????? ?? ??? RSReportServer.config. ??? ?????? ??? ???? ?????? ???????, ??? ????? ????? ????? ?????? Microsoft .NET Framework ??? "????? SQL Server 2000 ????????" ?????? ???? ???????.

???? ????? ????? ?? ???? ??? ?? ?? ???? ??????. ????? ?? ???? ??????? ??? ?? ????? ?????? ????? ?? "????? SQL Server 2000 ????????". ??????? ?? ???????:
  • ???? "??????? ?? ????? ???"
  • ????? Windows Server ?????
????? ??????? ??????? ?? ?????? ????? ??? ????? ??????.

??? System.OutOfMemoryException ??????? ??????? ????? ???

??? ????? ????? ????????? ?????? ????? ??????? ???? ???? ??????? ??????? ?? ??? ??? "????? SQL Server 2000 ????????" (ReportServerService_ <timestamp>.log):

w3wp! ?????! 1b3c! ?? ????? ????-10:38:00:: ????? ???: ?????? ??? System.OutOfMemoryException ?????????: Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException: ??????? ??? ?? ??? Microsoft.ReportingServices.ReportRendering.ReportRenderingException. ---> Microsoft.ReportingServices.ReportRendering.ReportRenderingException: ??????? ??? ?? ??? Microsoft.ReportingServices.ReportRendering.ReportRenderingException. ---> System.OutOfMemoryException: ??????? ??? ?? ??? System.OutOfMemoryException.

w3wp! ?????! 1b3c! ?? ????? ????-10:38:00:: ????? ???: ????? ????? ??????
?????? ?????????? ReportServerService_ <timestamp> ??? .log ?? ?????? ??????:
Server\ SQL \Microsoft <Instance of SQL Server> \Reporting Services\LogFiles
???????? ??? ???? ??? ????? ????? ?????? ????? ?????? ?? ??? ???????:


??? ?????: ?????
???? ?????: W3SVC
??? ?????: ???
????? ?????: 1011
?????: Date
?????: Time
????????: N/A
???? ?????????: ComputerName
?????:
????? ???? ???? ????????? 'DefaultAppPool' suffered ??? ???? ????? ?? "???? ??? ???". ??? ????? ??????? '9132'. ????? ??? ???????? ??? ??? ?????.

????? ??? "????? SQL Server 2000 ????????" ?????? ??? ????? ?????. ???? "??????? ?? ????? ???" catches ????????? ?????? ???????. ??? ????? ????? ?????.

??? ??? ???????? ????? ????? ??????? ??????? ???? ??? ?????? ?? ????? ??????? ??????? ???????? ??????.

????????? ????? ??? ????? MemoryLimit ?? ????? ????????? ?? Microsoft ????? ??????? ?????? (IIS) 6.0 ???? ??? ??? ??? ??? ???? ???? ???? ???????. ????? ??????? ??? ??????? ?? ?????? ?????. ??? ?? ?????? ????????? ??? ???? ?? ???? ?????? ??? ???? ????? ??? ???? ??????? ?????.

???? "??????? ?? ????? ???" ????? ???????

??? ????? ????? ?? ??? ????? Windows ??? ??? ????? "????? SQL Server 2000 ????????". ???? ??? ??? ???? "??? ?????? ???????" ??? ????? ???????. ??? ????? ?? ???? ?? ????? ?? ????? ??????? ????? SQL Server 2000 ???????? ??? ?? ???? ????? ??????? ??? ????? ???????.

?? ????? ????? ??? ??????? ??????? ?? ??? ???????:

??? 1


????? aspnet_wp.exe (???? ???????: <PIDNumber>) ?? ????? ??????? ???? ????? ??????? ??????? ?? <SizeLimit> ???????? (<Percentage> ?????? ??????? ?? RAM ????????).

??????? 2


???? ????? ????? ??? ????? ??????? '2420' ????? ???? ????????? 'DefaultAppPool' ??????? ????? ???? ?????? ??????? ????????.

??? ?????? ??? ???? ?????? ??????? ? Microsoft ASP.NET ?? IIS 6.0 ?????? ??? ????? ?? ????? ????? ???? "??????? ?? ????? ???. ???? ??????? ?????? ASP.NET ?? ?????? IIS 6.0 ???? ??????? ?? ??? ?????? ???? ?? ??? "????? SQL Server 2000 ????????".

????? ????? ???? ??????? ??? <processmodel> ?????? ?? ????? Machine.config.

?????? ??? ??? ???? ?????? IIS 6.0 ?? ????? ?????? Machine.config ??????? ?????. ??? ?????? ??? ???? ??????? ?? ????? ???? ????????? ?? IIS 6.0.

????? ?? ????????? ??? ????? ??????? ?? ASP.NET ? ?? IIS 6.0 ?????? ????? ??? MSDN ??????:

????? Windows Server ????? ?????? System.OutOfMemoryException

?? ??? ??????? ??? ??? ????? ???????? ?? ??????? ??? ????????? ???? ?? ???????? ???. ??? ????? ??????? ????? ????? ????? ???????? ? ????? ??????? ????? ???????? ??? ??? ???? ???? ?? ????? ?????????. ??? ????? ????? ??? ?????? ?? ?????? ????? ????????? ?? ??? ??? "????? SQL Server 2000 ????????":

ReportingServicesService! ?????! 618! 7/9/2003-16: 06: 01:: ??????: ???: ??????? ??? ?? ??? System.OutOfMemoryException.
ReportingServicesService! ???????! 618! 7/9/2003-16: 06: 01:: ??? ??? ?????? ???? ???????: System.OutOfMemoryException: ??????? ??? ?? ??? System.OutOfMemoryException.
ReportingServicesService! ???????! 618! 7/9/2003-16: 06: 01:: ????? 380e6cd2-3e3d-4549-9ed5-9fb6b42266b6 ?????. ??? ??????: ? ??????: ???: ??????? ??? ?? ??? System.OutOfMemoryException. ? DeliveryExtension: ????? Server ?????????? ? ?????: ?????? ?????? 0
ReportingServicesService! dbpolling! 618! 7/9/2003-16: 06: 01:: NotificationPolling ?????? ?????? ?????? 380e6cd2-3e3d-4549-9ed5-9fb6b42266b6
ReportingServicesService! servicecontroller! 568! 7/9/2003-16: 09: 30:: i INFO: ??????? ??? ??????? ?????? ????????? ????????
ReportingServicesService! servicecontroller! 568! 7/9/2003-16: 09: 30:: i INFO: ????? ?????? ?? ?????? ?????????
ReportingServicesService! dbpolling! 568! 7/9/2003-16: 09: 30:: EventPolling ???????? ????? ????
ReportingServicesService! dbpolling! 87 c! 7/9/2003-16: 09: 30:: EventPolling ???? ????? ????? ????? ?????? ??????.
ReportingServicesService! dbpolling! 568! 7/9/2003-16: 09: 30:: ????? ???? NotificationPolling ?????????
ReportingServicesService! dbpolling! 880! 7/9/2003-16: 09: 30:: ???? ????? ????? NotificationPolling ????? ?????? ??????.
ReportingServicesService! dbpolling! 568! 7/9/2003-16: 09: 30:: SchedulePolling ???????? ????? ????
????? Windows Server ????? catches ????????? ?????? ???????. ??? ??? ????? ??? ???? ??? ?? ????? ???? ??? ????????.

?? ????? ????? ??? ??????? ??? ??? ???????. ????? ??? ??????? ?????? ????? ??????? ??? ????????? ????? ?????? ??????? ??????? ???????? ??????.

??? ??? ???????? ????? ????? ??????? ??????? ???? ??? ????????? ?? ????? ??????? ??????? ???????? ??????.

????? Windows Server ????? ????? ???????

?? ??? ??????? ??? ??? ????? ???????? ?? ??????? ??? ????????? ???? ?? ???????? ???. ??????? ?????? ?? ???????? ??? ???? "????? ???? ???????". ??? ??? ????? ??????? ???? ?????? ?? ?????? ????? ????????? ?? ??? ??? "????? SQL Server 2000 ????????":

ReportingServicesService! reportrendering! 17a8! 09/28/2005-16: 10: 12:: ????? ???: ??? Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException: ??????? ??? ?? ??? Microsoft.ReportingServices.ReportRendering.ReportRenderingException. ?; ???????: Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException: ??????? ??? ?? ??? Microsoft.ReportingServices.ReportRendering.ReportRenderingException. ---> Microsoft.ReportingServices.ReportRendering.ReportRenderingException: ??????? ??? ?? ??? Microsoft.ReportingServices.ReportRendering.ReportRenderingException. ---> System.Threading.ThreadAbortException: ????? ???? ???????.
ReportingServicesService! runningjobs! 17a8! 09/28/2005-16: 10: 12:: I INFO: CancelableJobExecution.Execute ?????? ??? ?????? ????????? ????? ???? ???????
ReportingServicesService! ?????! 17a8! 09/28/2005-16: 10: 12:: i INFO: ????? EnableExecutionLogging ??? '????' ?? ??????? ?? ????? ?????? Server.
ReportingServicesService! runningjobs! 1810! 09/28/2005-16: 10: 12:: i INFO: CancelableJobExecution.Execute ?????? ??? ?????? ????????? ????? ???? ???????
ReportingServicesService! ?????! 1810! 09/28/2005-16: 10: 12:: i INFO: ????? EnableExecutionLogging ??? '????' ?? ??????? ?? ????? ?????? Server.
ReportingServicesService! dbpolling! 1810! 09/28/2005-16: 10: 12:: ??? requeued NotificationPolling ?? ??? ?????? fc 6e786bb5-3e4d-462a-92 ?????? - 2942e6aec007 ?
ReportingServicesService! dbpolling! 1810! 09/28/2005-16: 10: 12:: ???? ????? ???? ?? ????? ?????? ?????? ??????? ??? ??????: System.Threading.ThreadAbortException: ????? ???? ???????.
?? Microsoft.ReportingServices.Library.NotificationQueueWorker.HandleNotification(QueueItem item)
?? Microsoft.ReportingServices.Library.NotificationQueueWorker.QueueWorker(QueueItem item)
?? Microsoft.ReportingServices.Library.QueuePollWorker.WorkItemStart (???? ????)
?????? ???? ??? ??????? ?????? ??? abrupt ??? ??? ?????.

????? ????? Windows Server ????? ????? ????? ??????. ???????? ??? ???? ????? ???? Windows Server ????? ??????? ??????? ?????? ?? ?????? ?? ?? ????? ???????? ?? ?????? ???? ???????. ??? ????? ???????? ?? ?????? ???? ??????? ? ???? ???? Windows Server ????? ???????. Windows Server ????? ???? ??? ???????? ???? ??????? ?? ????? ???? ??? ?????. ??? ????? ????? ???? Windows Server ????? ????? Windows Server ????? ????? ????? ?????? ??? ????.

???? ????????? ????? ?? ??? RSReportServer.config ??? ????? ???????. ??????? ????? ??? ????? MaximumMemoryLimit ?????? MemoryLimit ?? <service> ???????.

???? ??? ????? ???? ??????? ???????. ??? ??? ??????? ??????? ????? ?????? ??? ?????? ??????? ???? ?????? ?????? ??????? MemoryLimit ??? ????? ????? Windows Server ????? ??? ????? ??????. ??? ???? ????? ??????? ??? ?????? ??????. ??? ???? ????? ????? ??? ???? ??? ????? ??? ??? ?? ?????? ??????? ???? ?????? ?????? ??????? MemoryLimit.

??? ??? ??????? ??????? ????? ?????? ??? ?????? ??????? ???? ?????? ?????? ??????? MaximumMemoryLimit ??? ??? ????? ???? ??????? ?????? ???????.

??? ????????? ????? ???? ??????? ??? <processmodel> ?????? ?? ????? Machine.config ?????? ???? ??????? ???? ????. ???? ??? ????????? ??????????? ??????? ??? ???? ??? ????? ???????? "?" ???? Windows Server ?????.

?????

????? ?? ?????????? ???? ???????? ??????? ?? SQL Server ????????:
  • ????? ????? ?????? ????? drillthrough (????? ????)
  • ????? ??????
  • ??? ??????? RSReportServer
  • ????? ???????? ????? ?????? ???????

???????

???? ???????: 909678 - ????? ??? ??????: 07/?? ?????/1430 - ??????: 3.0
????? ???
  • Microsoft SQL Server 2000 Reporting Services
  • Microsoft SQL Server 2005 Reporting Services
????? ??????: 
kbmt kbexpertiseadvanced kbprb KB909678 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????909678

????? ???????

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com