Caching SQL Execution Plans

Question

I know that SQL Server 2005 does some caching of the execution plan, but will that be enough to make the difference between the clocks between the same query that is executed twice? The first time it takes 3 hours the next time it takes 1 min? Is it possible?

Answer 1

SQL Server will not just cache the execution plan as well as the data

if you do

SET STATISTICS IO ON

, , - , - . , ,

3 , - /, ..

Answer 2

! !

!
, , ().

, ​​:

• / /
• ( SQL ..)

: 3 , 1 , , , .
, ...
, , (, update/insert/delete, , ), SELECT , ( /).

, :

• () . , -, , 3 .
• "" ( ) .

( SQL-Server):

dbcc freeproccache
go
dbcc dropcleanbuffers
go

Answer 3

, ( " " ) , , . , .

( "" ) , , , .

, 3 , , .

, (, - ).

Answer 4

. , , (, ), .

, : INSERT INTO Table (Field) VALUES (1). , , . 750 10%, 75 , SQL Server , 30 . .

The point here is not that during the execution you had or did not have a growth event. The fact is that if the request lasts 3 hours, you need to understand why. Activity Monitor is a great start. Reading white paper, such as "Waiting for Performance," would be even better.