Clota Blog

Category: SQL Server

  • Memory Grants Pending

    Hello there, everyone! I hope everything is going well for you. Today In this blog I am going to explain you about Memory Grants Pending and How to monitor it. Memory Grants Pending- The number of processes that are pending a workspace memory grant is known as Pending. Because they are unable to acquire adequate RAM while…

  • Detach and Attach in SQL Server

    Hello there, everyone! I hope everything is going well for you. Today, I’ll show you about Detach and Attach Detach SQL Server Database- A SQL Server database is made up of at least two files: a data file (mdf) and a log file (ldf), though there may be additional data files in some circumstances. Since…

  • Fragmentation

     Hey guys, In this blog I am going to explain you about Fragmentation and its types and how to detect fragmentation and fix it. SQL Server index fragmentation is a common source of database performance degradation. Fragmentation occurs when there is a lot of empty space on a data page (internal fragmentation) or when the logical…

  • SQL Interview Questions

    You can benefit from this article’s popular SQL Server DBA interview questions and answers. To learn more about SQL interview questions, I would advise you to read this post as well as the SQL Server Interview questions and answers. I made an effort to be very specific in my responses to each question in this…

  • All about tempDB

    Hey guys, In this blog I am going to explain you about TempDB TempDB is a workhorse of SQL Server performing a number of functions to support both system and internal operations. With this workload TempDB will process a large number of database writes, which requires low-latency, high throughput underlying storage. What about tempDB Size? It…

  • PostgreSQL Index and Types

    Hey guys, In this blog I am going to explain you about PostgreSQL Index and Types. PostgreSQL Index- The database search engine can use indexes, which are specialized lookup tables, to speed up data retrieval. An index is simply a pointer to information in a table. An index in a database resembles a book’s back…

  • SQL Server’s in-memory OLTP technology

    Hey guys, In this blog I am going to explain you about SQL Server’s in-memory OLTP technology. Introduction- A native stored procedure compiler and specialized, memory-optimized relational data management engine are both built into SQL Server as part of In-Memory OLTP. For the most demanding OLTP workloads, Microsoft created In-Memory OLTP. In many instances, the…

  • SQL DBA Hand Book

    Performance Monitoring ====================================================================================================================== SQL Server Error Log ======================================================================================================================Database Maintenance ====================================================================================================================== Missing Indexes in a DB ===================================================================================================================== Transaction Space Utilization Info ===================================================================================================================== SQL Server Statistics ====================================================================================================================== DB Backup and Restore History ====================================================================================================================== AOAG Log Sync Analysis ====================================================================================================================== Important SQL Server Scripts URL ====================================================================================================================== PowerShell to read a big file ====================================================================================================================== All About Tempdb

  • IO Subsystem Analysis

    SQLIO.exe is a tool provided by Microsoft that can be used to determine the I/O capacity of a given configuration.  Installation:-> Step 1. Configure Param.txt The first step is to modify the file param.txt to tell SQLIO where to find its test file which is named testfile.dat. Parameter Description Values file name Name of the test file R:\testfile.dat number…