SQL Server 2005, Sudden increase of connections - SharePoint 2007
Posted
by CrazyNick
on Stack Overflow
See other posts from Stack Overflow
or by CrazyNick
Published on 2010-03-26T09:02:16Z
Indexed on
2010/03/26
9:03 UTC
Read the original article
Hit count: 631
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?
© Stack Overflow or respective owner
