Ya, it was deigned like that. I...

Thank you, Client would go with 8...

Thank you. Got it now.

One final, doubt, if we increase 1 socket with 8 cores, I believe SQL will go for 1 socket.

• This reply was modified 2 years, 11 months ago by  Saran.

Hi,

Understood. If I go with CPU to 1 socket with 4 cores, will the SQL use 4 CPUs?

Hi,

Thanks for your response. It is a VM runs on windows 2019 with SQL 2019, I believe it is IaaS in the could.

It is a small application and both DB...

• This reply was modified 2 years, 11 months ago by  Saran.
• This reply was modified 2 years, 11 months ago by  Saran.
• This reply was modified 2 years, 11 months ago by  Saran.

Thank you, I will try test it out.

Hi,

Thanks for your response. It is a simple DR drill, just for one database and there is no transactional replication etc.

It is not a GUI based log shipping. It is...

Hi Steve,

Thanks for your response. I will check with the vendors of N/W configuration.

No linked server, both SQL and front end are in same host.

Thanks for your response.

Yes, it is default instance port is 1433. I have asked the vendor UDP 1434 already been disabled. I am not sure, how spammer / hackers are...

Anyone can confirm.

Thank you for your reply. I have not asked why they said like that, yes it could be in same physical disk. I will check with them. It is win-2003...

• This reply was modified 3 years, 4 months ago by  Saran.
• This reply was modified 3 years, 4 months ago by  Saran.
• This reply was modified 3 years, 4 months ago by  Saran.
• This reply was modified 3 years, 4 months ago by  Saran.
• This reply was modified 3 years, 4 months ago by  Saran.

I have tried could not get expected results. Can anyone have script.

Thanks for your detailed response. I will try to write some code, I do only basic code writing and will try CET.

Hi ScottPletcher,

It is not working.

This is working same as Lowell script, but the whole script returns zero rows.

I have checked some job is failed in the last run, that is...

• This reply was modified 3 years, 5 months ago by  Saran.

Hi Lowell,

I run into another problem, I when run this code to get the report almost 10+servers, I could get lot of failed jobs ex:100+ jobs.

When I go and manually...