Hi Jeff

thanks so much for the response

How do I tell SQL to use that proxy account to run the script ?

there is no option “run as “if i choose type...

Guys .. it took 8 hours to restore and i found out the memory is only 12 GB hahaha

thats why it is very very slow !!!

thanks for the feedback

Thanks for the reply all . Much appreciated ..

tonight i will try alter table rebuild and see how it goes

Thanks All

Hi All,

Many thanks .

I decided to deny connect the account to SQL .

Sorry ,

My bad … it should be DISK IS BUSY MORE THAN 90% ( not 50% ) 🙂

Thanks for the response

Another concern is the alert that we get if CPU usage is very high or Disk is busy more than 50% ...

As a DBA , I need...

Thanks for the response All

How about if I run Full DBCC CheckDB in Mirror server and DBCC CheckDB with Physical Only in Primary server ?

as We have ALWAYS ON configuration...

Thanks for the response

Questions:

How do I Check and in which situation to see if I am getting a lot of Rollbacks?

So far the only situation when I see rollback is...

Thanks John ..Will try

Thanks for your response .

I tried your query yesterday ( 19/02/2020 ) and use this command : WHERE last_execution_time >= '2020-02-15'

The result that I got is the records starting from...

Thank you . I will try it

Thanks so much for the advice All !

Thanks Jeff

Sure will look for it

Thanks for the response Guys . Much appreciated

Quoting from Jeff Moden,

"Shifting gears a bit, what you should really do is be very concerned about your "shrinking process".  That's normally one...