I think that depends on the tools you have and what you mean by memory and CPU utilization.  I expect you are looking for an average load, but looking at...

without knowing what you are trying to do on the database, I am not sure what direction to point you in.

But a good starting point would probably be sys.databases.  It...

Yep.  It is called "Data Migration Assistant" and it applies to multiple SQL Server versions, not just 2019.

Something to note, it can be a bit of a resource hog if...

It really depends.  Yours looks to be customized as the "Subsequent failures" option is set to run a program (powershell) which I am fairly confident is non-standard.

My approach for systems...

Step 1 - FULL BACKUP.  Take a full backup so you can get back to your current state.

Step 2 - fix the snapshot issue.  Quick google:

https://sql-play.com/2012/02/01/error-message-a-database-snapshot-cannot-be-created-because-it-failed-to-start-when-running-dbcc/

Which basically says you PROBABLY...

Pretty sure it needs access to the internet to do what is needed for license validation.

That being said, why do you need this installed on a server?  I don't think...

As an alternate thing about the performance (just a guess as we have no DDL or query itself), indexes MAY not help.  You say that it is a table with...

I think what Jeffery was getting at was "who is the SQL Server Agent Service set to run as?".  I have a feeling it is NT Authority/System which doesn't have...

To answer your questions I would say "it depends".  For you, I would say do it all application side and just push the row across to SQL with a simple...

The logs are stored on disk along with the SQL instance in a folder called "Logs".  You will be looking for the file "ERRORLOG" (no file extension) and you can...

To me that sounds like it should be a good test set.  I would also try forcing the failover by having the VM go offline (reboot the VM and see...

Have you checked the SQL log?  That will likely tell you what is wrong.

Now, if memory serves, the MSVCP100.dll is the Microsoft Visual C redistributable, so if that got updated...

First question is easy.  SELECT <columns> FROM <table> WHERE <date column> = CAST('09.01.2021' AS DATE)

Second question is a bit more tricky as it depends.  This would likely be handled in...

Quick google brought me to Microsoft's website on that view and to quote them:

Returns counts of different types of index operations and the time each type of operation was last...

Possible? yes.  Would I do it? no.

The reason I wouldn't do it is you are going to have a whole bunch of tables that are named by the date.  Each...