There are many ways to view the SQL Execution Plan. 10046 events are one of them. different from other SQL Execution plans, when we encounter complicated SQL statements, we can track SQL statements through 10046 to obtain the logical reads of each
If the execution efficiency of a system is relatively low, a better method is to track user sessions and use the tkprof tool to format the output using the sorting function to find out problematic SQL statements.
For example, first, use the top
trace flag:3604Function:
The output DBCC command returns results to the query window (usually the SSMs window), similar to the display of the Print command;
Use:
Often used to get the output of the DBCC IND, DBCC PAGE command,
Document directory
Usage of the debug and trace classes in the system. Diagnostics namespace
Usage of the debug and trace classes in the system. Diagnostics namespace
Summary
There is a system. Diagnostics namespace in the. NET class library,
Call Trace can print the current stack of function calls. kernel state Call Trace
There are three types of error in the kernel state, namely bugs, oops and panic.
Bugs are minor errors, such as calling sleep during spin_lock, causing a potential
Usage of the debug and trace classes in the system. Diagnostics namespace
Abstract: There is a system. Diagnostics namespace in the. NET class library. This namespace provides some class libraries that interact with system processes, event logs,
Introduction to the console. trace () function in JavaScript, console. trace
When debugging JavaScript programs, you sometimes need to print the stack information of function calls, which can be achieved by using console. trace. The following code
There is a system. Diagnostics namespace in the. NET class library, which provides some class libraries that interact with system processes, event logs, and performance counters. It includes two very useful classes for developers-Debug and trace.
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.