They are already storing our pictures on Google cloud infra, so it makes sense they run more services thru them.

My think I am, they obviously do not know their mom very well 😂😂😂😂

Not just the SQL Server patching. I heard some senior IT management official talking about how unnecessary patching was because is a repetitive process

I love how easy you explained the difference between the CU and the GDR patches. I'm not a DBA by any chance but took the SQL Operations responsibility for the datacenter team that I belong to.

Great article Glenn. I work on an organization were we recently decided to on-board all legacy SQL Servers to azure to keep'em under support, because users are a bit difficult to convince. And we are also starting to on-board 2019 servers, so Azure will take care of updates.

Seems like both

Nada más lo lamento por un par de rosca izquierdas que no tengo sus números y que no usan esto

¡Estas hermoso!

La memoria RAM es fundamental para el rendimiento de las bases de datos, ya que permite el almacenamiento temporal de datos y el procesamiento de consultas a alta velocidad.

El monitoreo de memoria en los gestores de bases de datos es una tarea crítica debido a la naturaleza intensiva en recursos de estas aplicaciones.

El mismo te dirá la cantidad memoria asignada y la memoria que el servidor tiene comprometida.

SELECT committed_kb/1024 [SQL Server Committed Memory in MB],
committed_target_kb/1024 [SQL Server Target Committed Memory in MB]
FROM sys.dm_os_sys_info;

Si además quieres ver la demanda de memoria y la asignada a SQL puedes correr el siguiente script.

Corre este script, que te dirá la memoria física disponible además de la total en el servidor.

SELECT total_physical_memory_kb/1024 [Total Physical Memory in MB],
available_physical_memory_kb/1024 [Physical Memory Available in MB],
system_memory_state_desc
FROM sys.dm_os_sys_memory;