Solved

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

Posted on 2014-07-28
8
544 Views
Last Modified: 2014-08-20
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.
0
Comment
  • 5
  • 3
8 Comments
 
LVL 5

Accepted Solution

by:
Adam Ray earned 500 total points
ID: 40223637
Does it continuously run slow? Or does it just take a while to load the first time after it has been idle a bit?

If the latter, it may be that IIS is recycling the worker process for the sharepoint application pool. The timeout can be adjusted in IIS.

(But before you google that and start changing settings I'd read up a bit in general on optimizing sharepoint.--In my environment sharepoint is fairly small, so I didn't have to worry about any potential performance implications of changing the default settings. ) http://technet.microsoft.com/en-us/library/cc298550(office.12).aspx
0
 
LVL 7

Author Comment

by:Senior IT System Engineer
ID: 40223730
It continuously runs slow, especially when clicking on submit on the Infopath form to upload the document.
0
 
LVL 7

Author Comment

by:Senior IT System Engineer
ID: 40225863
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
0
 
LVL 5

Assisted Solution

by:Adam Ray
Adam Ray earned 500 total points
ID: 40227429
Off hand, I can't remember for sure if it says, but have you checked Add/Remove programs to see if it is listed there. I seem to remember it specifying whether it was WSS 2, WSS 3, etc. (WSS is a separate install, not a server role.)

Moreover, what version of Windows do you have on the server. If you have 2008 R2/2012 you may have Sharepoint Server Foundation 2010+ rather than "Windows Sharepoint Services"

How long of a delay are you talking about? I've used WSS 2/3 on SBS2003 and WSS 3 on a hosted platform and it was never snappy. I no longer have it up running so I can't confirm, but it seem to remember a few seconds delay was common when I was working infopath documents. My "list" with attachments ran faster but it still snappy. (I eventually made a Access front end for my "lists" because I never did like working in the sharepoint interface. (But the others using it liked the simplicity of the sharepoint site, so I kept the backend there so they could use the web interface.)

Having said all of that, my sharepoint databases were relatively small, so I never tried to do much optimizing and just lived with it. (A few hundred infopath forms, a few thousand list items, and a few hundred meg in the document library.)
0
What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

 
LVL 7

Author Comment

by:Senior IT System Engineer
ID: 40228300
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.
0
 
LVL 5

Assisted Solution

by:Adam Ray
Adam Ray earned 500 total points
ID: 40230667
It's been a while since I've used Server2003/WSS 3.0. But in my old install (On SBS 2003) I seem to remember turning off/tweaking the settings for some of the automated tasks (e.g. backup checkpoints, deleted items retention age, indexing settings) in the sharepoint administration website. (You can find it in IIS, it's not the "site designer" section of the normal sharepoint website.)

Also don't forget the basics, like making sure any back up jobs run (and complete) at night. (Continuous backup solutions that run incremental jobs during the day or online backups that run hourly sound like a good idea, but they can really kill performance.)

If you are running the 32-bit version of server 2003 (32-bit IIS, sharepiont, SQL, etc.) I saw an article that said NOT to enable the 3GB flag in the Windows bootloader or SQL instance. It, in theory, gives you access to more RAM if you have it installed, but can cause other problems in Sharepoint/SQL.
0
 
LVL 7

Author Comment

by:Senior IT System Engineer
ID: 40230747
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 ?
0
 
LVL 7

Author Closing Comment

by:Senior IT System Engineer
ID: 40275262
Thanks !
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now