Maintenance and Monitoring - Microsoft SQL Server 2008 R2 Administration - page 355

9. Also, a chronological view show of alerts will help us correlate the symptoms of

any storage-related problems. This is the best tool to perform any baseline and
benchmarking procedures.

This completes the required steps to perform and manage a storage system for
analyzing bottlenecks.

How it works...

The initial process of the tool is in sequential order—the Relog.exe from the Log Parser tool will
filter the required performance-monitoring data that is being collected. Internally, this tool will
break down the log into a smaller chunk that will analyze for min , max , avg , and threshold
values. The alerts will be raised and reported when a default threshold is broken, where each
analysis will contain zero or more thresholds, which is an internal mechanism to access. All the
PAL-related threshold files will contain a large number of analyses to perform that will effectively
analyze performance monitor logs to raise their importance and awareness of common.

The GUI interface will help to perform batch processing of multiple
perfmon logs, and the GUI editor is added to help with editing and
creating a user-defined PAL threshold file.

The PAL core processing engine uses VBScript and .NET framework for GUI purposes. The tool
will include all the new threshold files for IIS, Active Directory, MOSS/SharePoint, Biztalk, and
SQL Server, which works with the operating system UAC control feature.