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