A Few Sneak Peeks of my SharePoint Site Archival Workflow Project

I had a requirement from customer to develop an archival workflow solution using which they can automate the Site Collection archival based on a set of business rules. The features should be, notify users for the key LOB information expiration based on which the sites were created, Maintain the notification count and based on the…

0

SharePoint 2010 Performance Dashboard – Farm Content Size Reporting(Post 2/2)

  Here I have mentioned the code which can be useful to get the Content DB, Site Collection Usage details.   SPFarm farm = SPFarm.Local; SPWebService service = farm.Services.GetValue<SPWebService>("");   string webappName = ""; SPWeb web = null; SPUserCollection owners = null; string OwnerString = ""; int count = 0;   foreach (SPWebApplication webapp in…

0

SharePoint 2010 Performance Dashboard – Farm Content Size Reporting(Post 1/2)

  In this post we will look into how I did “Farm Content Size Reporting” part of the project, We have two types of reporting in this functionality. Content Databases per Web Applications Report Site Collections per Content Databases Report This can be useful for a very large size farm and where there could be…

0

SharePoint 2010 Performance Dashboard – Server Performance Reporting(Post 2/2)

  Continuing from the Post 1, Request Workload / Agent Query : SELECT AgentName, SUM(RequestCount) AS RequestsCount FROM RequestWorkload WHERE (LogTime BETWEEN GETDATE() – 10 AND GETDATE()) AND (AgentName IN (‘Browser’, ‘Collab’, ‘ExcelViewer’, ‘DAV’, ‘Groove14’, ‘Excel14’, ‘Word14’)) GROUP BY AgentName ORDER BY RequestsCount DESC   Request Duration / Agent Query : SELECT TOP (10) AgentName,…

2

SharePoint 2010 Performance Dashboard – Server Performance Reporting(Post 1/2)

  In this post, I will talk about my SharePoint Performance Dashboard Project. It has mainly two major types of reporting features, Part 1.  CPU Monitor, Memory Monitor, Top Users of the farm, Top Site Collections in the farm and many more and Part 2. List of content database with the size – for each…

3

Experience of Configuring Remote Blob Storage (RBS) with SharePoint 2010

  Recently there was a need to configure Remote blob storage(RBS) in our new SharePoint 2010 farm. I had referred a few TechNet & Blog articles to configure it and there were some differences while following the steps, The purpose of this blog is to mention the exact steps and commands we executed to setup…

2

Experience of upgrading Terabytes(TB) of MOSS2007 farm to SP2

Few weeks ago I had visited a customer regarding the MOSS2007 SP2 upgrade. Their total size of the data in MOSS was in Terabytes and at the same time it was a business critical platform where multiple teams were depended on the SharePoint for their daily work. After observing the farm, I came to know…

3