Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Meme Monday – “I got 99 problems but a disk ain’t one”

1481504305_0045aac3f2_mEarlier 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…

  1. Unchecked parallelism
  2. Unmanaged security
  3. Code that works, not performs
  4. Disbelief in clustered indexes
  5. Lack of appropriate indexes
  6. Undocumented recovery strategy
  7. Untested backups
  8. Misuse of scalar user-defined functions
  9. 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:

  1. #Meme Monday
  2. Webcast Next Week – Performance Impacts Related to Different Function Types
  3. Webcast Today – Performance Impacts Related to Different Function Types

Comments

No comments.

Leave a Comment

Please register or log in to leave a comment.