什么是SQL事件探查器 [英] what is SQL Profiler

问题描述

什么是SQL事件探查器?这有什么好处?有什么替代品吗?

Bye

Hi,

what is SQL Profiler? what is the advantages of this? Is there anything substitute of this?

Bye

推荐答案

阅读此说明: http: //msdn.microsoft.com/zh-CN/library/ms181091.aspx [

Read this description : http://msdn.microsoft.com/en-us/library/ms181091.aspx[^]

SQL Profiler helps you see your performance problems and gives you advise on indexes which will boost performance.

SQL Profiler is tightly integrated into the SQL Server platform so substitutions will be lacking (and it is supplied with your SQL license anyway).

Google是您的朋友.

Microsoft SQL Server Profiler是SQL Trace的图形用户界面，用于监视数据库引擎或Analysis Services的实例.

有关更多信息，请阅读以下内容:

http://msdn.microsoft.com/en-us/library/ms181091.aspx [ ^ ]

http://www.careerride.com/SQL-server-SQL-Profiler-purpose.aspx [ ^ ]

SQL Server Profiler逐步 [

Google is your friend.

Microsoft SQL Server Profiler is a graphical user interface to SQL Trace for monitoring an instance of the Database Engine or Analysis Services.

For more information read these:

http://msdn.microsoft.com/en-us/library/ms181091.aspx[^]

http://www.careerride.com/SQL-server-SQL-Profiler-purpose.aspx[^]

SQL Server Profiler Step by Step[^]

hope it helps :)

SQL Profiler允许您监视和捕获SQL Server实例上的事件.您可以将其配置为捕获所有事件或仅捕获需要监视的一个子集
参考链接:- SQL Profiler的优点 [使用SQL事件探查器 [链接-[Sql Server Profiler] [ AnjLab SQLProfiler [ ^ ]
适用于MySQL数据库服务器的查询分析工具，可帮助您发现性能瓶颈，繁重的SQL查询和访问最多的数据库表.
用于MySQL的Jet Profiler [

SQL Profiler allows you to monitor and capture events on an instance of SQL Server. You can configure it to capture all events or just a subset that you need to monitor
Reference Link :- Advantages of SQL Profiler[^]
for further reference Using SQL Profiler [^]
and This Link-[Sql Server Profiler][^] refering two substitute.
From Reference
The express edition of Microsoft SQL Server 2005/2008 is free. But it doesnt provide professional tools for profiling sql queries. SQL Server Express Edition Profiler provides the most of functionality standard profiler .
AnjLab SQLProfiler[^]
Query profiling tool for the MySQL database server, helps you spot performance bottlenecks, heavy sql queries and most accessed db tables.
Jet Profiler for MySQL[^]

这篇关于什么是SQL事件探查器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！