Tag Archives: performance

SharePoint with more than one SQL instance: possible or not possible

The first question that I have in mind before continuing this post is:

Q: Is it possible to have multiple instances for the same SharePoint farm?

A: Yes it is possible, we can have more than one SQL instance where we can store the content databases.

If you want to transfer a SharePoint content database from one instance to another you can use the following procedure:
Continue reading

SharePoint SQL Server Performance tuning

This article will provide tips and tricks regarding SQL performance improvement.

The SharePoint server health is directly connected with the SQL server health. If your SQL server is suffering because of poor performance the impact will be reflected in your SharePoint environment. User experience will be degraded more and more if you are not acting in time.

Continue reading

Troubleshooting Performance issues SharePoint 2010

The scope of this post is to help you to identify the root cause of a SharePoint performance issue.

We will implement collect performance counters, IIS logs and Failed Request Tracing from all the servers in the farm (SharePoint and SQL servers).

A. Performance Counters

Server type: Web Front End/Query

1. You need to allow Process ID value to be included as part of the process monitor data that is recorded. You can follow the steps from this article http://support.microsoft.com/kb/281884 The Process object in Performance Monitor can display Process IDs (PIDs)

2. Counters list that need to be implemented and collected on all the WFE servers

ASP.NET(*)*

ASP.NET v2.0.50727*

ASP.NET Apps v2.0.50727(*)*

.NET CLR Networking(*)*

.NET CLR Memory(*)*

.NET CLR Exception(*)*

.NET CLR Loading(*)*

.NET Data Provider for SqlServer(*)*

Processor(*)*

Process(*)*

LogicalDisk(*)*

Memory*

PhysicalDisk(*)*

SharePoint Publishing Cache(*)*

System*

Web Service(*)*

Web Service Cache*

You can add those counters manually or you can use logman create counter command line Continue reading