SQL Profiler的工作机制 [英] working mechanism of SQL Profiler

问题描述

有人可以帮助我详细了解SQL事件探查器的完整工作机制/工作流程吗?

Can somebody help me to understand the complete working mechanism/workflow of a SQL Profiler in detail ?

推荐答案

SQL Server Profiler [ ^ ]
使用SQL事件探查器进行监视 [ SQL Server Profiler逐步 [ ^ ]

这些是Google搜索结果中

SQL Server Profiler[^]
Monitoring with SQL Profiler[^]
An, this one from CodeProject - SQL Server Profiler Step by Step[^]

These are top 3 links from Google search result for SQL Profiler[^]

SQL事件探查器通常用于跟踪注入到sql server数据库的查询.
现在，它具有过滤选项，还可以通过多种方式过滤查询泛滥.

需要有关每个选项的更多详细信息以及对您有什么帮助，那么这里是链接?
必须阅读..

http://www.sqlmag.com/article/tsql3/using-sql-profiler [ ^ ]


希望这会有所帮助，如果是，那么请接受并投票答复.任何对此的任何疑问/问题都将受到欢迎.

谢谢&问候
RDBurmon.Sr.Software工程师

SQL Profiler is generally used to trace query injected to sql server database.
Now it has filtration option also to filter the query flood by numerous way.

Want more details regarding each option and How it is useful for you then here is the link ?
Must read..

http://www.sqlmag.com/article/tsql3/using-sql-profiler[^]


Hope this helps , If yes then plz accept and vote the answer. Any queries / questions on this are always welcome.

Thanks & Regards
RDBurmon.Sr.Software Engineer

SQL Server Profiler 是用于创建和管理跟踪以及分析和重播跟踪结果的丰富接口.

events are saved in a trace file，以后可以在尝试诊断问题时进行分析或用于重播一系列特定步骤.

我们可以使用SQL Server Profiler进行以下操作

• 创建跟踪
• 在跟踪运行时观察跟踪结果
• 将跟踪结果存储在表中
• 开始，停止，暂停，并根据需要修改跟踪结果
• 重播跟踪结果

SQL Server Profiler is a rich interface to create and manage traces and analyze and replay trace results.

The events are saved in a trace file that can later be analyzed or used to replay a specific series of steps when trying to diagnose a problem.

We can do the following using SQL Server Profiler

• Create a trace
• Watch the trace results as the trace runs
• Store the trace results in a table
• Start, stop, pause, and modify the trace results as necessary
• Replay the trace results

• 监视SQL Server实例的性能.
• 调试Transact-SQL语句和存储过程.
• 识别执行缓慢的查询.
• 测试在项目开发阶段，通过单步执行语句来确认代码是否按预期方式运行，即可确定SQL语句和存储过程.
• 通过捕获生产系统上的事件并在其上重放事件来对SQL Server中的问题进行故障排除.测试系统.这对于测试或调试目的很有用，并且允许用户继续使用生产系统而不会受到干扰.
• 审核和查看在SQL Server实例上发生的活动.这使安全管理员可以查看任何审核事件，包括登录尝试的成功和失败以及访问语句和对象的权限的成功和失败.

• Monitor the performance of an instance of SQL Server.
• Debug Transact-SQL statements and stored procedures.
• Identify slow-executing queries.
• Test SQL statements and stored procedures in the development phase of a project by single-stepping through statements to confirm that the code works as expected.
• Troubleshoot problems in SQL Server by capturing events on a production system and replaying them on a test system. This is useful for testing or debugging purposes and allows users to continue using the production system without interference.
• Audit and review activity that occurred on an instance of SQL Server. This allows a security administrator to review any of the auditing events, including the success and failure of a login attempt and the success and failure of permissions in accessing statements and objects.

这篇关于SQL Profiler的工作机制的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！