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

In a move to speed online transaction processing (OLTP), Microsoft is adding in-memory capabilities into its SQL Server relational database management system.

How much server memory is enough, and for how long? Brien works through the math as part of his ongoing hardware refresh.

Microsoft has RTM'd SQL Server 2014, which includes a new in-memory OLTP engine built jointly by Microsoft Research and the SQL Server team.