Problem Statement: Script to get the virtual file waits for IO waits. Solution: Virtual File waits are useful in identifying the[…]
Read moreCategory: Performance Tuning
MSSSQL Server Tuning – Find Wait stats
Problem Statement: Script to get the SQL Server wait stats. You can find the significance of most common waits below it. Solution:[…]
Read moreMSSQL Server: Find Bad Indexes
Problem Statement: Script to find the Bad indexes Solution: The indexes returned by the below query degrade the performance of the[…]
Read moreMSSQL Server: Find Missing Indexes
Problem Statement: Script to find the missing indexes using 3 different ways. Solution: 1) Find missing indexes using DMVs –Find top ten missing indexes using following DMV SELECT TOP 10 ( user_seeks ) * avg_total_user_cost * ( avg_user_impact * 0.01 ) AS […]
Read moreMSSQL Server: Get VLF counts of all Dbs
Problem Statement:Get the VLF count of all the dbs in a SQL server Instance. Solution: –variables to hold each ‘iteration’ DECLARE @query VARCHAR(100) DECLARE @dbname SYSNAME DECLARE @vlfs INT –table variable used to ‘loop’ over databases […]
Read moreSQL Server-Performance Tuning Tips
Introduction: This document list the ways of improving the performance of T-SQL. It has few tips and techniques that we used[…]
Read moreSQL Server – Cause Of Index Scan
Question: Why Index Scan is happening even thought index exists on predicate column? Ans: Generally,Query Optimizer (QO) tries to use[…]
Read more