HOTSPOT
You are managing a SharePoint farm,
You need to log Microsoft SQL Server 2012 events that occur in the farm.
In Centra1 Administration, which monitoring setting should you configure? (To answer, select the appropriate setting in the answer area.)
Hot Area:
Explanation/Reference:
Note:
* SharePoint 2013 writes usage and health data to the logging folder and to the logging database. You can use the SharePoint Central Administration website to configure health data collection settings.
* See step 3 (and 9 - note the reference to SQL authentication).
Configure usage and health data collection by using Central Administration
The usage and health data settings are farm-wide and cannot be set for individual servers in the farm.
To configure usage and health data collection by using Central Administration:
1. Verify that you have the following administrative credentials:
The user account that performs this procedure has to be a member of the Farm Administrators group.
2. In Central Administration, on the home page, click Monitoring.
3. On the Monitoring page, in the Reporting section, click Configure usage and health data collection.
4. On the Configure usage and health data collection page, in the Usage Data Collection section, select the Enable usage data collection check box.
5. In the Event Selection section, select the check boxes of the events that you want to log.
6. In the Usage Data Collection Settings section, type the path of the folder to which you want usage and health information to be written in theLog file location box. The path that you specify must exist on each server in the farm.
These settings are applied to all events.
7. In the Health Data Collection section, select the Enable health data collection check box. To change the collection schedules, click Health Logging Schedule.
8. To change log collection schedules, click Log Collection Schedule, and then click any of the timer jobs to change its schedule, or disable that timer job. If you disable a timer job, it stops collecting corresponding log data.
9. In the Logging Database Server section, to change the authentication method, select either the Windows authentication or SQL authentication option.
