项目中调试SQLServer 方便的查看SQL语句的执行时间的方法
第一种方法, 先记录执行前的时间,然后在记录执行Sql后的时间,然后做减法 1 第一种方法: 2 declare @begin_date datetime 3 declare @end_date datetime 4 select @begin_date = getdate() 5 SELECT COUNT( 1 ) 6 -- 要执行的SQL语句 7 FROM [dbo].[DT_CV
第一种方法,先记录执行前的时间,然后在记录执行Sql后的时间,然后做减法
<span> 1</span> <span>第一种方法: </span><span> 2</span> <span>declare @begin_date datetime </span><span> 3</span> <span>declare @end_date datetime </span><span> 4</span> <span>select</span> @begin_date =<span> getdate() </span><span> 5</span> SELECT COUNT(<span>1</span><span>) </span><span> 6</span> --<span>要执行的SQL语句 </span><span> 7</span> <span> FROM [dbo].[DT_CVPrice] </span><span> 8</span> WHERE DCVP_CharacterGUID = <span>'</span><span>3434343</span><span>'</span> <span> 9</span> ---------- <span>10</span> <span>select</span> @end_date =<span> getdate() </span><span>11</span> <span>select</span> datediff(ms,@begin_date,@end_date) <span>as</span> <span>'</span><span>用时/毫秒</span><span>'</span>
第二种方法,将执行每个语句时采取的步骤作为行集返回,通过层次结构树的形式展示出来
<span> 1</span> <span>set</span><span> statistics profile on </span><span> 2</span> <span>set</span><span> statistics io on </span><span> 3</span> <span>set</span><span> statistics time on </span><span> 4</span> <span>go </span><span> 5</span> --<span>写SQL语句的地方 </span><span> 6</span> SELECT *<span> FROM [dbo].[DT_CVPrice] </span><span> 7</span> <span> 8</span> <span> 9</span> <span>go </span><span>10</span> <span>set</span><span> statistics profile off </span><span>11</span> <span>set</span><span> statistics io off </span><span>12</span> <span>set</span> statistics time off
第2个方法效果如下图,
第三种方法 ,用Sql Server 自带的工具
位置:工具》选项》查询执行》高级
效果如图,

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

C++ multi-thread debugging can use GDB: 1. Enable debugging information compilation; 2. Set breakpoints; 3. Use infothreads to view threads; 4. Use thread to switch threads; 5. Use next, stepi, and locals to debug. Actual case debugging deadlock: 1. Use threadapplyallbt to print the stack; 2. Check the thread status; 3. Single-step the main thread; 4. Use condition variables to coordinate access to solve the deadlock.

How to use LeakSanitizer to debug C++ memory leaks? Install LeakSanitizer. Enable LeakSanitizer via compile flag. Run the application and analyze the LeakSanitizer report. Identify memory allocation types and allocation locations. Fix memory leaks and ensure all dynamically allocated memory is released.

Efficiently debug Lambda expressions: IntelliJ IDEA Debugger: Set breakpoints on variable declarations or methods, inspect internal variables and state, and see the actual implementation class. Java9+JVMTI: Connect to the runtime JVM to obtain identifiers, inspect bytecode, set breakpoints, and monitor variables and status during execution.

This article introduces shortcuts for Go function debugging and analysis, including: built-in debugger dlv, which is used to pause execution, check variables, and set breakpoints. Logging, use the log package to record messages and view them during debugging. The performance analysis tool pprof generates call graphs and analyzes performance, and uses gotoolpprof to analyze data. Practical case: Analyze memory leaks through pprof and generate a call graph to display the functions that cause leaks.

Concurrency testing and debugging Concurrency testing and debugging in Java concurrent programming are crucial and the following techniques are available: Concurrency testing: Unit testing: Isolate and test a single concurrent task. Integration testing: testing the interaction between multiple concurrent tasks. Load testing: Evaluate an application's performance and scalability under heavy load. Concurrency Debugging: Breakpoints: Pause thread execution and inspect variables or execute code. Logging: Record thread events and status. Stack trace: Identify the source of the exception. Visualization tools: Monitor thread activity and resource usage.

Tools for debugging PHP asynchronous code include: Psalm: a static analysis tool that can find potential errors. ParallelLint: A tool that inspects asynchronous code and provides recommendations. Xdebug: An extension for debugging PHP applications by enabling a session and stepping through the code. Other tips include using logging, assertions, running code locally, and writing unit tests.

Common PHP debugging errors include: Syntax errors: Check the code syntax to make sure there are no errors. Undefined variable: Before using a variable, make sure it is initialized and assigned a value. Missing semicolons: Add semicolons to all code blocks. Function is undefined: Check that the function name is spelled correctly and make sure the correct file or PHP extension is loaded.

C++ debugging functions that contain exception handling uses exception point breakpoints to identify exception locations. Use the catch command in gdb to print exception information and stack traces. Use the exception logger to capture and analyze exceptions, including messages, stack traces, and variable values.
