Recently upgraded SQL Server 2005 x64 to SP2 and upto Build 3159. Since then the Maintenance Plan for Index Reorgs has failed with a System.OutOfMemoryException error. No other errors are logged anywhere. The plan report file has no information either.
Has anybody come across a similar issue?
Thank you.
Hi. Yes, we are getting the same error message. Anyone have any ideas on how to fix it?|||I haven't got around to debugging this but believe something in .NET of course is running into a memory limitation.For now, I have stopped using the maintenance plan and have scripted the Index Reorg process.
No comments:
Post a Comment