How to Move Datafiles in SQL Server – Part 1
Introduction There are a number of situations which would warrant the movement of database files or...
Basics of sys.dm_exec_requests
Performance monitoring and troubleshooting in SQL Server is a vast topic. In SQL Server 2005, dynamic management views, also known as...
Main Usage of sys.dm_os_wait_stats
As you know, the main responsibility of the database administrator lies in the monitoring of the SQL Server performance and intervening in...
How SQL Server 2016 Took Azure SQL Data Warehouse to Next Level
Azure SQL DW (SQL Data Warehouse) is a massively parallel, petabyte-scale, cloud solution for data...
Consolidating SQL Server Instance by Clustering and Stacking
NOTES: Windows Failover Clustering comprising two nodes. Two SQL Server Failover Cluster Instances. This configuration optimizes the...
Main concept of SQL Server locking
In this post, we will discuss the SQL Server lock mechanism and how to monitor SQL Server locking with SQL Server standard dynamic...
Choosing Azure SQL Purchase Model and Service Tier
When we are beginning to think of migrating our on-premises databases to Azure SQL, we have to...
SQL Server TempDB Monitoring by Using Dynamic Management Views (DMV)
What is TempDB in MS SQL Server? TempDB is a system database in Microsoft SQL Server used as a store of internal objects, row versions,...
Identifying and Fixing Forwarded Records Performance Issue
Before going through the Forwarded Records performance issue and resolving it, we need to review the structure of the SQL Server tables....
Monitoring Azure SQL Database with Azure SQL Analytics
The most important and challenging responsibility of a database administrator is monitoring...
