Menu

Performance Tune the Hardware

How to Do Index Performance Tuning

If you’re not allowed to optimize the SQL queries, but you still need to speed them up, then you may need to design nonclustered indexes and covering indexes. This can increase the performance of a SQL query without

want to make the database structures more efficient so SQL Server works less, here’s our resources:

  • sp_BlitzIndex® – run this in your database for a free sanity check. It shows missing indexes, unused indexes, duplicates, heaps, and more, and explains why they’re killing your performance.
  • Indexing resources – our favorite blog posts and videos about tuning indexes.
  • SQL Server Book Recommendations – okay, the books aren’t free, but our recommendations are. We pick the best beginner, advanced, and performance tuning books.
  • Table partitioning – this feature seems like a great way to split up big tables, but it comes with some big gotchas.
  • How to tune indexes – and make SQL Server queries go faster.

Performance Tune SQL Server’s Settings

Surprisingly, a lot of SQL Server’s default settings can lead to bad performance. Let’s talk through what you need to do:

  1. Run sp_Blitz® on the server. It’s a free health check that catches many common performance bottlenecks.
  2. Check our SQL Server Setup Checklist – some simple configuration tweaks can get you 20-30% performance increases right from the start without spending any extra money.
  3. Review the Poor Performance Checklist – Jeremiah’s 5 things that fix bad SQL Server performance.
  4. Sysadmin’s Guide to SQL Server Memory – why isn’t sqlserver.exe using much memory? How can you tell if it needs more?

0 Comment

Leave a Reply