Best Practices to Configure SQL Server on New Server

A few best practices are given below to configure SQL Server on a newly built server:

1. Choose correct hardware:- Assuming the correct hardware specification has been selected as per user requirement & estimated load on the server.

2. Sufficient Memory:- We should allocate sufficient memory to the server as well as SQL Server to provide better performance.

As per best practice, allocate :

10-20% of total physical memory as min. memory to SQL Server,

75-80% of total physical memory as min. memory to SQL Server.

Left at least 20% for OS & other processes.

What are differences between FAT and NTFS?

Differences between FAT and NTFS

FAT is also known as File Allocation Table.

NTFS is also known as New Technology File System.

Both file systems technologies are different and used by multiple operating systems to manage and store data on storage devices like HDD or flash drive.

A few key differences between FAT and NTFS are given below for your reference:

1. File Size and Volume Size: 

The maximum file size in FAT32 is 4 GB and the maximum volume size is 2 TB. 

The maximum file size in NTFS is 16 EB and the maximum volume size is 256 TB.

2. Fragmentation:

Fragmentation in FAT is more likely than in NTFS. 

When a file is scattered across different sectors of a disk is known as Fragmentation which causes slow operations like reading values from a file. But in NTFS, it uses advanced concepts & methods to manage file allocation & reduces the possibility of fragmentation.

3. Fault Tolerance:

Fault Tolerance in NTFS is better than FAT. In case of a system crash or any disaster, NTFS can recover data more easily than FAT. But in FAT, we may face some data corruption or data loss-related issues.

4. Security:

Multiple security-related advanced features are available in NTFS which are not available in FAT. For example, file and folder permissions, encryption and auditing, etc.

5. Fault Tolerance:

NTFS has a better fault tolerance than FAT. 

In case of any disaster or system crash, we can recover data easily in NTFS but in FAT, we may face data corruption or loss.

6. Compatibility:

FAT file system is widely used by multiple operating systems. 

As we aware, the default file system for Windows is NTFS but macOS or Linux OS are not supporting NTFS.

What are differences between NTFS and ReFS?

Differences Between NTFS and ReFS

NTFS stands for New Technology File System.

ReFS stands for Resilient File System.

Microsoft has developed both file systems technologies for Windows OS.

Few major differences between NTFS and ReFS are as follows:

1. File Size Limit: NTFS supports file sizes up to 16 exabytes, while ReFS supports file sizes up to 262144 exabytes.

2. Scalability: We can use NTFS for small and large storage devices but in the case of large storage devices, need to use ReFS.

3. Release: In the mid-1990s, the NTFS file system was released and currently it is widely used in many small & large organizations but the ReFS was released in 2012 with Windows Server 2012 and is a new system.