Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Lumbago
Norsk Yak Master
3271 Posts |
 Posted - 2010-08-27 : 04:31:50
|
| Hi,we're having a discussion here whether to use Filestream or plain varbinary(max) in a somewhat big Sharepoint farm and I was wondering if anyone has any experience in relation to performance. Sharepoint is designed to store all documents in the database, but you have a choice of using filestream if you want to. The problem with using filestream is that mirroring is not supported which basically leaves us with clustering or log shipping as the only two HA possibilities and none of them are really optimal. Clustering is sub-optimal due to the hardware-constraints, cost and the lack of distance between the servers and log shipping due to manual failovers and the possibility of data loss. What I'm trying to find out is if *not* using filestream will cause a significant performance hit or not. We estimate a average file size of 15MB (and several 100GB's of documents in separate 100GB databases) but we will have a fair share of larger files as well, some probably in excess of a GB. If we choose to use filestream then disk capacity and database performance will be ok, but the redundancy will suffer. How does storing files in the database over time compare...?- LumbagoMy blog (yes, I have a blog now! just not that much content yet) -> www.thefirstsql.com |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2010-08-30 : 02:31:55
|
| Nobody here that has experience with a lot of files stored in the database..??- LumbagoMy blog (yes, I have a blog now! just not that much content yet) -> www.thefirstsql.com |
 |
|
|
|
|
|
varbinary(max) vs filestream