- SQL Profile
- Extended Events
- Activity monitor
- IOMeter
- Sqlio
SQL Profile
This tools was created for profiling SQL queries, for investigating query performance, and different statistics and parameters of query. More information in here. This tools is deprecated and will be replaced by Extended Events.
Extended Events
Extended events was created for replacing SQL Profile.And it can do the same as profile but use minimal resources. More information here.
Activity monitor
Activity monitor is tools for monitoring memory, CPU, disk resources etc. More information here.
IOMeter
IOMetter - tools for investigating performance of disks. More info here.
SQLIO
SQLIO - is tools for investigating raid performance for I/O operations. More info here.