Common cause of the performance issues

2 Replies

Below are the most common reasons for the performance issues.

SQL Server Configuration Issues

Database/table/schema Design and Configuration Issues

CPU/IO/Memory Bottleneck

Blocking

Network Bottleneck

Poor Indexing Strategy (Missing Index, Fragmented Index, Un-Used Index)

Out-of-date/missing statistics

T-SQL Code

Application Code

2 thoughts on “Common cause of the performance issues”

swetha December 15, 2011 at 8:34 pm

hi,
I am swetha.i joined in infrastructure company .I am in sql track .can u please suggest any books for sql good practices an in administration part and guide me how can i succeed to achieve as dba.please guide me .i am fresher

Reply ↓
1. Jugal Shah Post authorDecember 20, 2011 at 8:08 am
  
  For architecture level knowledge go for Wrox Publication, read the blogs, MSDN site, BOL and again participate in forums Q & A
  
  Reply ↓

Leave a reply to Jugal Shah Cancel reply