When using SQL 2008 or SQL 2008 R2, I/NET will crash randomly. Referring to the system Event Log, you can see a SQL error happened just before I/NET crashed, called "There is insufficient system memory in resource pool 'internal' to run this query."
TAC I/NET, SmartStruxure Solution
According to Microsoft Knowledge Base, this problem occurs for all the following reasons:
- There is a bug in the code that is used to evaluate how many rowsets are required to perform a sorting operation. Therefore, the code greatly overestimates the numbers of rowsets. The required grant estimate in full-text is 64 pages for each rowset that is required to sort.
- There is a large request that blocks the system from using the memory that is reserved for the full-text query.
Install the newest SP to the SQL 2008 or SQL 2008 R2 being used. You can download Microsoft SQL Server 2008 SP3 Express Edition from here or Microsoft SQL Server 2008 R2 SP2 Express Edition from here.
If this doesn't help, please follow Lessons Learned Article LL#15446 to turn on error log for I/NET and send them to PSS for further troubleshooting.