Share-n-dipity

SharePoint serendipity is the effect by which one accidentally discovers something fortunate, especially while looking for something else entirely. In this case, it is the occassional musings, observations, and Ouija board readings about the phabulously

How Does SharePoint 2010 Support Partitioned Tables in the Usage Database

How Does SharePoint 2010 Support Partitioned Tables in the Usage Database

  • Comments 1
  • Likes

I was talking with a buddy of mine today about the usage database in SharePoint 2010.  It is by all appearances a set of partitioned tables in SQL Server.  His very good question was well, partitioning tables is only available in the enterprise edition of SQL Server - what happens if I have a different flavor of SQL that I want to put my usage database on?  So I did a little snooping around and it turns out that while the usage database has the appearance of partitioned tables in SQL Server, it really isn't.  Meaning it doesn't use the partitioning features provided by SQL Server exactly for reasons like this.  Instead, SharePoint manages all of the tables and data loading so that it carries some of the same features as SQL partitioning but without requiring the overhead of the SQL Enterprise SKU.  Hopefully that satisifies the curiousity of those of you who were wondering the same thing.

Comments
Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment