SQL Server Memory Allocation & Role of MIN/MAX Server Memory Configuration
SQL Server is memory intensive database system and most resource intensive operations in SQL Server are DISK IO operations. SQL…
8 years ago
SQL Server
How to Get Total Number of Virtual Log Files inside SQL Server Database Log Files?
Today, i am going to discuss about virtual log files in SQL Server and query to find number of virtual…
8 years ago
What is Checkpoint Process in SQL Server?
Have you deep dive into SQL Server checkpoint process like what checkpoints are and how they work? Here is an…
8 years ago
Understanding SQL Server Transaction Log File Architecture
Today, i will talk about SQL Server Transaction Log File Architecture. As we know, every database must have at least…
8 years ago
Understanding SQL Server Data Files, Pages & Extents
SQL Server data files, pages & extents are very much related to each other. These are architectural terms which are…
8 years ago
How to Protect Stored Procedure Code in SQL Server?
Have you ever thought how to protect stored procedure codes deployed on your SQL Server Instance? When deploying applications to…
12 years ago
Understanding ASYNC_IO_COMPLETION Wait type in SQL Server
Normally, ASYNC_IO_COMPLETION Wait type can be seen during backup and restore activities. Whenever you will see this wait type your…
14 years ago
How to fix BACKUPBUFFER Wait Types?
Today I was working on an issue in which backup job was showing in executing state since last 2 days.Initially…
14 years ago
How to Fix RESOURCE_SEMAPHORE Wait Type in SQL Server?
RESOURCE_SEMAPHORE waits occurs when a query memory request cannot be granted immediately due to other concurrent queries. High waits and…
14 years ago
What is SQL Server Wait Type? or How to get wait type info in sql server?
Wait Types are awesome way to troubleshoot performance related issues. In SQL Server 2005 and later version we can get…
14 years ago