SQL Server 2005, Sudden increase of connections - SharePoint 2007
- by CrazyNick
We observed that sudden increase of SQL connections during a specific hour, it is a backend of a SharePoint 2007 Farm.
From SharePoint 2007 Perspective:
1. Incremental crawling is scheduled at that time and few of the Timer jobs (normal timer jobs) are scheduled to run every mins / per 10mins.
2. Number of user requests are less.
From SQL Server 2005 Perspective:
1. Transaction log backup is scheduled at that time
2. No other scheduled jobs are running at that time.
so, how to narrow down the issue, what would be causing the sudden SQL connection increase?