1

Topic: Whether the server because of "the superfluous" statistics can brake

Good afternoon.
On the table it is created about 10 statistics on different parameters.
Whether it can is negative will be reflected in speed of performance of requests?

2

Re: Whether the server because of "the superfluous" statistics can brake

Statistics auto update is included in a DB.
Automatic creation is ungeared.

3

Re: Whether the server because of "the superfluous" statistics can brake

I love ;
statisticans, what?

4

Re: Whether the server because of "the superfluous" statistics can brake

In global sense, maintenance of statistics it too server resources, if  expenditures on it it can be reflected.

5

Re: Whether the server because of "the superfluous" statistics can brake

Certainly, the spherical server in vacuum should expend some resources on maintenance and usage of statistics.
I.e. to "brake" in your terminology.
But, honestly, it a should principal brake.
Look in a mirror.

6

Re: Whether the server because of "the superfluous" statistics can brake

TaPaK wrote:

in global sense, maintenance of statistics it too server resources, if  expenditures on it it can be reflected.

I am am excited more with curvature of plans...
Whether can because of that that some statistics the plan is selected less optimal? (In 1000 times slower)
Or it lies to herself and lies.

7

Re: Whether the server because of "the superfluous" statistics can brake

  wrote:

I am am excited more with curvature of plans...

It, as a rule, a consequence of curvature of hands of writers of requests and architects of a DB.

8

Re: Whether the server because of "the superfluous" statistics can brake

invm wrote:

it is passed...
It, as a rule, a consequence of curvature of hands of writers of requests and architects of a DB.

Whether and plans can "fly" because of that that a great number of statistics on the table?

9

Re: Whether the server because of "the superfluous" statistics can brake

I love ;
Yes that you so that went in cycles in an amount of statistics? To you already told that it is far not the very first harm and destruction "superfluous" you a little that achieves.
ps: the optimality, as well as freshness, has no gradation. Only optimal/not optimum. Any more/less. Renew concept of an optimum of the mathematician.

10

Re: Whether the server because of "the superfluous" statistics can brake

  wrote:

it is passed...
Whether and plans can "fly" because of that that a great number of statistics on the table?

The plan can become outdated at statistics change, i.e. not at everyone and at roughly speaking "globally" change. You generally understand what to be stored in statisticans?

11

Re: Whether the server because of "the superfluous" statistics can brake

TaPaK wrote:

it is passed...
The plan can become outdated at statistics change, i.e. not at everyone and at roughly speaking "globally" change. You generally understand what to be stored in statisticans?

That in statistican approximately I represent.
Simply some of this statistics  3 months ago.
I so understood that while 20 % of the table not to change - SQLServer itself statistics does not update (auto_update stat).

12

Re: Whether the server because of "the superfluous" statistics can brake

I love ;

https://www.red-gate.com/simple-talk/sq … tatistics/

13

Re: Whether the server because of "the superfluous" statistics can brake

Thanks, .
By the way, how to look at statistics in a DB, which for a long time not ?

14

Re: Whether the server because of "the superfluous" statistics can brake

Under the link the real tin is described... Thanks.

15

Re: Whether the server because of "the superfluous" statistics can brake

Here such question still.
Tell, whence there is statistics on the table?
In it is not present indexes keys.
I will not understand.
sad((

16

Re: Whether the server because of "the superfluous" statistics can brake

Here DB options.
Automatic creation of statistics there is disconnected. (The third on top a column).

17

Re: Whether the server because of "the superfluous" statistics can brake

  wrote:

Here DB options.
Automatic creation of statistics there is disconnected. (The third on top a column).

For you, the Goats, the server conducts the separate statistics.

18

Re: Whether the server because of "the superfluous" statistics can brake

It would be desirable to hear the answer of mentally healthy person.

19

Re: Whether the server because of "the superfluous" statistics can brake

I love ;
"Statistics of automatic creation" () the Master of Iodine

20

Re: Whether the server because of "the superfluous" statistics can brake

TaPaK wrote:

I love ;
"Statistics of automatic creation" () the Master of Iodine

, here it that!!!
It of "Automatic creation of statistican" actually. smile))

21

Re: Whether the server because of "the superfluous" statistics can brake

  wrote:

it is passed...
, here it that!!!
It of "Automatic creation of statistican" actually. smile))

Mentally healthy people do not put Russian studios

22

Re: Whether the server because of "the superfluous" statistics can brake

TaPaK wrote:

it is passed...
Mentally healthy people do not put Russian studios

That truly that is true...

23

Re: Whether the server because of "the superfluous" statistics can brake

[img=https://im0-tub-ru.yandex.net/i?id=5f35fe53aec95661f8b362378619f281-l&n=13]

24

Re: Whether the server because of "the superfluous" statistics can brake

auto close from basis to remove and the server ;
It is not enough that 2005, so also RTM 8-o

25

Re: Whether the server because of "the superfluous" statistics can brake

o-o wrote:

auto close from basis to remove and the server ;
It is not enough that 2005, so also RTM 8-o

and where at it auto close