The tuning of hardware resources typically involves the discovery of bottlenecks. A bottleneck is the single resource that consumes the most time during a task execution. In the case of SQL Server, such resource bottlenecks adversely affect the performance of normal relational database operations. Therefore, the following information pertains to the detection of SQL Server resource bottlenecks and the subsequent adjustment of the resource to relieve the demand and increase performance.