SQL Server Performance

Memory issue

Discussion in 'SQL Server 2005 Reporting Services' started by shivi, Aug 10, 2007.

  1. shivi New Member

    I have 2 issues when using reporting services
    1) Intermittently I get memory error
    Event code: 3005
    Event message: An unhandled exception has occurred.
    Event time: 09/08/2007 09:41:49
    Event time (UTC): 09/08/2007 08:41:49
    Event ID: 76cc1d0181964364b3abb9761c358399
    Event sequence: 103
    Event occurrence: 2
    Event detail code: 0

    Application information:
    Application domain: /LM/W3SVC/1/Root/Reports-1-128311221974572623
    Trust level: RosettaMgr
    Application Virtual Path: /Reports
    Application Path: d:MSSQL2005MSSQL.2Reporting ServicesReportManager
    Machine name: londonserver

    Process information:
    Process ID: 3304
    Process name: w3wp.exe
    Account name: NT AUTHORITYNETWORK SERVICE

    Exception information:
    Exception type: AccessViolationException
    Exception message: Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
    2) Some time when I render a report I get the error
    Service Unavailable. ... the web service is not available.
    when I render the report again It doesn't happen.
    Could you please tell me the cause of these issues.
    Thanks,
    shivi


  2. satya Moderator

    For the first one make sure you have upto date tools with latest service packs too, if this happens from a client machine then try to render same using another client's machine.
    For the second one ensure the IIS server has no issues to this service.
  3. dineshasanka Moderator

  4. shivi New Member

    I have the lastest sp - SQL Server 2005 Service Pack 2 installed on my pc and the server as well.. now do I need to reapply the packs on the server and my pc.
    Thanks

Share This Page