News

Server:DL380 G5 dual dual core 2.33Ghz, 4GB RAMWin2K3 Std R2 SP1 x64SQL 2005 Std SP2 x64This weekend the SQL box chewed through every last bit of memory available. I came in this morning finding ...
Hoping to speed online transaction processing, Microsoft is adding in-memory features to its SQL Server relational database manager. The next version of SQL Server will allow users to host ...
More details are emerging about in-memory capabilities in the new SQL Server 2014, announced at the recent TechEd 2013 conference. The first Community Technology Preview is expected to be released ...
Use max_server_memory to guarantee the OS does not experience detrimental memory pressure. To set max server memory configuration, monitor overall consumption of the [!INCLUDEssNoVersion] process in ...
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.
In [!INCLUDE sssql22-md] Cumulative Update 17 and later versions, a component known as the Hekaton DLL generator was added to the In-Memory OLTP feature.Without the new Hekaton DLL Generation ...
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 ...