1

Topic: leaves in never-ending performance

Tried to "wait", surrendered on 5 minutes. Costs it  and all is adjusted - result in 3-5 seconds What is it?

2

Re: leaves in never-ending performance

sanekoffice;
Parameter sniffing

3

Re: leaves in never-ending performance

TaPaK wrote:

sanekoffice;
Parameter sniffing

Understood, thanks!

4

Re: leaves in never-ending performance

sanekoffice wrote:

Tried to "wait", surrendered on 5 minutes. Costs it  and all is adjusted - result in 3-5 seconds What is it?

to Read here: https://sqlperformance.com/2013/08/t-sq … le-options
Fast method of the decision: WITH RECOMPILE on all procedure.
Wiser method: OPTION (RECOMPILE) only on problem requests.
Absolutely wise method: OPTIMIZE FOR for problem requests and parameters.

5

Re: leaves in never-ending performance

[V. Liseev] it is passed...
To read here: https://sqlperformance.com/2013/08/t-sq … le-options
Fast method of the decision: WITH RECOMPILE on all procedure.
Wiser method: OPTION (RECOMPILE) only on problem requests.
Absolutely wise method: OPTIMIZE FOR for problem requests and parameters. [/quote]
And without reflecting at all it is reassigned variables

6

Re: leaves in never-ending performance

TaPaK wrote:

it is passed...
And without reflecting at all it is reassigned variables

It it is equivalent OPTIMIZE FOR UNKNOWN?

7

Re: leaves in never-ending performance

[V. Liseev] it is passed...
It is equivalent OPTIMIZE FOR UNKNOWN? [/quote]
, only it is not necessary to write everywhere smile

8

Re: leaves in never-ending performance

And still most likely becomes outdated mutes. And instead of RECOMPILE to do everyones better these statisticans to update, and that it is mandatory somewhere else . If anywhere they are not created with full scanning that sp_updatestats quite approaches.

9

Re: leaves in never-ending performance

still wrote:

And still most likely becomes outdated mutes. And instead of RECOMPILE to do everyones better these statisticans to update, and that it is mandatory somewhere else . If anywhere they are not created with full scanning that sp_updatestats quite approaches.

I all over do not dispute importance of statistics smile but on yours as procedure re-creation on yours is connected to them???

10

Re: leaves in never-ending performance

TaPaK wrote:

it is passed...
I all over do not dispute importance of statistics smile but on yours as procedure re-creation on yours is connected to them???

Do not slander on itself:-D

11

Re: leaves in never-ending performance

Hupin wrote:

it is passed...
Do not slander on itself:-D

I know that that can entail statistics update, it is interesting that the writer puts. And yes it well absolutely  not panacea

12

Re: leaves in never-ending performance

And in addition the writer let , whether on the table without changes will be  such piece as Parameter sniffing, or too to treat statistics update?

13

Re: leaves in never-ending performance

Check, know not only you
Even it is simple here so:
https://msdn.microsoft.com/ru-ru/library/ms187348 (v=sql.120).aspx
But campaigns you badly know a difference between meaningful dialogue and desire to show that you know more than others

14

Re: leaves in never-ending performance

still wrote:

Check, know not only you
Even it is simple here so:
https://msdn.microsoft.com/ru-ru/library/ms187348 (v=sql.120).aspx
But campaigns you badly know a difference between meaningful dialogue and desire to show that you know more than others

It you appeal to what phrase

15

Re: leaves in never-ending performance

TaPaK;
He/she is the ordinary troll dying of boredom