Kumar GD

Hello Friends, Thanks for visiting my blog. My name is Kumar GD, and I am currently working as a Consultant in an IT company that provides IT services to multiple organizations worldwide. I have around 18+ years of experience with Microsoft Technologies. I have worked in various big organizations in IT pure development, E-Commerce, Asia's biggest entertainment company, Healthcare domain, etc. I started my career as a .Net developer (Windows as well as Web Apps), and after a few years, I moved to database administration. Both experiences helped me to understand user problems & provide solutions. I just started this blog to help newcomers, freshers, and IT guys who just started their careers to learn & understand client issues and provide solutions as soon as possible. Thanks for visiting my blog & I hope you'll help/ encourage me to continue this blog for newcomers, freshers, and IT guys. Thanks a lot. Kumar GD.

Discover Sos_Scheduler_Yield: Explore 10 Perf Killer

08/02/202409/08/2023 by Kumar GD

Although SQL Server is renowned for its stable performance, it occasionally has wait types that reduce its effectiveness. One of them is SOS_SCHEDULER_YIELD, a frequent wait type that might impact query execution. This article covers the SOS_SCHEDULER_YIELD wait types in full, including their history, causes, benefits, drawbacks, and practical mitigation techniques. It also offers brief … Read more

Discover Async_Network_IO: Top 5 Reason

08/04/202409/07/2023 by Kumar GD

A popular relational database management system, the SQL Server, frequently runs across different delays affecting performance. One such wait type that might impede query execution is ASYNC_NETWORK_IO. We’ll go into the specifics of ASYNC_NETWORK_ IO wait types in this post, looking at their background, causes of recurrence, benefits, drawbacks, and practical strategies to reduce them. … Read more

Discover Resource_Semaphore Wait Type: Top 10 Usage

08/09/202409/06/2023 by Kumar GD

Resource_Semaphore Wait Type In SQL Server

In SQL Server deployments, RESOURCE_SEMAPHORE wait types are a frequent bottleneck that causes performance deterioration and user annoyance. To solve this problem successfully, it’s crucial to grasp the various kinds of delay involved and how to lessen their impact. Introduction of Resource_Semaphore Wait Type Imagine that your SQL Server is running slowly, and queries that used … Read more

WRITELOG Wait Type: Demystifying

09/11/202309/05/2023 by Kumar GD

In SQL server setups, WRITELOG wait types are a regular source of worry. These particular delay events can affect the performance of databases. To guarantee the effective running of their SQL servers, database managers and developers must understand WRITELOG wait kinds. Introduction of WRITELOG Wait Type: Disc I/O operations on SQL servers are connected to … Read more

Query Store: A Powerful Tool

04/23/202409/03/2023 by Kumar GD

Database administrators and developers may control and improve the efficiency of SQL queries using the Query Store feature in Microsoft SQL Server. It was first made available in SQL Server 2016 and has since been improved. The Query Store has many features to enhance query performance. Introduction A persistent problem in the changing world of … Read more

SQL Server 2022: Best Admin Power

04/14/202509/01/2023 by Kumar GD

The most recent version of Microsoft’s relational database management systems is called SQL Server 2022. It is made to make data storage, retrieval, and modification easier for both enterprises and private users. SQL Server 2022’s cutting-edge capabilities and improvements will reimagine how we interact with data. Introduction to SQL Server 2022 Explore the world of … Read more