As a developer, often DBAs take responsibility for resolving performance issues at the database level so we don't get that much experience diagnosing, tuning, refactoring queries etc.

I'm looking for a database with a bunch of tables, data, queries, triggers, SPs and so on, in which there are deliberate performance problems, and hopefully a series of exercises in which you attempt to identify and resolve the problems. Ideally this will be on MS SQL server.

Anyone know of this kind of thing?

  • 2
    Don't think that this is a proper answer to your question, but you can read some good primers on tuning here: sqlserverpedia.com/wiki/SQL_Server_Training (nice videos on SQLServerPedia made by a great author Brent Ozar) and a nice checklist from well known author Brad McGehee here: devarticles.com/c/a/SQL-Server/… . Hope they provide you a starting point :). – Marian Jan 17 '11 at 17:05
  • A nice book to read about SQL performance tuning is The Art of SQL by Stephane Faroult (with Peter Robson). If a database system is mentioned in the book, it's mostly Oracle. This shouldn't be a problem, but unfortunately there are no exercises... – j.p. Jan 18 '11 at 15:23
  • 1
    Hey Marian, that's my idea of late night p0rn - ugly men chatting about SQL Server. Thanks, great links. – flesh Jan 19 '11 at 23:08
  • 1
    There is another great guy doing late night p0rn for us: midnightdba.itbookworm.com .. his name says it all. He has quality stuff there too! – Marian Jan 24 '11 at 21:26
  • @Marian - Now toadworld.com/platforms/sql-server/w/wiki/… – Martin Smith Jul 30 '13 at 20:34

Paul Randal provides some sample DBs that are actually corrupt: http://www.sqlskills.com/BLOGS/PAUL/post/Conference-corruption-demo-scripts-and-example-corrupt-databases.aspx

Good exercise to go through working with DBCC commands and such on SQL Server.

| improve this answer | |

If you're a developer and you have a DBA team I strongly suggest you look into booking some time with them to go over tuning. As a DBA (who does dev and architecture too!) supporting thousands of users I can honestly say that I will always make time to meet with developers that are serious about learning how to improve their SQL skills. An email here or there is ok but it takes a lot of time to properly explain things in an email and it takes time away from my more important duties. Scheduling a meeting to discuss tips or techniques or even go over issues live works out great! I can share tips on tools, scripts, how to spot problems, good designs vs. bad designs, etc.

Specific to your question - I'm not aware of any training database like that but it does sounds like a good opportunity for the community!

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.