Solved

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

Posted on 2014-07-28
8
563 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 8

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 8

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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
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
 
LVL 8

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 8

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 8

Author Closing Comment

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

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

710 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