Showing posts with label SQL Server. Show all posts
Showing posts with label SQL Server. Show all posts

Tuesday, October 30, 2012

Shredded Storage in SharePoint 2013

How many times we thought through before enabling versions for a specific document library which will handle files of huge size during the capacity planning exercise in MOSS 2007 and SharePoint 2010.

After enabling versions in a document library, imagine there is a DSTD.docx of 20 MB word document of v1.0 in that document library and user is attempting to edit this document. SharePoint 2010 server will serve the full document to the MS Office Word Client. After making changes to couple of page, when the user hit the Save/Sync button, SP 2010 gets the full 20 MB modified document and stores it as a seperate entry in content database.

Say if we run across ten major versions of this specific document in SP 2010, the disk space occupied by this document in Sql Server content database would be 20MB * 10 versions= 200 MB

SP2013 changes this scene by using the Shredded storage technique, if you were a DB admin or an IT Pro the you should have heard about Differential backups or incremental backups. Shredded storage is similar to this.

In SP2013,   when the user hit the Save/Sync button after making changes in DSTD.docx v1.0 , SP 2013 gets the delta changes in that modified document and add an entry in content database.

So in SP 2013 enabling the versions is not gonna eatup disk storage, reduces disk I/O as only the delta is getting stored and efficient use of network bandwidth.

Sunday, January 16, 2011

SQL server at xxx has an unsupported version 10.0.2531.0, SharePoint PSConfig error

While I was preparing a bonsai SharePoint 2010 web farm with Sql Server 2008 Enterprise database in my Dell Studio 1555. As I did numerous standalone SharePoint 2010 deployment for development activity on Windows Server 2008/R2/Win 7 with Sql Server 2008 express + SP1, I used to have the pre-requisites handy in my hard disk to build multiple virtual hard disks.
After building and networked the domain controller and the enterprise database server, executed the SharePoint 2010 installer and ran the PSConfig wizard on designated app server image. While connecting to the database server, wizard throws an error
---------------------------
SharePoint Products Configuration Wizard
---------------------------
SQL server at windb\dbsvr2010 has an unsupported version 10.0.2531.0. Please refer to "http://go.microsoft.com/fwlink/?LinkId=165761" for information on the minimum required SQL Server versions and how to download them.
---------------------------
OK   
---------------------------
I never expected this behavior ,went back to my standalone SharePoint installation and verified the database server. It says 10.0.2531.0 and running happily.
Went back to MSDN Hardware and Software requirement, there's a different standard for Sql Server 2008 Express(standalone) and Sql Server 2008 Enterprise(Farm installation). 
If you are gonna install Sql Server Express 2008 as your data store you are good enough to go with only Sql Server SP 1 (10.0.2531.0) but if you are preparing a web farm and proceeding for Non-Express database then you should also install the Cumulative update 2(10.0.2714) or CU5 (Installing CU3 or CU4 is not recommended)
Now the PSConfig wizard is happy and configures my web farm successfully.

Thursday, September 25, 2008

Free Sql Server 2008 Ebook - Direct Download

As some of my friends felt bit difficult to make a download of free SQL Server Ebook. I would like to dedicate this direct download link to those who find it difficult to download and those who don't have hotmail ID or Live ID.

Download here:

Monday, September 22, 2008

Free Microsoft Press E-Book offer

Download Free E-book from Microsoft
You will need to provide your Live Id or Hotmail ID for a registration process before downloading.



Table Of Contents:

Chapter 1: Security and Administration
Chapter 2: Performance
Chapter 3: Type System
Chapter 4: Programmability
Chapter 5: Storage
Chapter 6: Enhancements for High Availability
Chapter 7: Business Intelligence Enhancements

Introducing Microsoft SQL Server 2008
by Peter DeBetta, Greg Low, and Mark Whitehorn
ISBN: 9780735625587

Download From here