Microsoft Office Tutorials and References
In Depth Information
(Figure 11.49). The list will be populated with all of the active users or pages accessed, not just
the top ones; they will be listed with information pertaining to the duration it took to load the
page, database queries made by the page, and number of times a page was requested for the
slowest pages, (or in the case of users) the number of requests made, when they were made, and
how many were successful for Top Active Users. Also keep in mind that the page is very wide,
so you may miss information if you don’t scroll right. For more information about the health
reports, see Chapter 13.
C O N F I G U R E U S A G E A N D H E A L T H D A T A C O L L E C T I O N
This link and the title of the settings page it displays (Figure 11.50) don’t match. It’s almost as if
the committee that created this version of SharePoint forgot to agree on what the settings were
supposed to apply to.
On the Configure Web Analytics And Health Data Collection page, you can see settings for
enabling Usage data collection, complete with what events should be collected, where the log file for
the data should go (make sure that location is the same for every front end server on the farm), and
how large those logs can get (in gigabytes). You can also enable Health data collection here.
In the Health Data Collection section, the link to see the Health Logging schedule actually
only takes you to the Job Definitions page, filtered to the SharePoint Foundation Timer service.
But you can see the Health Analysis jobs list, in case you’d like to check their schedules or the
last time they ran or, specifically, reschedule them to run outside of peak hours.
In the same vein, the Log Collection Schedule link also takes you to the same Job Definitions
page, only filtered to the Microsoft SharePoint Foundation Usage service.
Both the Health and Usage data collection mechanisms use the same database for their data,
so there is a section specifying the database server, database name, and authentication to access
the database for the respective services. That database is one that can be directly queried by
something other than SharePoint, such as Reporting Services.
Keep in mind that logging, whether diagnostic, usage, or health, does take up storage space
on the servers and resources while the data is being logged. Schedule their timer jobs for
periods of least activity if possible. Also note that during setup, the Standalone installation of
SharePoint does not enable Health data collection by default, partly because it can ill the 4 GB