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

SharePoint 2010 Resources

SharePoint 2010 Developer Training Course SharePoint 2010 provides the business collaboration platform for developers to rapidly build solutions using familiar tools while leveraging a rich set of out of the box features. Visual Studio 2010 and SharePoint Designer 2010 make developers more productive and Visual Studio Team Foundation Server delivers support for application lifecycle management….

0