Without any license you could only install SQL Express 🙂

For any other SQL you need licenses and for any HA (eg. SQL Cluster)/DR solution you need that these licenses will...

Hi, are you able to connect from node02  to node01 using ssms or sqlcmd? SQL port is open between these two nodes?

Hi, how you are doing this backups? Manual, SSIS task or some procedure eg. Ola Hallengren? What with backup files, are they generated? You may making log backups on other...

Hi, check resource utilization especially IO (disk latency, disk queue length), CPU or SQL dumps. It is often caused by SQL extremely high IO resource utlizaiton, so high that Windows...

You can still use sp_WhoIsActive when the query is executing to check what kind of waits are slowing down the query or status whatever it is running/runnable or else in...

Hi, few cases that may occur on primary especially when index rebuild was running are:

• blocking: you should spot this on

  select * from sys.dm_exec_requests where blocking_session_id>0?

  or even...

Hi, this is correct behavior dtexec.exe is a command line tool to call ssis packages if you want GUI version DTExecUI.exe you should have it installed with SSMS  eg. C:\Program...

"The msdb mdf files were copied and restored, but the jobs were built from scratch in the new DB." so here is yours problem. This is not supported method for...

Hi, error message is clear 🙂 but you can confirm this with Azure support team.

Hi

any errors in sqlagent error log? Jobs during migration were scripted and recreated or msdb mdf files were copied?

Any trigers on system tables in msdb database?

Any session blocked in sys.dm_exec_requests?

How...

You can query details using sys.dm_db_stats_properties https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-db-stats-properties-transact-sql?view=sql-server-ver15

SELECT sp.stats_id, name, filter_definition, last_updated, rows, rows_sampled, steps, unfiltered_rows, modification_counter   
FROM sys.stats AS stat   
CROSS APPLY...

Hi, you got correct query in first response from https://stackoverflow.com

SELECT request_session_id FROM sys.dm_tran_locks WHERE resource_database_id = DB_ID('YourDatabaseName')

the session that is using DB will be holding...

Hi, cluster require votes majority to stay online in your case 3 nodes in DC1 has majority, check Node & File Share Majority Quorum configuration mode in the Windows Failover...

Hi,

probably best will be using some group email, if not you can add multiple email addresses separeted by ; to operator but be careful because there is characters limit if...

Hi,

1. Double/triple check the sids because looks like they differ if there are no matching, or if you can just recreate them using sp_help_revlogin proc

2. Check the error log during...