I came across Microsoft SQL Server error 15174 while dropping a login. As error suggests, the login which i want to drop is set as owner for databases. Let us check the database owner and then change the ownership to...
Sometimes AOAG configuration stuck in resolving state and its secondary Replica does not come online. When you check the Alwayson Availability Group configuration, you find it showing in resolving state after Automatic failover of AOAG Configuration. Let us get the...
Have you ever thought how SQL Server controls the size of packets which are send over the network. There is a server configuration option network packet size in SQL Server. The value of this configuration are used to control the...
Today, I got a requirement to limit the number of concurrent user connections on a SQL Server Instance. SQL Server provides an option user connections in server level configurations to set or limit the maximum number of simultaneous user connections...
SQL Server is memory intensive database system and most resource intensive operations in SQL Server are DISK IO operations. SQL Server uses memory to minimize disk IO operations by creating a buffer pool where it hold pages read from the...
Today, i am going to discuss about virtual log files in SQL Server and query to find number of virtual log files present in transaction log files. Related Articles: Why Should You Always Turn Off Database Auto Shrink Property? Understand...
Have you deep dive into SQL Server checkpoint process like what checkpoints are and how they work? Here is an article which will explain you about checkpoint process in SQL Server. What is Checkpoint Process in SQL Server? As per...
Today, i will talk about SQL Server Transaction Log File Architecture. As we know, every database must have at least one transaction log file (Tlog file) that captures everything happens on database to maintain data integrity of the database. Logically,...
SQL Server data files, pages & extents are very much related to each other. These are architectural terms which are used to store data physically inside the database. First let’s start with data files then we will understand how data...
Have you ever thought how to protect stored procedure codes deployed on your SQL Server Instance? When deploying applications to a client’s server(s) or to a shared SQL Server, there is often a concern that other people might peek at...
Normally, ASYNC_IO_COMPLETION Wait type can be seen during backup and restore activities. Whenever you will see this wait type your backup/restore process will be in suspended state most of the time because the process is waiting to get IO resource...
Today I was working on an issue in which backup job was showing in executing state since last 2 days.Initially my observation was either it was hung in middle of its process or it was processing very slow. Later, i...
RESOURCE_SEMAPHORE waits occurs when a query memory request cannot be granted immediately due to other concurrent queries. High waits and wait times may indicate excessive number of concurrent queries, or excessive memory request amounts. High waits on RESOURCE_SEMAPHORE usually result...
 Wait Types are awesome way to troubleshoot performance related issues. In SQL Server 2005 and later version we can get wait type info from various DMVs. One of the most useful DMV is sys.dm_qs_wait_stats.This DMV gives you the detail report...
Generally we don’t need this info for user database but when you have to recover or restore master database then you should have exact database version or build no else you cannot recover your database like i am giving you...
