| Diagnostic Guide for Usage and the PowerPivot Management Dashboard |
| Written by Ankur Goyal |
| Thursday, 25 February 2010 22:49 |
|
Author: Ankur Goyal , Microsoft Analysis Service Test team Part 1: Getting Started with Usage1. When components within the various PowerPivot components decide to log “event” they call into the SharePoint Usage system APIs and Usage files are create to collect these events. This is a very high-throughput, low-overhead process since it is based on the OS Eventing system. Usage data files (.usage) gets collected in the SharePoint log directory (system drive->\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\LOGS). And by default .usage files get created every 30 minutes. To change the 30 minute interval, see below or a posting here: http://powerpivotgeek.com/2010/01/18/how-to-manually-update-your-powerpivot-management-dashboard/ (for a general discussion around manually updating the dashboard).
|
Most Popular
- Step by step guide on installing PowerPivot for SharePoint on a single machine
- List of suggested datasets to test PowerPivot
- List of PowerPivot DAX functions with description
- How to install PowerPivot for Excel and list of know issues
- Microsoft Virtual Lab: PowerPivot for Excel 2010 Introduction
- List of PowerPivot DAX functions (short)
- Learning PowerPivot and DAX
- PowerPivot's impact on BI pros?



