Solved

Sharepoint 2010 and SQL 2012

Posted on 2014-01-23
8
355 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
  • 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 19

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
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 
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 19

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 19

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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Suggested Solutions

SharePoint Designer 2010 has tools and commands to do everything that can be done with web parts in the browser, and then some – except uploading a web part straight into a page that is edited in SPD. So, can it be done? Scenario For a recent pr…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

813 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

12 Experts available now in Live!

Get 1:1 Help Now