No question at this time
DBA Top 10
1 M. Cadot 6300
2 B. Vroman 2700
3 P. Tsongayinwe 1500
4 P. Wisse 1300
4 J. PĂ©ran 1300
6 A. Kavsek 900
7 D. Walgude 400
7 J. Schnackenberg 400
9 J. Alcroft 200
10 A. Hudspith 100
10 L. Ywema 100
10 D. Johnson 100
10 B. B 100
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48709
Total active users1322
Act. users last 24h2
Act. users last hour0
Registered user hits last week33
Registered user hits last month217
Go up

sqlserver sql removes script execution plan/stats immediately after completion
Next thread: ORA-01017: invalid username/password; logon denied
Prev thread: ORA-01653: unable to extend table table_name by 8192 in tablespace tablespace _name

Message Score Author Date
One of the sql script running multiple times a day...... Sandeep Negi Jun 07, 2022, 09:00
Sorry but this is an Oracle forum as you can see...... Michel Cadot Jun 07, 2022, 10:01

Follow up by mail Click here


Subject: sqlserver sql removes script execution plan/stats immediately after completion
Author: Sandeep Negi, India
Date: Jun 07, 2022, 09:00, 174 days ago
Os info: Windows Server 2012 R2
Oracle info: SQL Server 2014 Standard Edition
Message: One of the sql script running multiple times a day from application end is performing slow in Production environment where as its performing very well in Non-Production environment where as the amount of data in tables is higher in Non-Production database and the statistics and execution plan of last executed script is available in cache.

One of the findings is that SQL Script executed doesn't hold its execution plan or statistics in cache, it gets immediately flushed out once the script completes its execution.
the other point is that when using option(recompile) in script, it completes execution with expected duration.
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: sqlserver sql removes script execution plan/stats immediately after completion
Author: Michel Cadot, France
Date: Jun 07, 2022, 10:01, 174 days ago
Message:
Sorry but this is an Oracle forum as you can see on top left of the page:
"Welcome to DBA-Village, your primary Oracle DBA information source.
Geert De Paep"

Regards
Michel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here