What I see is that you have a single data file for tempdb - you should have more than that...how many will depend on a lot of factors, but you...

Alerts will not cause any performance issues.  Checking policies won't cause any performance issues.

There are a whole set of agent alerts that you can define for AG.  I wrote the following script to add the alerts on my AOAG systems:

...

Because you've effectively turned the...

I would not recommend that approach - combining discrete data elements into a single column will make it much harder to work with that data.

What is the purpose of combining...

You need to validate the constraint connections between your tasks.  For example - if you have a task to perform backups, and 2 separate tasks for notification, then one of...

If you have the following - what do you want to do?

Employed = 'Staff', Non-Employed = 'Not Yet', Retired = 'Soon'

Or...

Employed = 'Soon', Non-Employed = 'Getting Hired', Retired = 'Long...

That is by design - the password is stored 'securely' in the catalog, which means the connection manager dialog box will only allow you to overwrite the saved password.

Why would...

It is not unexpected - it depends on what is processing at the time you look at the utilization.  Temp tables do not retain data - once the connection is...

Try running sp_configure without the reconfigure on your test instance - and see if the values from DBCC CONFIG actually change.  My guess is that they won't change until a...

One thing you stated that is of greater concern to me:

CPU hits max 60% most of the time so no big concerns there

I would say this is actually a...

If you want to be able to list the latest file in a directory - you can use Powershell:

PS> dir | Select -Last 1

If there are other...

Hi Alex,

Its is a full backup. Don't know the reason why , when backup is in progress , it was showing the backup file size as 822 GB but...

You can go directly to the latest service pack - and I would also recommend applying the latest available CU for that service pack.

And yes - when applying to any...

To move cluster resources to another node - you only need to issue Move-ClusterGroup.  You don't need to suspend prior to moving the group...but you do have to issue the...