Hi,

I guess the main problem can be with some shared features. But still prefer to create a new server with a new SQL version.

I had also one issue with the...

Hi,

only for future,

if you will have some migration and will be diff service account but for example cluster name or listener will be same, dont forget delete SPN from old...

I can't...

• This reply was modified 5 years, 6 months ago by tony28.
• This reply was modified 5 years, 6 months ago by tony28.

Hi,

ah I see something like this, but everywhere they presented that is new feature also for system dbs, so it looks like wasnt released .

thanks for info

yes i tried all of these settings.

we have 50. I checked that this query costs about 1400-1500 for MAXDOP 1 , of course then is worked.

Only question is what can...

Hi,

plans are different

yesterday:

for maxdop 1 is diff

for maxdop 2,3 was same

another wasnt possibel to finish so i dont know

today

for maxdop 1 is diff

for maxdop 2,3,4 same

for maxdop 5,6,7,8 same

not sure...

Hi,

thanks for info.

Only question, if you have something like this, why you still using Ola ? Because i am thinking why is not written like quick backup solution, for example...

Hello,

any info ?

thanks

Ok, 

so with some testing I see that
([database_principal_name]='dbo') 

should be all sysadmin and also dbo, but not sure if I am really right. But for now...

([server_principal_name]='sa' OR [server_principal_name]='sysadmin')   

sa was ok, but another sysadmin didnt catch..