Abstract: Have you ever wondered just what takes so long when SQL Server executes a query? What if you have performance problems in your environment and your boss wants to just throw hardware at it? Sometimes it’s not that simple. Let’s walk through a SQL Server performance examination process together using a bottleneck identification approach. We will walk through the SQL Server bottleneck analysis process to determine the sources of waits within your SQL Servers, identifying the impact that it is causing, and setting a direction for remediation.
Takeaways: