I tried now during production

EXECUTE msdb.dbo.IndexOptimize

@Databases = 'database',

@FragmentationLow = NULL,

@FragmentationMedium = NULL,

@FragmentationHigh = NULL,

@UpdateStatistics = 'ALL',

@OnlyModifiedStatistics='Y',

@LogToTable='Y'

first with few smaller databases without problem - took about 1minute for each

and...

Grant Fritchey (2/24/2016)

---

Alexander Suprun (2/24/2016)

---

tony28 (2/24/2016)

---

I tried now on few tables and I cannot see some effect during production and we are working in real time, so some little delay...

Alexander Suprun (2/24/2016)

---

tony28 (2/24/2016)

---

I tried now on few tables and I cannot see some effect during production and we are working in real time, so some little delay and I...

Ah, good note with recompile, I didnt know about it. Thanks .

So it can be almost similar effect like after restart server and first load or delete all plan...

And one question.

Thanks to few problems in past , we bought new storage, so our IO is ok, according to my opinion is overrated.

Normally can be there any performance problem...

Grant Fritchey (2/24/2016)

---

You might find that you identify certain tables or certain indexes that need more frequent statistics updates. When you do, you might want to schedule updates on those...

Example:

TABLE1 has xx xxx rows

TABLE2 has xx xxx xxx rows , and for one row in TABLE1 are xx rows inside TABLE2

Query:

select * from TABLE1 (NOLOCK) A...

have to wait for weekend.

will check this post and after weekend will see. thanks

MMartin1 (2/22/2016)

---

I would point you to Jeff Moden post and see his link on how to post code problems. It would help us to better help you if you read...

MMartin1 (2/22/2016)

---

Why only select one row? Why table1 only? I still dont understand the...

Steve Jones - SSC Editor (2/22/2016)

---

I'm still not quite sure what you mean with the language barrier, but maybe this helps.

A trigger is a stored procedure that runs when data...

Hello,

sorry for my english and confusing... you have to understand that is not my native language..

Hugo Kornelis : I dont have problem with this. this is only thinking , why...

Hello,

thank you for responses..

it was only thinking, because supplier for new app told me about using trigger, and I told him that we every time use procedure for getting...

ok thank you, so It looks good, without any problem... because I investigated the error 833 with some heavy load to disk and it...

yes i was thinking about this.. but almost for full io ?

check images below