Earlier today, Thomas LaRock (Blog | @SQLRockstar) tagged me for his Meme Monday post. The question for today is: how many things can go wrong with a database server that are NOT related to a disk drive? Here are my 9 items…
- Unchecked parallelism
- Unmanaged security
- Code that works, not performs
- Disbelief in clustered indexes
- Lack of appropriate indexes
- Undocumented recovery strategy
- Untested backups
- Misuse of scalar user-defined functions
- Overloaded, un-tuned stored procedures
My list of items are a few of the more frequent items that I’ve found while performing SQL Server assessments that I’ve done for customers. What are your problems?
Related posts:
- #Meme Monday
- Webcast Next Week – Performance Impacts Related to Different Function Types
- Webcast Today – Performance Impacts Related to Different Function Types
