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've said it before and I'll say it again: If you want to speed up your application, don't look at your code, look at your data access. The two slowest things you can do in application development are ...

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. Dany Lepage 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 ...

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 ...