Perform benchmark tests before assigning any execution attributes so that you have the results to use as a baseline after making adjustments.
Tools that can help you understand system and application behavior include:
Monitoring tables – provide both a system-wide view or performance and details about objects and users.
Monitor Server – provides a comprehensive set of performance statistics. It offers graphic displays through which you can isolate performance problems.
sp_sysmon – is a system procedure that monitors system performance for a specified time interval, then prints an ASCII text-based report.
See Performance and Tuning Series: Monitoring Adaptive Server with sp_sysmon.