- Activity
Monitor: It displays
graphically about Processes, Resource Waits, Datafile I/O, Recent expensive
Quires.
- Database
Tuning Advisor (DTA): Recommend indexes and
statistics
- Profiler: Can run traces and find out the expensive/long
running quires/transactions
- Execution
Plans: There are three types
Graphical, Text and XML.
- DMV: Dynamic management views shows the current state
of the sql server
- Extended
Events: Used for more
granular details with less performance overhead than profiler.
- PerfMon: Windows native tool to view / monitor the
performance of both sql and windows servers
- Third
Party: Redgate products
Thursday, 17 December 2015
Performance Tuning - Performance tuning/monitoring tools
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment