aiDeeva.com

Common cause of the performance issues

Written by

Jugal Shah

in

, , , ,

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

Comments

2 responses to “Common cause of the performance issues”

  1. swetha Avatar
    swetha

    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 Avatar
      Jugal Shah

      For architecture level knowledge go for Wrox Publication, read the blogs, MSDN site, BOL and again participate in forums Q & A

      Reply

Thanks for the comment, will get back to you soon… Jugal Shah

More posts