Clota Blog

Category: SQL Server

  • SQL Server Checkpoint and Lazy Writer

    Good day, everyone! I hope you’re doing well, and Today I’ll show you how to use SQL Server’s Checkpoint and Lazy Writer functions, as well as the many types of checkpoints available. Checkpoint- Fig.1 Advantages of Checkpoint- Types of Checkpoints- There are four different kinds of checkpoints in SQL Server. Automatic checkpoint- When SQL Server…

  • New features of SQL Server 2022

    Hello guys, hope you are doing well. In this blog I’m going to discuss about the “New features of SQL Server 2022”  The release of the SQL Server 2022 is much anticipated by the audience since the announcement of it being in the works on November 2nd, 2021. Although the complete details of this brand-new version will…

  • Step by Step Implementation of Instant File Initialization

     Hello guys, In this blog, I will discuss about step by step implementation of “Instant File Initialization” in SQL Server STEP- 1: You must first open the instance in SSMS, then do the following query: Fig-1 This is the result of executing a query: Fig-2 You must update Y to N in the Instant _File Initialization…

  • Enabled DAC to connect remotely

    Hello there, everyone! I hope everything is going well for you. Today, I’ll show you how to use the DAC and how to enable it for remote connections. DAC- The dedicated admin connection (DAC) can assist you in getting out of a bind. This was created to assist you in connecting to SQL Server and…

  • Steps to configure Hide DB Instance

    Hey guys, In this blog I am going to explain you about “Hide DB Instance” STEP -1: To begin, start SSMS and connect to the server. STEP -2: Expand Database Engine in Network Servers and look for any servers                   connected to Database Engine, as shown below.                  Now, if…

  • AOG on Azure Blob with a different region SQL Server instance

    Hello there, everyone! I hope everything is going well for you. Today, I’ll show you AOG on Azure Blob with different region SQL Server Instance. Ø Created SQL disk layout and formatted with 64K- ·       Disk E: SQL Binaries ·       Disk T: TempDB ·       Disk R: User Databases ·       Disk L: User DB transaction logs Ø SQL Server Memory Configuration as…

  • Deterministic and Nondeterministic Functions

    Deterministic functions: Deterministic functions always result in the same output every time they are called with a fixed set of input values and given the same condition of the database.  For example, AVG() function always results the same result given the qualifications stated above. Nondeterministic functions: Nondeterministic functions result in different output each time they…

  • Buffer Cache Hit Ratio

    Hey guys, In this blog I am going to explain you about Buffer Cache Hit Ratio Buffer Cache Hit Ratio- It is a pool of memory pages into which data pages are read. In other words, the data pages which are read from Disk are stored in Memory (Cache) to provide data faster. When a Data Read…

  • Page Life Expectancy (PLE) in SQL Server

    Hey guys, In this blog I am going to explain you about Page Life Expectancy and How to monitor it. Page Life Expectancy (PLE)- Page Life Expectancy (PLE) is an age of a data page in seconds in the buffer cache or buffer memory after querying the tables with the loading data page into the buffer memory.…