Go up
sqlserver sql removes script execution plan/stats immediately after completion
| Subject: |
sqlserver sql removes script execution plan/stats immediately after completion |
| Author: |
Sandeep Negi, India |
| Date: |
Jun 07, 2022, 09:00, 26 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, 26 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