Albert Widjaja
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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 ?
so is that WSS 3.0 SP1 ?
ASKER
Thanks !
ASKER