December 26, 2011

Technical White Paper for SharePoint performance Optimization

I assigned with a task to investigate with one of the web application having very slow performance & serach scrawl issue. i went in to investigate through all servers & their CPU & Memory usages, automated peak resource usage mail from the Notification servers for a couple of days.
Then done an report with STSADM.exe -o enumsites url (as one of the post from this blog i posted), i had a report with the web application with sites and sitecollection having around 195 GB in a single ContentDB. but as per the Microsoft suggetions a web application in Moss 2007 environment a site collection must below 100GB. so we plan to proceed to split this entire Web App in to multiple Content DB's (converting large subsites in to a site collections, moving individual site collections to a different content DB's. which makes easy to take weekly backups, restoring site / site colletions in Dev box in case of any restoration takes place, easy in the process of migration, takes less load on SQL Server when performing search srawl too)

The above is suggestion found at the Microsoft White Paper, after googling i found very useful document from Microsoft SharePoint Optimization

i hope this helps if you are into a situation like above.

Thanks,
JK

UPDATE : 10/02/12
check this place too

December 13, 2011

change service accounts and service account passwords in SharePoint Server 2007 and in Windows SharePoint Services 3.0

We have a requirement to change the passwords for service accounts in SharePoint Server 2007 and in Windows SharePoint Services 3.0, succeeded in Dev box (SharePoint Server 2007 Multi Form Environment). still need to implement in Prod.

follow these steps.

Note If the SQL Server service uses a domain account, and the password for that domain account is either expired or invalid, make sure that you update the password for the domain account before you perform this procedure.
  1. Update the password for the account that is used by the Central Administration application pool. To do this, follow these steps:
    1. On all servers in the server farm, open a command prompt, type the following line, and then press ENTER:
      cd %commonprogramfiles%\Microsoft Shared\Web server extensions\12\Bin
    2. On the server that hosts the Central Administration Web site, type the following line at the command prompt, and then press ENTER:
      stsadm -o updatefarmcredentials -userlogin DomainName\UserName -password NewPassword
    3. On all other servers in the server farm, type the following line at the command prompt, and then press ENTER:
      stsadm -o updatefarmcredentials -userlogin DomainName\UserName -password NewPassword -local
    4. Restart Microsoft Internet Information Services (IIS) 6.0. To do this, type the following line at the command prompt, and then press ENTER:
      iisreset /noforce
  2. Verify that the Administration Application Pool Credential Deployment job definition is no longer displayed on the Timer Job Definitions page of SharePoint 3.0 Central Administration. To do this, follow these steps:
    1. Open SharePoint 3.0 Central Administration, click Operations, and then click Timer job definitions under Global Configuration.
    2. Verify that the Administration Application Pool Credential Deployment job definition is no longer displayed in the list.

      Note If the Administration Application Pool Credential Deployment job definition is displayed in the list, wait until it disappears from the list.
  3. Update the password for the application pool account that is used by Web applications on the server farm. To do this, type the following line at a command prompt on every server on the server farm, and then press ENTER:
    stsadm -o updateaccountpassword -userlogin DomainName\UserName -password NewPassword -noadmin
  4. Update the password for the account that is used to run the Windows SharePoint Services Help Search service. To do this, type the following line at a command prompt on every server on the server farm, and then press ENTER:
    stsadm.exe -o spsearch -farmserviceaccount DomainName\UserName -farmservicepassword NewPassword
  5. Update the password for the default content access account that is used by the Windows SharePoint Services Help Search service. To do this, type the following line at a command prompt on every server on the server farm, and then press ENTER:
    stsadm.exe -o spsearch -farmcontentaccessaccount DomainName\UserName -farmcontentaccesspassword NewPassword
  6. If you are running SharePoint Server 2007, you must also follow these steps:
    1. Update the password for the account that is used by every Shared Services Provider (SSP) on the server farm. To do this, type the following line at a command prompt on every server on the server farm, and then press ENTER:
      stsadm.exe -o editssp -title SharedServicesProviderName -ssplogin DomainName\UserName -ssppassword NewPassword
    2. Update the password for the account that is used to run the Office SharePoint Server Search service. To do this, type the following line at the command prompt, and then press ENTER:
      stsadm.exe -o osearch -farmserviceaccount DomainName\UserName -farmservicepassword NewPassword
    3. If the server farm is configured to use single sign-on, update the password for the account that is used by the Microsoft Single Sign-On Service. To do this, follow these steps:
      1. Click Operations in SharePoint 3.0 Central Administration, and then click Service accounts under Security Configuration.
      2. Under Windows service, click Single Sign-On Service.
      3. Under Configurable, specify the password, and then click OK.
    4. Update the password for the default content access account that is used by the Office SharePoint Server Search service. To do this, follow these steps:
      1. Open SharePoint 3.0 Central Administration, and then click the link to the SSP Web application under Shared Services Administration.
      2. Under Search, click Search settings, and then click Default content access account.
      3. Specify the password to use for the content access account, and then click OK.
Found this Useful KB article @

Thanks,
JK

List process IDs for IIS7 worker processes

In Microsoft IIS7, all management commands have been consolidated under the appcmd.exe commandline tool. In the past there was a collection of VBscripts that allowed you to script access to IIS.
One of the things that I need to do that can’t be done in the GUI is to list which application pools are running under which w3wp.exe worker process instances. Using the Windows task manager will show you the process IDs but won’t show you which application pools are being served by each. The inetmgr tool will show you the application pools but won’t show you the process information.
Under IIS6 there was a script called iisapp.vbs that would show you the running w3wp processes, their PIDs and the application pool that they were serving. Under IIS7 this functionality has been merged into appcmd.exe.
Appcmd was not in the path for me, so I had to add it using:

c:\> set path=%path%;C:\Windows\System32\inetsrv

Then we can run
C:\Program Files (x86)\ICW>appcmd list wp

to get:

WP "5260" (applicationPool:CRMAppPool)
WP "5736" (applicationPool:SharePoint - 80)
WP "4460" (applicationPool:SecurityTokenServiceApplicationPool)
WP "4700" (applicationPool:2d129968e2144980a7614f288ac778fd)
WP "5684" (applicationPool:Sitecore6.0AppPool)

Regards,
JK