SQL Server Memory (RAM) Managment

-
SQL Server's memory configuration is one of the most important settings. The memory usage of SQL Server varies depending on the version of SQL Server you are using and the processor architecture you are using. SQL Server performs some operations in memory (In-Memory) for performance.



There are 2 types of memory management in SQL Server.

1) Dynamic Memory Management: SQL Server does not specify any upper limit, and SQL Server occupies and uses as much memory space as it can use. however, when any other application needs memory, the partition occupied by SQL Server is allocated to that application. The main disadvantage of dynamic memory management is that SQL Server is busy during the allocation of memory to different applications.

2) Static Memory Management: The minimum and maximum amount of memory that SQL Server can use is determined and does not go beyond that. SQL Server does not exceed the specified maximum value, and the remaining amount of memory is available for other applications.

Now, let's see a sample table about SQL Server Memory Configuration of a 64-bit machine. However, this sample data is only required for the SQL Server Database Engine. Additional memory will be required for additional applications, such as SQL Server Agent, Integration Services.

This is the end of my blog! Thank you for taking the time to read (: 

Bu blogdaki popüler yayınlar

Windows LNK File Analysis in Forensic System Reviews

-
Resim
The concept of Recent Files is used to describe the most recently accessed files by the user, and in a forensics review, determining which applications were viewed by the user most recently and which documents were viewed could be of critical importance in the event resolution. In a Windows operating system, a shortcut file for files opened by the user is created under the Recent directory in the profile directory associated with that user’s account. These files can be analyzed to determine which files the user last accessed. In particular, even if files that are deleted or wiped by the user cannot be accessed, the shortcut files associated with them can be accessed and retrieved information about them. Where LNK extension link files are stored varies depending on the operating system. These files : Windows XP : \Documents and Settings\UserName\Recent \Documents and Settings\UserName\Application Data\Microsoft\Office\Recent Windows Vista and Windows 7 : ...
Devamı

SQL Injection Payload List

-
Resim
In this section, we’ll explain what SQL injection is, describe some common examples, explain how to find and exploit various kinds of SQL injection vulnerabilities, and summarize how to prevent SQL injection. What is SQL injection (SQLi)? SQL injection is a web security vulnerability that allows an attacker to interfere with the queries that an application makes to its database. It generally allows an attacker to view data that they are not normally able to retrieve. This might include data belonging to other users, or any other data that the application itself is able to access. In many cases, an attacker can modify or delete this data, causing persistent changes to the application’s content or behavior. In some situations, an attacker can escalate an SQL injection attack to compromise the underlying server or other back-end infrastructure, or perform a denial-of-service attack. SQL Injection Type : In-band SQLi (Classic SQLi) :  In-band SQL Injection is the most co...
Devamı