SharePoint Thoughts

After Installing Microsoft Office SharePoint Server, the referenced SQL Server starts consistently dumping memory to the hard disk, and filling up the error logs with stack traces. Some symptoms of this before you check the SQL Server Error Logs may be,

• Backups Not Completing
• No Search Results Appearing
• Generally Slow Performance on the Site
   

This is remedied by installing the most recent Service Pack for SQL Server 2005. My theory is that some of the operations in MOSS with SP1 applied may cause illegal operations within SQL Server, but that’s not confirmed by any means. By Applying the patch, and restarting, this should fix the error.