Tag: performance

How to Test Azure Web Application Performance through Microsoft Azure and Visual Studio

Azure, Cloud, Tools & technologies, Visual Studio

Before deploying your application into production, doing a performance load test is imperative for...
Read More

How to Move Datafiles in SQL Server – Part 1

Database administration, Work with data

Introduction There are a number of situations which would warrant the movement of database files or transaction log files from one volume...
Read More

Basics of sys.dm_exec_requests

Database administration, Performance Tuning

Performance monitoring and troubleshooting in SQL Server is a vast topic. In SQL Server 2005, dynamic management views, also known as...
Read More

Main Usage of sys.dm_os_wait_stats

Database administration, Database development, Troubleshooting Issues, Views

As you know, the main responsibility of the database administrator lies in the monitoring of the...
Read More

How SQL Server 2016 Took Azure SQL Data Warehouse to Next Level

Azure, Cloud

Azure SQL DW (SQL Data Warehouse) is a massively parallel, petabyte-scale, cloud solution for data warehousing based on SQL. It is highly...
Read More

Consolidating SQL Server Instance by Clustering and Stacking

Database administration, Performance Tuning

NOTES: Windows Failover Clustering comprising two nodes. Two SQL Server Failover Cluster Instances. This configuration optimizes the...
Read More

Main concept of SQL Server locking

Database administration, Security

In this post, we will discuss the SQL Server lock mechanism and how to monitor SQL Server locking...
Read More

Choosing Azure SQL Purchase Model and Service Tier

Azure, Cloud

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...
Read More

SQL Server TempDB Monitoring by Using Dynamic Management Views (DMV)

Database development, Views

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,...
Read More

Identifying and Fixing Forwarded Records Performance Issue

Database administration, Troubleshooting Issues

Before going through the Forwarded Records performance issue and resolving it, we need to review...
Read More
Close