Perform benchmark tests before assigning any execution attributes so that you have the results to use as a baseline after making adjustments.
Two tools that can help you understand system and application behavior are:
Adaptive Server Monitor provides a comprehensive set of performance statistics. It offers graphical displays through which you can isolate performance problems.
sp_sysmon is a system procedure that monitors system performance for a specified time interval and then prints out an ASCII text-based report.
For information on using sp_sysmon see Performance and Tuning Guide: Tools for Monitoring and Analyzing Performance. In particular, see “Application management”.
