SQL Server 2005, Sudden increase of connections - SharePoint 2007

Posted by CrazyNick on Server Fault See other posts from Server Fault or by CrazyNick
Published on 2010-03-26T09:02:16Z Indexed on 2010/03/26 13:03 UTC
Read the original article Hit count: 663

Filed under:

moss

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?

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: 663

Filed under:

sharepoint

|

sharepoint2007

|

sql-server

|

sql-server-2005

|

moss

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?

SQL Server 2005, Sudden increase of connections - SharePoint 2007

Posted by CrazyNick on Server Fault See other posts from Server Fault or by CrazyNick
Published on 2010-03-26T09:04:03Z Indexed on 2010/03/26 9:13 UTC
Read the original article Hit count: 663

Filed under:

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?

Developer IT