You can use performance monitoring tools to monitor report server performance to evaluate server activity, observe trends, diagnose system bottlenecks, and gather data that can help you determine whether the current system configuration is adequate. A combination of technologies and tools enables you to get comprehensive information about how the system is performing. Microsoft Windows Server operating systems provide performance information through the following tools: Task Manager, Event Viewer, and Performance console.
Using Task Manager
Task Manager provides information about programs and processes running on your computer. You can use Task Manager to monitor key indicators of your report server's performance. You can also assess the activity of running processes and view graphs and data on CPU and memory usage.
Using Event Viewer
Using Event Viewer, you can view and set logging options for event logs in order to gather information about hardware, software, and system problems.
A server records events in three kinds of logs:
Application log: Contains events logged by applications or programs. For example, a database program might record a file error in the application log. Application developers decide which events to log.
Security log: Records events such as valid and invalid login attempts, as well as events related to resource use such as creating, opening, or deleting files or other objects. For example, if login auditing is enabled, attempts to log in to the system are recorded in the security log.
System log: Contains events logged by Windows system components. For example, the failure of a driver or other system component to load during startup is recorded in the system log.
The event types logged by system components are predetermined by the server. Event Viewer displays five types of events:
Error: A significant problem, such as loss of data or loss of functionality. For example, if a service fails to load during startup, an Error is logged.
Warning: An event that is not necessarily significant, but might indicate a possible future problem. For example, when disk space is low, a Warning might be logged.
Information: An event that describes the successful operation of an application, driver, or service. For example, when a network driver loads successfully, an Information event is logged.
Success Audit: Any audited security event that succeeds. For example, a user's successful attempt to log on to the system is logged as a Success Audit event.
Failure Audit:Any audited security event that fails. For example, if a user tries to access a network drive and fails, the attempt is logged as a Failure Audit event.
Using Event Viewer, you can define logging parameters for each kind of event log. To define parameters, right-click a log in the console tree and click Properties. On the General tab, you can set the maximum size of the log and specify whether the events are overwritten or stored for a certain period of time.
The previous tip was excerpted from Chapter 14, 'Optimizing Report Performance,' from the book "Microsoft SQL Server 2005 Reporting Services for Dummies" by Mark Robinson, courtesy of Wiley Publishing. Click here for the complete collection of book excerpts.
Dig deeper on Microsoft SQL Server Performance Monitoring and Tuning