|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/solarwinds-database-performance-analyzer-dpa/
课程评论：没有评论
课程名称：SolarWinds DPA 性能数据库监控/调优软件 课程概述：SolarWinds数据库性能分析器（DPA）能够快速识别性能问题，并提供专业的调优建议。通过机器学习驱动的异常检测，数据库管理员可以主动优化数据库，防止小问题变成大麻烦。 课程特点： - 仅需几秒钟即可找到性能最差的应用程序、SQL和表 - 对虚拟、物理和云数据库实例进行混合监控 - 从CPU和I/O到SQL语句深入挖掘根本原因 - 可视化所有等待时间，包括资源、阻塞、主机和虚拟机资源等 - 随着时间推移，基于机器学习的异常检测持续提升 - 提供详细的阻塞和死锁分析，揭示SQL阻塞层级 - 集成的VMware ESXi可视化（可选VM选项） - 支持对单个SQL查询语句的搜索和筛选 主要优势： - 无代理，易于安装，快速见效，系统开销低于1% - 可在Windows或Linux服务器上运行，或以Azure及AWS订阅的形式部署 - 不仅限于问题分析，还能提供表调优和查询顾问的专业建议 - 完整查看所有数据库实例资源，覆盖CPU到存储I/O - 精细化到SQL文本级别 - 可创建自定义报告和自动邮件提醒 - 与DevOps自动化流程集成，支持RESTful API - 关联硬件约束对终端用户的影响资源指标 - 可扩展支持大型动态环境 - 通过SolarWinds Orion平台、PerfStack和AppStack实现端到端可见性 此课程为希望深入了解数据库性能监控与调优的数据库管理员和IT专业人员提供了宝贵的知识与技能。
SolarWinds Database Performance Analyzer (DPA) pinpoints performance issues while providing expert advice with tuning advisors. Anomaly detection powered by machine learning allows DBAs to proactively optimize databases before small issues become big problems.FEATURES • Find your worst-performing applications, SQL, and tables in seconds • Hybrid monitoring for virtualized, physical, and cloud-based database instances • Uncover root causes from CPU and I/O down to the SQL statement • Visualize all wait times from resources to blocking, to host and VM resources, and more • Anomaly detection powered by machine learning gets better over time • Detailed blocking and deadlock analysis expose your SQL blocking hierarchy • Integrated VMware ESXi visualization with the optional VM Option • Ability to search for and filter individual SQL query statementsKEY BENEFITS • Agentless and easy to install with quick time-to-value and low overhead of 1% or less • Runs on either Windows or Linux servers, in Azure , or as an AWS subscription • Goes beyond problem analysis with expert advice with table tuning and query advisors • Get the complete picture of all database instance resources spanning CPU to storage I/O • Granularity to drill down to the SQL Text level • Create custom reports and automated email alerts • Integrate into your DevOps automation routine with RESTful API • Correlate resource metrics of hardware constraint impacts on end users • Scalability to support large, dynamic environments • End-to-end visibility with SolarWinds Orion Platform, PerfStack, and AppStack integration
