SQL Query Performance Monitoring and Base-lining solutions

Overview and practical examples of SQL Query Performance Monitoring:

• sp_Who, sp_Who1, sp_Who2, sp_Who3, sp_WhoIsActive, sp_PerfSQ, sp_BlitzWho, SQLQueryStress (load-generating tool)
  Profiler, Extended Events, Query Store
• Third party tools: Redgate SQL Monitor, Quest Spotlight, SolarWinds, Foglight (one of the above will be demonstrated)
• Custom solutions (SSIS, T-SQL)
  ------------------------------------------
  Business intelligence (BI) leverages software and services to transform data into actionable insights that inform an organization’s strategic and tactical business decisions. BI tools access and analyze data sets and present analytical findings in reports, summaries, dashboards, graphs, charts and maps to provide users with detailed intelligence about the state of the business.
  In SQL Server the main native BI tools are: SSIS, SSRS, SSAS.