Conclusion
This article described how to look for performance bottlenecks that may be occurring on your SQL server with memory, processors, or your server's disk subsystem. Identifying these bottlenecks is only half the battle, of course; knowing how to increase performance based on what you find is what really counts. From optimizing queries to choosing a better disk configuration, there are many ways to increase performance. If you're an administrator looking at purchasing and setting up a new SQL server, learning and practicing these strategies can help prevent bottlenecks from occurring.