Monthly Archives: March 2017

Basic Application Support Skills


As  i have been involved in application support work in current company so i tried to find out basic skill set that i need to have to work in this domain. As i understood application support is about supporting a … Continue reading

Aside | Posted on by | Leave a comment

Investigation for Slow SQL Query : SQL Profiler & Server Side Traces


Its really very time consuming to identify the slow query running on the MS SQL server earlier we were not aware about the tools but after SQL Server Profiler we got some understanding for query analysis . We will be … Continue reading

Aside | Posted on by | Tagged , , , , , , | Leave a comment

MS SQL Server Performance Killers


We are working to find out the best root cause analysis of performance troubleshooting for MS SQL Server . 1.Incorrect plan used by Stored Procedure 2.No indexes 3.Inefficient queries – Bad estimates causing has joins and index scan 4.Inaccurate\missing statistics … Continue reading

Aside | Posted on by | Leave a comment

Tools used for Performance Evaluations


To resolve the issues related to performance issues MS SQL server we need to be aware about the below tools for resolving the issues : Dynamic Management Views (DMVs) and System Catalog Views Profiler and Server Side Traces Windows Performance … Continue reading

Aside | Posted on by | Leave a comment

Database Exploration for Performance Tuning


We have MS SQL 2008 R2 Database server in our environment but we are currently not aware in case there are more performance issue coming in the environment. After learning some of the issues and technical reference we thought to … Continue reading

Aside | Posted on by | Leave a comment

Performance Tuning in MSSQL 2008 R2


Find out the index missing from the database using DMVs SELECT  TOP 25 [Total Cost]  = ROUND(avg_total_user_cost * avg_user_impact * (user_seeks + user_scans),0) , avg_user_impact — Query cost would reduce by this amount, on average. , TableName = statement , … Continue reading

Aside | Posted on by | Leave a comment