the events I captured as below

Stored Procedures

RPC:Completed

SP:StmtCompleted

TSQL

SQL:BatchCompleted

I used SQL Profiler to trace SQL scripts and got one sql statement with 53142 reads (as picture), but I executed that sql statement but found its...

the “Reads” of SQL Server profiler is the times of the logical read?

• This reply was modified 4 years, 1 month ago by 892717952. Reason: mistyping

I used SQL Profiler to trace SQL scripts and got one sql statement with 53142 reads (as picture), but I executed that sql statement but found its logical...

One possible explanation, assuming identical parameter values, is that a plan recompile occurred. The execution from Profiler was in one plan and the execution from SSMS was in a...

I read your question a little differently than Grant and Jeff, so I just wanted to confirm what you were looking to do.

If I understand your question correctly, you...

well noted,Than you Jeff...

Thank you Grant Fritchey!

1. how can we check the cache for DMVs and  how to set the cache for DMVs( or how to set the cache for different...

I notice that even if we don't restart SQL Service, the data of sys.dm_exec_query_stats( sys.dm_exec_sql_text() and sys.dm_exec_query_plan() ) will be reset or removed/refreshed. when the data of sys.dm_exec_query_stats...

The DMVs are completely dependent on the cache. That's where the information comes from. So, anything that affects the cache, will affect the data in the DMVs. For example,...

• This reply was modified 4 years, 2 months ago by 892717952.

Good day!

anyone can help me the said question? thanks!

So your saying that the following code that you posted took over 5 hours?

SELECT sm.Object_ID, Definition = ls.LongString FROM sys.SQL_Modules sm CROSS APPLY dbo.ShowLongString(sm.Definition) ls

I just ran that code...

Considering that my last name contains only 5 letters and you couldn't even spell that right, I suspect a PICNIC  problem on your part.  The code runs nasty fast...

I had published an article for doing such a thing and a fellow by the name of Orlando Colamatteo gave me the idea of the following...

when you get really big strings like that, and want to visualize them in SSMS, you can TRY_CONVERT to xml; then when you click it , it opens in...