SharePoint Notes

Bleeding on the cutting edge …

Archive for October, 2009

October 2009 Cumulative Update Packages available

Posted by Christian Dam on October 30, 2009

The product team announced the availability of the October 2009 Cumulative Update Packages for SharePoint Server 2007 and Windows SharePoint Services 3.0. More information here:


Posted in MOSS, WSS | Comments Off on October 2009 Cumulative Update Packages available

Getting geared up for TechEd!

Posted by Christian Dam on October 28, 2009

Yep, it’s almost that time of the year! TechEd Europe is around the corner and the session list is beginning to take form. A month or so ago, I wasn’t to impressed with the sessions but since that at lot of exiting stuff has been added.

A lot of SharePoint 2010 sessions is on my list as is Windows Server 2008 and SQL Server sessions. I am happy that some of the great speakers are back once again. Todd Klint, Shane Young, and Joel Oleson are expected to delight and deliver as usual! My old-time favourite, Corey Hynes, is only hosting one session this year – but I am sure he’ll jump right in should Jeff Woolsey go missing as it happened last year 🙂

However, I am especially disappointed that Steve Riley and Jesper Johansson is sitting this one out as their particular sessions were always of very high quality. Maybe next year, guys?

Posted in TechEd | Comments Off on Getting geared up for TechEd!

SharePoint 2010 NDA lifted!

Posted by Christian Dam on October 27, 2009

Let the bragging blogging begin 🙂

I have had access to the SharePoint 2010 Beta 1 bits since July through our partner agreement at work. I will not start listing all the new things that are coming. Joel has a great summary that you might want to check out. However, I must admit I am impressed with the overall quality of the product, and even though a lot of stuff still doesn’t work, what does work is fan-%”¤%(%”-tastic!

ProActive is already implementing our first SharePoint 2010 solution. We are planning to go live 2-3 weeks after Beta 2 is available depending on the changes. Our solution is a Intranet/Document Management system and I will share our findings in the coming days, more specifically

  • the term store and shared metadata and content types
  • unique document IDs
  • document sets
  • etc

Posted in Document Management, SharePoint 2010 | 2 Comments »

SharePoint and very large databases

Posted by Christian Dam on October 27, 2009

I got a very interesting call from a colleague the other day. He had a customer with content database which apparently was approaching 1TB! My colleague of course told the customer that it was not aligned with best practices and that it could cause problems down the road to which the customer replied with a smile: “Well, if that happens we just throw additional resources at the SQL Server. Thanks for playing, now leave me alone”

So, he called me:  “Does it sounds plausible? SQL Server 2005/2008 can support exabytes of data so what’s the problem?”

Well, I went to work and starting digging up some information. My main bibles SharePoint 2007 Best Practices and Inside SharePoint 2007 Administration both referred to Microsoft guidelines which recommend to limit the content databases to 100GB:

Limit content database size to enhance manageability

Plan for database sizing that will enhance manageability and performance of your environment.

  • In most circumstances, to enhance the performance of Office SharePoint Server 2007, we discourage the use of content databases larger than 100 GB. If your design requires a database larger than 100 GB, follow the guidance below: 
    • Use a single site collection for the data. 
    • Use a differential backup solution, such as SQL Server 2005 or Microsoft System Center Data Protection Manager, rather than the built-in backup and recovery tools. 
    • Test the server that is running SQL Server 2005 and the I/O subsystem before moving to a solution that depends on a 100-GB content database. 
  • Whenever possible, we strongly advise that you split content from a site collection that is approaching 100 GB into a new site collection in a separate content database to avoid performance or manageability issues. 
  • Limit content databases that contain multiple site collections to approximately 100 GB.

However, the recommendations didn’t say anything about why 100GB is the magic number. MVP Ben Curry even at one point said “100GB doesn’t seem very big anymore 🙂 If you need larger site collections, optimize SQL and rock on… “ 7-8 month later, Ben had thought it over once again and had come to another conclusion: “So, use your head when architecting databases/site collections and don’t smoke crack. I’ve even said you can have monster content databases in the past – I was wrong. The only way I would now architect large content databases would be for fairly static data that did not have a large collaborative user population.”

OK, so why is Ben advising us not to smoke crack? In other words, why are large content databases evil?

Obviously large databases makes it difficult to administer the databases and to maintain a realistic back/recovery plan due to the sheer amount of data:

  • backup and restore take a long time (normally 150GB can be backed up in a 4 hour window)
  • the SLA may be in jeopardy
  • it is difficult to periodically test and verify the backup/restore procedure
  • database attach is slow 
  • upgrading WSS/MOSS service packs will be slow
  • I am sure some custom code start to suffer as well

Note: the backup/restore timing issues normally doesn’t apply to those customers using SQL Mirroring or SQL log shipping.

Additionally – and probably at least as important: more data will lead to more SQL I/O which again lead to more locking and blocking on the SQL Server backend. All data in a site collection share the same table and if that table is blocked, access to all sites in the site collection is blocked! It is a normal SQL Server thing and as such it is not even visible in the event or trace logs.

Splitting up the content database can help overcome most of these problems and it is fortunately a relative simple thing to do. Here’s how to do it on WSS and MOSS.

Posted in Capacity Planning, MOSS, WSS | 1 Comment »

A couple of infrastructure related anouncements …

Posted by Christian Dam on October 11, 2009

Windows Virtual PC

Windows Virtual PC has RTM’ed and is available on technet. I would expect it do be available on MS Update / Download soon as well:

Support changes for Windows 2000 and Windows 2003 July 2010

Extended support will end for Windows 2000 and Windows Server 2003 and Windows Server 2003 R2 will move to extended support:

Forefront Threat Management Gateway reaches the Release Candidate state

The product team announced that the RC version od the next version of ISA Server / Intelligent Application Gateway (IAG) 2007 firewall products is available for download:

Posted in Forefront Server Security, Windows Server | Comments Off on A couple of infrastructure related anouncements …

SharePint thursday Oktober 8

Posted by Christian Dam on October 5, 2009

The next SharePint event in Copenhagen in being held at Rosie McGees at 5PM this coming thursday.

Posted in SharePint | Comments Off on SharePint thursday Oktober 8