how to trace query in sql server profiler

Tags: trace altered default tracking object modificationSQL SERVER default tracking app 3--Detection ofDDL operations for tablesDDL operations that occur on the SQL Server database, can you tell who did it?Yes. The SQL Server defa

Starting with SQL 2012, Microsoft has made a cache mechanism to make insert auto increment faster.Although this mechanism is good, but also has the troublesome situation, if your SQL suddenly restart, then this cache losesThis time causes your SQL auto increment Id to jump 1000 Suddenly, for example from 45,46...1047.If you care about the order of this number.The

Tags: des style blog http using IO data forThe test that appears in the following SQL Server and MySQL is a table (except for special instructions)1. View the script created by the tableSQL Server:Mysql:Show create TABLE test;2. View table structureSQL ServerSp_columns test;OrSp_help test;Mysql:Show columns in test;OrDESC test;3. See which tables are in the databaseSQL Server:Select name from sysobjects whe

Tags: black box trace Blackbox TraceSQL Server black box Trace--Deep advancedWhen you report an error to the support provider, make sure to provide the BLACKBOX.TRC and Sqldiag.txt files.To create a blackbox.trc file:1. Create a Trace2. Turn on tracking3. Stop tracking before running the SQLdiag toolYou can use the following stored procedure, Trace_blackbox, to g

event, and the cause of the incident results.So is the above sentence valid in the trigger, the answer is no.Here's a big trick:CREATE TABLE #inputbuffer ( nvarchar ),smallint, nvarchar(4000) )insert into #inputbuffer EXEC('DBCC INPUTBUFFER (@ @SPID)')The key is to get a statement that triggers the current SPID, returning three fields. If triggered by a stored procedure, returns the stored procedure nameAfter taking the original statement, we can determine whether the dat

Yesterday's SQL Server query performance optimization-index creation principle (I) mainly introduced the principle. today are some of the main principles and checks the created indexes. Iii. indexing principles In general, building indexes depends on the data usage scenarios. In other words, which SQL statements are co

SQL Server connection query details, SQL Server Query details When querying multiple tables, we often use "join query ". Connection is the main feature of the relational database model

But by default, if not filtered, the lock information captured by the profiler contains locks inside SQL Server, which is very inconvenient for us to view the lock information, so we often need to filter the columns as shown in 6. Figure 6: Filtering out the database lock information The captured information is shown in 7. Figure 7. Information captured by t

partial database backup and file backup. The new restore statement allows you to use full or partial database backup and record file backup for restoration. These replace the dump and load statements in earlier versions of SQL Server. For a complete list of new statements and options for SQL Server 7.0 and

T-SQL query advanced-understanding the lock introduction in SQL Server, each query will find the shortest path to achieve their goals. If the database only accepts one connection, only one query is executed at a time. Therefore, q

shows the DMV. It is worth noting that the SYS. dm_tran_locks DMV shows the database lock at the query time point and does not contain any history lock records. It can be understood as the snapshot when the database is locked at the query time. SYS. dm_tran_locks contains two types of information: Information about the resource where the lock is located starting with resource, and information about the a

generally require a lot of memory, so called expensive)Need to request memory, at the same time they can run out of computer memory.To prevent this from happening, SQL Server uses something called a " resource semaphore ." This will ensure that the total memory allocation of the query being executed will not exceedThe sum of memory in the current computer. When

Label:Original: SQL Server 2012:SQL Server architecture--The life cycle of a query (part 1th)To reduce the scope of the read operation, this article first looks at a simple select query and then introduces additional procedures re

about what the database engine is doing. With the trace tool, we can monitor 180 events. In these events, we can view details of the user's login and lock activity through a special session ID (SPID). This data is generated through SQL Server Profiler, as well as a series of serve