High traffic between sharepoint and database

Hi guys

Our sharepoint 2010 farm have 8 WFEs,  2 Apps and DB runs on clustering. The traffic between WFE, APP and Database Server is so high. How to investigate what factors causes this phenomenon?  

Thank you very much for any suggestion!

August 18th, 2015 3:30am

On the SQL server you can execute exec sp_who2 in order to identify the running SPID and impacted db.

Then using SQL profiler you can monitor the database in order to extract the stored procedures and identify what SharePoint component is impacting your platform.

Also you can check the timer jobs, full crawl, incremental crawl.

You can implement performance counters on SQL and SPS servers in order to monitor the server activity.

Here you have a complete guide

http://www.sharepointboco.com/troubleshooting-performance-issues-sharepoint-2010/

Free Windows Admin Tool Kit Click here and download it now
August 18th, 2015 3:43am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics