How to Test Azure Web Application Performance through Microsoft Azure and Visual Studio
Before deploying your application into production, doing a performance load test is imperative for...
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 transaction log files from one volume...
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...
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 warehousing based on SQL. It is highly...
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...
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 decide on a proper purchase model, a service...
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...
