Development · Performance Tuning

How to collected inventory for SQL Server using Microsoft Assessment and Planning (MAP) tool

Hi friends, We need to collect inventory for database migration as well as platform to set up environment for migration, development and testing. Is there any tool from Microsoft to achieve this scenario? Yes, we have Microsoft Assessment and Planning Tool (MAP) for it. From BOL: The Microsoft Assessment and Planning (MAP) Toolkit is an… Continue reading How to collected inventory for SQL Server using Microsoft Assessment and Planning (MAP) tool

Performance Tuning · Uncategorized

SQL Server Execution Plan Operator – Table Scan

In my previous blog we discussed about the different format of SQL Server execution plan. Now in upcoming blogs we will discussed about the most commonly seen operators we see when execution plan generates. In this post I will start the easy one that is Table Scan operator. As with the name of operator Table… Continue reading SQL Server Execution Plan Operator – Table Scan

Development · Performance Tuning · Uncategorized

SQL Server Execution Plan formats

Execution plan helps in knowing how a query gets executed and troubleshooting a query which is performing poor. In SQL Server execution plan can be of 2 types: Estimated Execution plan Actual Execution plan Execution plan can be viewed in 3 different formats: Text format XML format Graphical format We can choose the format on… Continue reading SQL Server Execution Plan formats

Development · Performance Tuning

SQL Server – Cleaning Procedure Cache for a particular database

HI friends, most of the time we used DBCC FREEPROCCACHE to clear the procedure cache, clears the specific plan from cache by specifying plan handle or SQL handle. DBCC FREEPROCCACHE does not require any parameters. To clear the plan cache we just need to execute below query – DBCC FREEPROCCACHE Whenever we execute this command,… Continue reading SQL Server – Cleaning Procedure Cache for a particular database

Performance Tuning · Uncategorized

How Client Statistics helps in improving performance in SQL Server

Client Statistics is SQL Server data tool which is very helpful in determining the statistics that how much data received from server to the client side. In other words, client statistics helps in analyzing the traffics load like packets/bytes sent and received at client – server side. When we run a script or query in… Continue reading How Client Statistics helps in improving performance in SQL Server