Server:<BR>DL380 G5 dual dual core 2.33Ghz, 4GB RAM<BR>Win2K3 Std R2 SP1 x64<BR>SQL 2005 Std SP2 x64<BR><BR>This weekend the SQL box chewed through every last bit of memory available.

After a few months without a reboot, its at 44% usage of physical memory according to task manager. I know this doesn't represent the amount of RAM the SQL Server processes need, just how much it ...

To gather memory usage on all SQL Server instances that use Hekaton, DBAs could use MS SQL Server’s native software, Microsoft SQL Server Management Studio, run a query against a Dynamic ...

[!INCLUDE SQL Server] Reconfigure the amount of memory (in megabytes) for a SQL Server process used by an instance of [!INCLUDE ssNoVersion]. There are two server memory options, min server memory and ...

The first component is the Management Data Warehouse. This is a relational database, hosted inside SQL Server, which is used for logging performance metadata for another database instance.

Hekaton, Microsoft's coming in-memory database engine, will be built into the next version of SQL Server. Meanwhile, SQL Server 2012 SP1 is now generally available.