Complex database environments are continuously changing due to upgrades and application queries. The toughest part of performance is the tuning of SQL Servers.
This whitepaper covers some top tips to help guide you in your performance tuning efforts.
Through checking the compatibility level, understanding the cardinality estimation, monitoring the wait time and gathering object information, this can help your SQL service performance.
Download the whitepaper here.