Tag | Internals Posts

SQL Server together with other RDBMS, are the most memory consuming applications on our servers, and this is because, RDBMs usually cache objects into the memory to take advantage of the speed that physical memory offers. Sadly when windows feels that its physical memory is currently not enough for a driver and/or processes that is requesting some resources, it is forced to trim some of currently running application’s memory working set. Now that is bad news for SQL Server because windows will be ...
Assembly is the smallest unit of deployment in .NET Framework. When you compile your C# code, it will get converted into a managed module. A managed module is a standard EXE or DLL. This managed module will have the IL (Microsoft Intermediate Language) code and the metadata. Apart from this it will also have header information. The following table describes parts of a managed module. Part Description PE Header PE32 Header for 32-bit PE32+ Header for 64-bit This is a standard Windows PE header which ...