|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/real-world-sql-server-profiler/
课程评论：没有评论
课程名称：现实世界 SQL Server Profiler 课程概述：本课程旨在深入探讨 Microsoft SQL Server Profiler，作为监控 SQL Server 数据库引擎 T-SQL 语句的强大工具。通过该工具，用户可以捕获和分析事件，从而识别和解决多种与 SQL Server 相关的问题。优秀的数据库管理员（DBA）不仅具备扎实的知识，还懂得如何充分利用可用工具。本课程将涵盖 SQL Server Profiler 的架构，并使用其跟踪性能相关问题。我们将详细讲解事件及事件类的术语，及如何有效使用界面，捕获所需信息而不是成千上万的无用数据。 在课程中，学员将学习如何创建跟踪、实时监测 spid、存储、重放以及将输出保存到服务器，以便其他人查看结果。虽然 Profiler 的应用频率在现实世界中较低，主要是因为其界面设计不佳、未经过滤时会产生大量数据，以及可能会消耗服务器资源。但通过适当配置 Profiler 以追踪相关数据，可以减轻运行时的额外负担。此外，长时间运行 Profiler 时，收集选择性数据显得尤为重要，以防数据快速增长超出服务器存储空间。 本课程将帮助学员克服使用 Profiler 时的常见问题，并学习如何在现实世界中高效地运用这个工具。感谢您对现实世界 SQL Server Profiler 课程的关注。
Recent Review from Similar Course "This was my first dba course. The course flowed well and the instructor seemed confident in his knowledge. Instructor stayed on topic and didn't get sidetracked by going down 'rabbit trails' of additional content, which can sometimes happen. I would definitely take another class with the same instructor." Phil Carpenter Microsoft SQL Server Profiler is a graphical user interface to SQL Trace for monitoring T-SQL Statements of Database Engine SQL Server Profiler is a powerful tool that allows you to capture and analyze events. This information can be used to identify and troubleshoot many SQL Server-related problems. One of the things that separate less knowledgeable DBAs from exceptional ones is that exceptional DBAs know how to take full advantage of the tools available to them. Even though Profiler can be used to monitor analysis services and integration services its core use is for tracking down real world issue that happen within SQL Server's database engine. In this course, we are going to cover the architecture of SQL Server Profiler and then use it to track down performance related issues. In the course, we are also going to cover the nomenclature in detail. What's an event and for that matter what's an event class? How do I use them? The interface isn't that intuitive and in this course we will walk through all the tabs and their meaning as well as learn how to use them to capture only what we want to see, not the thousands of lines we don't need. With profiler, we can: create traces, watch the trace capture the spids in real time, store it, replay and even save the output to a server to others can view the results in table format. There are several reasons profiler isn't used more often in the real world. Firstly, the interface isn't well designed, secondly it creates a ton of data when it's not filtered and lastly it can consume a lot of resources on the server. If the profiler is configured appropriately to trace only relevant data for analysis, it will diminish the additional load that is introduced while it is running. If profiler is run for a longer duration, then to capture the event of longer duration it is very important to collect selective data, otherwise the collected data can outgrow the space on the server. In this course, we are going to learn how to ameliorate all the "issues" with the tool and learn how to use it effectively in the real world. Thanks for your interest in Real World SQL Server Profiler.
