+ Post New Thread
Results 1 to 5 of 5
Virtual Learning Platforms Thread, SharePoint Database size in Technical; Just wondering how big the sql database of your sharePoint deployments are. We started of with a 10gb LUN on ...
  1. #1

    Join Date
    May 2008
    Location
    York
    Posts
    515
    Thank Post
    22
    Thanked 49 Times in 46 Posts
    Rep Power
    24

    SharePoint Database size

    Just wondering how big the sql database of your sharePoint deployments are.

    We started of with a 10gb LUN on our SAN for this
    2 weeks ago doubled it to 20gb now it only 20mb free again. Unfortunately when we did the SAN setup we did not have intention of using any additional SQL space than SIMS,AV and print management.(how wrong can you be).

    Now big problem is no more space available on that LUN so thinking about starting again and allowing a lot more space. Thinking of allowing 200gb on a new one.

  2. #2
    meastaugh1's Avatar
    Join Date
    Jul 2006
    Location
    London/Hertfordshire
    Posts
    890
    Thank Post
    69
    Thanked 85 Times in 70 Posts
    Rep Power
    32
    Mine's currently about 18GB and had initially allowed for about 140GB disk capacity, assuming another 140GB for the database to be dumped to disk on a daily basis, which is then backed up to tape overnight.

  3. #3
    apearce's Avatar
    Join Date
    Feb 2008
    Location
    Birmingham
    Posts
    415
    Thank Post
    34
    Thanked 175 Times in 110 Posts
    Rep Power
    43
    200GB is a good size - you wont fill that up very quickly if your only going to run SharePoint.

    Keep an eye on your log database size and make sure it gets reduced in size after a full backup.

    Make sure you have a read up on best practise for SQL Server and SharePoint as this will give you some good tips on performance - for example... Tell you database to increase at 100MB instead of 10MB as this will help upload file performance.

  4. #4
    NewOrder's Avatar
    Join Date
    Mar 2007
    Location
    Stafford
    Posts
    195
    Thank Post
    10
    Thanked 18 Times in 17 Posts
    Rep Power
    19
    Have you checked the SQL logs they will need shrinking.

    Another issue is video.

  5. #5
    apearce's Avatar
    Join Date
    Feb 2008
    Location
    Birmingham
    Posts
    415
    Thank Post
    34
    Thanked 175 Times in 110 Posts
    Rep Power
    43
    shrinking your database should be part of your full back up of you sql server databases.

SHARE:
+ Post New Thread

Similar Threads

  1. File size
    By imiddleton25 in forum Virtual Learning Platforms
    Replies: 2
    Last Post: 24th June 2008, 11:06 PM
  2. WSUS Size
    By Simcfc73 in forum Windows
    Replies: 12
    Last Post: 3rd March 2008, 03:51 PM
  3. SIMS Database Size SHrinkDBLog Help Needed
    By Grommit in forum MIS Systems
    Replies: 13
    Last Post: 27th September 2007, 06:55 AM
  4. Replies: 4
    Last Post: 28th February 2007, 09:37 AM
  5. WSUS Size
    By plexer in forum Windows
    Replies: 7
    Last Post: 12th December 2006, 09:08 AM

Thread Information

Users Browsing this Thread

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

Posting Permissions

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