+ Post New Thread
Results 1 to 5 of 5
Virtual Learning Platforms Thread, How do you split a large .MDF file? in Technical; Hi. We are running SharePoint 2007 and our WSS_Content_xxx.Mdf is a huge 194Gb. I've already managed to shrink the .Ldf ...
  1. #1
    bandgeekmafia78's Avatar
    Join Date
    May 2007
    Location
    Salford
    Posts
    382
    Thank Post
    88
    Thanked 22 Times in 14 Posts
    Rep Power
    21

    How do you split a large .MDF file?

    Hi.

    We are running SharePoint 2007 and our WSS_Content_xxx.Mdf is a huge 194Gb. I've already managed to shrink the .Ldf file to virtually nothing but we are still getting performance issues and my thinking is that it would be best to split the MDF file.

    Does anyone know if splitting the mdf file would increase VLE performance? If so, what is the best method to do this?

    Also - I would like to find out why the .mdf file is so big - is there software which can explore this file to show the main areas of our VLE which are causing it to be so big?

    Thanks.

    Alan.

  2. #2

    SimpleSi's Avatar
    Join Date
    Jun 2005
    Location
    Lancashire
    Posts
    5,720
    Thank Post
    1,451
    Thanked 580 Times in 434 Posts
    Rep Power
    165
    I use my B&D Scorpion Saw to partition mdf

  3. 2 Thanks to SimpleSi:

    BatchFile (1st March 2011), Little-Miss (1st March 2011)

  4. #3
    bandgeekmafia78's Avatar
    Join Date
    May 2007
    Location
    Salford
    Posts
    382
    Thank Post
    88
    Thanked 22 Times in 14 Posts
    Rep Power
    21
    Thanks. I'm not sure whether its worth the hassle of splitting the mdf file if there isn't a significant change in performance afterwards. I've found a good tool called CardioLog which is helping me to figure out why my SharePoint Server is on its knees.

  5. #4
    apearce's Avatar
    Join Date
    Feb 2008
    Location
    Birmingham
    Posts
    399
    Thank Post
    33
    Thanked 171 Times in 106 Posts
    Rep Power
    41
    Quote Originally Posted by bandgeekmafia78 View Post
    Hi.

    We are running SharePoint 2007 and our WSS_Content_xxx.Mdf is a huge 194Gb.
    Hi,
    Do you actually have 194GB of data in your database.

    You need to consider splitting your SharePoint sites with more top route site collections. Each site collection then has its own database to store data. For best practice SharePoint and SQL don't like databases more than 50GB so you need to reduce the size.

  6. Thanks to apearce from:

    bandgeekmafia78 (10th March 2011)

  7. #5

    Join Date
    Jan 2010
    Location
    Elstree
    Posts
    39
    Thank Post
    4
    Thanked 11 Times in 10 Posts
    Rep Power
    26
    Hi

    194gb for a content database is really large. Large content databases can be cause of performance issues and also cause issues when upgrading to SPS 2010 It would be advisable to split the content database if you have a number of site collections. could you please advise on your hardware setup and specs. Some suggestions to help:

    - run performance counters that come with Windows Server to ensure its not a hardware issue i.e CPU utilisation / available memory / disk IO / NIC IO- do you use my sites at the moment it would be worth seperating these
    - seperate my sites web application and content databases. this article should help The SharePoint Bandit: Moving My Sites to a separate content database and web application
    - if you have a number of site collections move them to another content database. a good reference for this is: Move site collections to a new database (split a content database) (Windows SharePoint Services 3.0)

    As alex has pointed out for best practices the databases should not be more then 50gb.

    hope this helps

    San Mehta
    LP+ Support

  8. Thanks to LPPLUS_Support from:

    bandgeekmafia78 (10th March 2011)

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 24
    Last Post: 7th January 2013, 11:42 AM
  2. File exchange over 2 split networks?
    By gshaw in forum Wireless Networks
    Replies: 5
    Last Post: 26th June 2009, 10:59 AM
  3. Missing file: "newsimsdatabase.mdf"
    By button_ripple in forum MIS Systems
    Replies: 1
    Last Post: 8th June 2009, 09:46 AM
  4. Patch city and large mdf file
    By GrumbleDook in forum MIS Systems
    Replies: 10
    Last Post: 4th October 2007, 10:20 PM
  5. large File Transfer
    By SimpleSi in forum Windows
    Replies: 20
    Last Post: 26th March 2007, 06:24 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •