Over next few posts I am going to talk about "a" methodology to do performance assessment / tuning of SQL Server based applications. Main focus will be on SQL Server engine but wherever necessary references to changes needed in application code (non T-SQL, non schema based, non configuration options etc.) will be made. I would love to hear your thoughts and comments on this.
SQL Server performance issues show up in following categories –
Basic essential information
Before starting performance investigation it is necessary to collect basic information about the machine.
Typical resources which can become bottleneck in SQL Server set up are –
We will look at these various resources to understand why it has become bottleneck and what can be done to reduce its impact.