If you've enjoyed any of my posts, here are links to all of them, arranged in the order that you're likely to need them:
Spotlight on SQL Server
Installation, Setup and Administration
Spotlight on SQL Server Installation Requirements (with Optional Walk-Through)
Setting up Monitoring of your SQL Servers
How to use Spotlight
An Introduction to using Spotlight on SQL Server
Understanding Performance History with Spotlight
Statement-Level Analytics using Wait Events and Workload Analysis
Specific Use-Case Examples
Diagnosing Blocking and Deadlocks
Customization
Customizing Spotlight on SQL Server Alarms
Extending Spotlight on SQL Server using Custom Counters
Monitoring SQL Server's Peripheral Functionalities
Foglight for Databases
Installation, Setup and Administration
Installation Requirements and Walk-Through
How to use Foglight
An Introduction to using Foglight for Databases
Statement-level and Historical Analytics
Specific Use-Case Examples
Diagnosing Blocking and Deadlocks
Customization
LiteSpeed for SQL Server
Understanding Backup Performance
