Every system administrator knows the four common resource bottlenecks: memory, CPU, disk, and network. But those resource bottlenecks are not the reason for your sudden performance issues. Over the years I've compiled a list of issues I find to be common with SQL Server. These issues are avoidable but not easy to fix once they have become a problem.

In this interactive session, we will review the top five common problems with SQL Server and discuss how to fix them.

You will learn:

• Identify bottlenecks
• Performance tuning
• Query optimization