Solved

Sharepoint 2010 and SQL 2012

Posted on 2014-01-23
8
371 Views
Last Modified: 2014-01-24
I have try to tune our SQL 2012 server which host our SharePoint 2010 environment. I am not a DBA so please bare with me.

I have read that when SQL is hosting content for SharePoint you should disable auto-create stats and set the fill factor to 80.

How and where can I check the current setting for these values.
0
Comment
Question by:compdigit44
[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
  • 4
  • 3
8 Comments
 
LVL 38

Expert Comment

by:Justin Smith
ID: 39804681
Fill Factor


The auto-create isn't on by default.
0
 
LVL 20

Author Comment

by:compdigit44
ID: 39805130
Do you have any additional items I should do in sql 2012 hosting sharepoint DB's to make ensure top performance
0
 
LVL 38

Accepted Solution

by:
Justin Smith earned 500 total points
ID: 39805141
0
Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

 
LVL 44

Expert Comment

by:Rainer Jeschor
ID: 39805186
Hi,
have no link at hand BUT the MOST important performance killer is to setup the TEMPDB the wrong way.
During each and every request a lot of temporary objects/tables are created on SQL side - all this objects are written to the tempdb. Therefore normally the most workload is on the tempdb.

Just my 2ct
Rainer
0
 
LVL 20

Author Comment

by:compdigit44
ID: 39805205
I was planning on moving my tempdb to it's own volume. What are your thoughts on change the fill factor setting or DB defragging?
0
 
LVL 38

Expert Comment

by:Justin Smith
ID: 39805274
For larger farms I go ahead and do it, but for most smaller farms, it doesn't make a difference.  It's not going to hurt through, for anyone to do it.

For SharePoint 2013 I believe the fill is different than 80.  But you don't care bout that right now :)
0
 
LVL 20

Author Comment

by:compdigit44
ID: 39806328
Thansks!!! How can you tell if changing the fill factor would help or not?

Should the db be defragged regually?
0
 
LVL 38

Expert Comment

by:Justin Smith
ID: 39806404
SharePoint will defrag db's.  Make sure you read the db maintenance article on Technet.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

733 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