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,…

4