This whitepaper is a guide to the 5 most common things that cause your SQL Server to run more slowly than it should. These are issues that, once addressed, will allow your SQL Server instances to run faster. Best of all, very little work is required to fix them.
Everybody would love to find the mythical “go faster” switch in SQL Server. Unfortunately, this switch just doesn’t exist. There are, however, many things you can do (with very little effort) that can speed up your SQL Server instances—things that are needlessly slowing down your SQL Server and causing it to work harder.
These tips are what I like to call Quick Performance Wins, because they require a minimum amount of work to implement and can deliver large improvements in performance. These tips are things that both database administrators and SQL developers alike can use to get quick wins:
- BALANCED POWER PLAN
- DEFAULT PARALLELISM SETTINGS
- DATA TYPE MISMATCHES
- FUNCTIONS ON COLUMNS
- MAX SERVER MEMORY AT DEFAULT SETTING