暂时无法在支持网站上提交享有定期维护的产品表单。 如果您需要我们立即提供帮助,请与技术支持部门联系。 对于由此给您带来的不便,我们深表歉意。
获得即时帮助
完成注册
登录
请求定价
联系销售人员
您已选择一个产品捆绑包。 您能否选择单个产品以便我们更好地满足您的请求。 *
技术支持工程师目前正忙,无法回应您的消息。 如果需要即时服务,请通过我们的服务请求表提交请求。
以下文章可根据您的描述解决您的问题。
The SQL Performance Event facility contains event classes used to monitor Showplan events and events that are produces from the execution of SQL Data Manipulation Language (DML) operators.
Auto Stats – Async Completed
Created when an automatic updating of index and column statistics has occurred asynchronously; job completed. (Disabled by default)
Medium
Auto Stats – Async Queued
Created when an automatic updating of index and column statistics has occurred asynchronously; job queued. (Disabled by default)
Auto Stats – Async Starting
Created when an automatic updating of index and column statistics has occurred asynchronously; job starting. (Disabled by default)
Auto Stats –Sync
Created when an automatic updating of index and column statistics has occurred synchronously. (Disabled by default)
Degree of Parallelism – Delete
Created when SQL Server executed a DELETE statement. (Disabled by default)
Degree of Parallelism - Insert
Created when SQL Server executed an INSERT statement. (Disabled by default)
Degree of Parallelism – Select
Created when SQL Server executed a SELECT statement. (Disabled by default)
Degree of Parallelism – Update
Created when SQL Server executed an UPDATE statement. (Disabled by default)
Performance Statistics - Cached Query Destroyed
Created when a cached query has been destroyed and the historical performance data associated with the plan is about to be destroyed. (Disabled by default)
Performance Statistics – New Batch SQL Text
Created when new batch SQL text is not present in the cache. (Disabled by default)
Performance Statistics – Queries in Ad Hoc Statement Compiled
Created when queries within an ad hoc SQL statement have been compiled. (Disabled by default)
Performance Statistics – Queries in Stored Procedure Compiled
Created when queries within a stored procedure have been compiled. (Disabled by default)
Showplan All
Created when SQL Server executes a SQL statement. (Disabled by default)
Showplan All for Query Compile
Created when SQL Server compiles a SQL statement. (Disabled by default)
Showplan Statistics Profile
Showplan Text
Created when SQL Server executes a SQL statement. This event class stores each event as binary data. (Disabled by default)
Showplan Text (Unencoded)
Created when SQL Server executes a SQL statement. This event class is the same as the Showplan Text event class, except the event information is formatted as a string rather than as binary data. (Disabled by default)
Showplan XML
Created when SQL Server executes a SQL statement. This event class stores each event as a well-defined XML document. (Disabled by default)
Showplan XML For Query Compile
Showplan XML Statistics Profile
SQL: FullTextQuery
Created when SQL Server executes a full text query. (Disabled by default)
The SQL Progress Report Event facility contains the Progress Report: Online Index Operation event class.
Progress Report: Online Index Operation – Done
Created when an Online index build operation is done.
Progress Report: Online Index Operation – Inserted Row Count
Created when a row count is inserted during an Online index build operation.
Progress Report: Online Index Operation – Stage 1 Execution Begin
Created when an Online index build operation stage 1 execution begins.
Progress Report: Online Index Operation – Stage 1 Execution End
Created when an Online index build operation stage 1 execution ends.
Progress Report: Online Index Operation – Stage 2 Execution Begin
Created when an Online index build operation stage 2 execution begins.
Progress Report: Online Index Operation – Stage 2 Execution End
Created when an Online index build operation stage 2 execution ends.
Progress Report: Online Index Operation – Start
Created when an Online index build operation starts.
The SQL Query Notifications Event facility contains event classes that report information that developers and administrators can use to monitor and troubleshoot query notifications.
QN: Dynamics – Clock Run Finished
Created when the background thread in the Database Engine that schedules expired parameter tables for cleanup has finished. (Disabled by default)
QN: Dynamics – Clock Run Started
Created when the background thread in the Database Engine that schedules expired parameter tables for cleanup has started. (Disabled by default)
QN: Dynamics – Master Cleanup Task Finished
Created when cleanup to remove expired query notification subscription data finished. (Disabled by default)
QN: Dynamics – Master Cleanup Task Skipped
Created when the Database Engine did not perform cleanup to remove expired query notification subscription data.
QN: Dynamics – Master Cleanup Task Started
Created when cleanup to remove expired query notification subscription data has started. (Disabled by default)
QN: Parameter Table – Cleanup Task Finished
Created when cleanup for all subscriptions in a parameter table has finished.
QN: Parameter Table – Cleanup Task Started
Created when cleanup for all subscriptions in a parameter table has started.
QN: Parameter Table – LRU Counter Reset
Created when the usage count for the parameter table has been reset.
QN: Parameter Table – Number of Users Decremented
Created when the number of query notification subscriptions that reference a parameter table has decreased.
QN: Parameter Table – Number of Users Incremented
Created when the number of query notification subscriptions that reference a parameter table has increased.
QN: Parameter Table – Table Attempt Failed
Created when the database tried to drop an unused parameter table and failed.
QN: Parameter Table - Table Created
Created when a parameter table has been created in the database.
QN: Parameter Table – Table Drop Attempt
Created when the database has attempted to automatically drop an unused parameter table to free resources.
QN: Parameter Table – Table Dropped
Created when the database successfully dropped a parameter table.
QN: Parameter Table – Table Pinned
Created when the parameter table is marked for current usage by internal processing.
QN: Parameter Table – Table Unpinned
Created when the parameter table has been unpinned.
QN: Subscription Table – Broker Error Intercepted
Created when a Service Broker delivers an error in the conversation that the query notification uses.
QN: Subscription Table – Firing Failed With Broker Error
Created when a notification message fails due to a Service Broker.
QN: Subscription Table – Firing Failed Without Broker Error
Created when a notification message fails but is not due to a Service Broker error.
QN: Subscription Table – Subscription Deletion Attempt
Created when the Database Engine attempts to delete an expired subscription to free up resources.
QN: Subscription Table – Subscription Deletion Failed
Created when the attempt to delete an expired subscription has failed.
QN: Subscription Table – Subscription Destroyed
Created when the Database Engine successfully deletes an expired subscription.
QN: Subscription Table – Subscription Fired
Created when a notification subscription produces a notification message.
QN: Subscription Table – Subscription Registered
Created when the query notification subscription is successfully registered in the database.
QN: Subscription Table – Subscription Rewound
Created when the Database Engine receives a subscription request that exactly matches an existing subscription.
QN: Template – Created
Created when a query notification template has been created in the database.
QN: Template – Dropped
Created when a query notification template is removed from the database.
QN: Template – Matched
Created when a query notification template is reused.
The SQL Scan Event facility contains scan events.
Scan: Started
Created when a table or index scan is started. (Disabled by default)
Scan: Stopped
Created when a table or index scan is stopped. (Disabled by default)
您可以在附属支持站点上查找适用于戴尔*产品*的在线支持帮助。单击“继续”,转至适用于*产品*的正确支持内容和帮助。
The document was helpful.
选择评级
I easily found the information I needed.
Quest Software门户不再支持IE 8、9和10,建议将您的浏览器升级到最新版本的Internet Explorer或Chrome。
要升级到IE 11,请单击此处
要升级到Chrome,请单击此处
如果继续使用IE 8、9和10,您将无法充分利用我们所有出色的自助服务功能。