asked on

SQL Server 2005 performance tuning and diagnostic for slow SharePoint server 2007 database ?

Hi people,

Can anyone please suggest me what is the SQL Server 2005 command / script to identify which part of the database that is causing my SharePoint Server 2007 to runs slow ?

and what is the recommendation to make sure that it can run well again ?

Thanks.

ASKER CERTIFIED SOLUTION

Adam Ray

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Albert Widjaja

ASKER

It continuously runs slow, especially when clicking on submit on the Infopath form to upload the document.

Albert Widjaja

ASKER

ok, I've managed to find the version of my sharepoint server from Central Administration > Operations > Servers in Farm , it is 12.0.0.6690

what version is that ? I cannot find it in anywhere by Googling around ?

I'm about to apply the scheduled after hours SQL script from http://support.microsoft.com/kb/943345 but not sure if it is applicable since I cannot determine the version of my WSS 3.0

Note: the scheduling and running of the script are included in SP2

SOLUTION

Adam Ray

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Albert Widjaja

ASKER

The Windows Serve that I have which runs the SharePoint site is Windows Server 2003 not 2008.
the database is quite big, the WSS_Content is 22 GB in size and users report that it is slow to submit Infopath form and even opening the sites.

SOLUTION

Adam Ray

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Albert Widjaja

ASKER

ok, I can see the WSS 3.0 version from the Add/Remove program 12.0.6612.1000
so is that WSS 3.0 SP1 ?

Albert Widjaja

ASKER

Thanks !