• Skip to main content
  • Skip to primary sidebar

DallasDBAs.com

Explaining SQL Server in plain english

  • Services
    • SQL Server Health Check
  • Pocket DBA®
  • Blog
    • Speaking
  • Testimonials
  • Contact
  • About

Stories from the HealthCheck – part 4

January 10, 2020 by Kevin3NF Leave a Comment

This week I have been highlighting the top items that I see on almost every SQL Server I run across that need to be changed in almost every instance.

If you know me at all, or have read anything from me, you probably already know what’s coming – 

Number 4, for Freaky Friday:

Indexes

  • No indexes – bad – everything is slow
  • Lots of indexes – bad – everything is slow, despite having some great indexes
  • Duplicate indexes – bad – everything is slow and there is no benefit
  • Unused Indexes – bad – the junk drawer of SQL Server needs some attention
  • Goldilocks indexes (the just right ones) – Great!

You guys are great, and I applaud you for making the effort…but indexes are hard. The idea is easy, but the implementation is hard to get right and it changes over time with your workload.

New features and changing traffic patterns can mess up a perfectly good index strategy.  Reviewing your indexes is like getting your oil changed in the car – do it regularly or risk everything grinding to a halt.

EVERY HealthCheck I have done since starting Dallas DBAs has pointed out that an indexing project was desperately needed.  Some better than others, but they all needed help.

Please – Seek help! (DBAs…see what I did there?)

Thanks for reading!

Kevin3NF

Follow @Dallas_DBAs

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on LinkedIn (Opens in new window)
  • Click to share on Facebook (Opens in new window)
  • Click to email a link to a friend (Opens in new window)
  • Click to print (Opens in new window)

Related

Filed Under: HealthCheck, SQL

About Kevin3NF

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Search

Sign up for blogs, DBA availability and more!


Categories

  • Accidental DBA
  • Apprentice
  • Azure
  • backup
  • backup
  • Beginner
  • Career
  • Configuration
  • Cycling
  • Dallas DBAs
  • Deployment
  • Emergency
  • Encryption
  • EntryLevel
  • Fries
  • Goals
  • HADR
  • HealthCheck
  • Index
  • Install
  • IRL
  • Management
  • Migration
  • MySQL
  • Oracle
  • PASS
  • Performance
  • Personal
  • Pluralsight
  • Podcast
  • PowerShell
  • red gate
  • Restore
  • Security
  • Speaking
  • SQL
  • sql 2005 log shipping suspect
  • sql injection
  • SQLSaturday
  • SSIS
  • SSMS
  • Summit
  • TIL
  • Tools
  • Training
  • Troubleshooting
  • TSQL
  • TSQL2sday
  • Uncategorized
  • Upgrade
  • vendor code modify
  • video
  • vNext

Copyright © 2023 · Genesis Sample on Genesis Framework · WordPress · Log in

Privacy Policy
 

Loading Comments...