Creating a performance log

Performance console and Event Viewer can be used to create logs and alerts about report processing and resource consumption. This book excerpt shows you the steps to create a performance log.

This Content Component encountered an error
You can use Performance console and Event Viewer to create logs and alerts about report processing and resource consumption. To create a performance log, proceed as follows:

  1. In Control Panel, open Administrative Tools and open Performance.

  2. In the Windows Performance tool, expand Performance Logs and Alerts, right-click Counter Logs, and then click New Log Settings.
  3. Type a name for the counter log and click OK.
  4. Click Add to add as many counters as necessary for your Notification Services instance and other important values, such as processor time, disk time, and database counters. The number of counters you add doesn't significantly affect system performance.
  5. Click Close.
  6. Click the General tab and, under the section Sample Data Every, configure a sampling interval. Start with a moderate sampling interval, such as five minutes, and then adjust the interval if necessary. The shorter the interval, the more system resources and disk space will be used. Additionally, intervals shorter than the quantum period can cause a performance report to show sporadic performance numbers because you will have processing spikes mixed with no activity.
  7. On the Log Files tab, configure the properties of the log file. You can view comma-delimited files later in a reporting tool such as Microsoft Excel.
  8. On the Schedule tab, configure a monitoring schedule.

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.

This was first published in July 2006

Dig deeper on Microsoft SQL Server Performance Monitoring and Tuning

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close