Microsoft SharePoint Server 2010 introduces both new databases and databases whose distribution and purpose differs over previous versions of Microsoft SharePoint Products and Technologies. This post details the changes in the Microsoft SharePoint Server 2010 database layer. This section provides information about Shared Service Applications that have a database dependency and is not an exhaustive list of all Shared Service Applications available in Microsoft SharePoint Server 2010. At the time of publication this is not 100% complete.
I was recently asked to look at an issue in which SharePoint would intermittently drop its connection to SQL. Taking the typical course of action, I started looking at the Application Event Logs, Trace (ULS) logs, etc. I noticed in the Application Event Logs event Id 3760 and 5586 occurred every hour on the hour. The initial event Id 3760 indicated authentication issues, the Domain Controllers did not see issue that corresponded to the events reported by SharePoint; Scalable Networking Pack Features, MaxConcurrentAPI, etc.