1 / 22

Microsoft SQL Performance Dashboard

Microsoft SQL Performance Dashboard. RUI REIS Coordenador departamento Informática JORNAL A BOLA / A BOLA TV. O que é o Performance Dashboard?.

lance
Download Presentation

Microsoft SQL Performance Dashboard

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Microsoft SQL Performance Dashboard RUI REIS Coordenador departamento Informática JORNAL A BOLA / A BOLA TV

  2. O que é o Performance Dashboard? • É um conjunto de RDLs desenvolvidas usando os customreports do ManagementStudio que ajudam a resolver alguns dos problemas de performance do SQL tais como sejam; blocking, high CPU usage, latchcontention e disk I/O bottleneck, sem que para isso tenhamos de executar queries de T-SQL.

  3. Para que pode ser usado? • CPU bottlenecks (quais as queries que consomem mais CPU) • IObottlenecks (quais as queries que consomem mais IO). • Indexrecommendations - gerado pelo queryoptimizer (usa o Missing Indexes DMV) • Blocking • Latchcontention e outros tipos de Waits

  4. Performance Dashboard

  5. Performance DashboardHistoricalIOReport

  6. Performance DashboardHistoricalIOReport - details

  7. Performance Dashboard

  8. Performance DashboardHistoricalWaits

  9. Performance Dashboard

  10. Performance DashboardQuerieswithHighest CPU

  11. Performance Dashboard

  12. Performance DashboardQuerieswithHighestDuration

  13. Performance Dashboard

  14. Performance DashboardRecent CPU Consumption

  15. Performance Dashboard

  16. Performance DashboardSessionsOverview

  17. Performance Dashboard

  18. Performance DashboardMissingIndex

  19. Performance Dashboard

  20. Performance DashboardDatabases

  21. Conclusão • O Performance Dashboard é uma ferramenta muito útil principalmente para quem não é DBA a tempo inteiro • É gratuita e pode ser descarregada diretamente da Microsoft • É uma ferramenta intuitiva fácil de usar e de instalar e praticamente sem manutenção • Dá-nos uma visão geral e completa daquilo que se passa com os nossos SQL´s e bases de dados

  22. OBRIGADO

More Related