If I have a SQL server process that has been running for some time, are there any methods to determining how much memory it really needs to run? I have a couple of low usage databases and I want to ...

I have a Debian install with KVM + Libvirt love. I've got a Windows Server 2008 R2 VM running with 3 drives. Originally they were set to VirtIO, but I have since changed two of the three to SATA. The ...

New in-memory online transaction processing (OLTP) improvements highlight the new features in the latest Community Technology Preview (CTP) of SQL Server 2016, the flagship RDBMS from Microsoft. SQL ...

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. Spencer Judge discusses the architectural ...

How about “Dude, Where Is My Memory? Understanding Microsoft SQL Server Memory Usage and Management” by Maciej Pilecki. I thought SQL Server just grabbed all the memory it could and never gave it back ...

A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...