SQL Database size

[ruckus37]

We have a large Sharepoint installation running on IIS and a separate SQL Server. My question is that the database is growing at an alarming rate, mostly files. How large may my database become before I need to be concerned with my SQL Server? At what point do I need SQL enterprise server for Sharepoint?

 

[Thomas2000]

Hello,

How many users do you have? How many sites (portal instances) do you have?

What is your specification of the SQL server?

I am running my SQL in an Active/Passive cluster, with 3.6Ghz XEON Single CPU. I am hosting One portal instance and some 600 sharepoint sites and around 100000 indexed documents, and hosting 9000 users. My databases for sharepoint take up around 80 GB, so I just make sure I have a lot of disk space.

I have not noticed any performance issues yet, I constantly check response times and how much read/write I/O I have on my system.

Microsoft has released some whitepapers about capacity planning

http://office.microsoft.com/en-us/assistance/HA011647571033.aspx

Cheers,
Thomas

http://www.thompa.se

 

[ruckus37]

Thanks for the link

Looks like we are ok with our current small farm for now, do you think there is a reason that they recommend 200 GB in all scenarios? Is there a limit on database size? Would it be unusual to have a 500 GB database?

 

[Thomas2000]

I do not know why they recommend as much as 200 GB. I am not sure if there is a limit of the DB size, it all depends on the hardware I guess. I have 136 GB for my SQL cluster at the moment, but I can expand that at any time by simply plugging in more disks to the disk cabinet.

When it comes to size of the DB the more data you put into sharepoint the more data there will be in the DB, since sharepoint saves everything into it's databases, not just the documents, but all list items etc.

Cheers,
Thomas

http://www.thompa.se