My First *real* SQL optimization (and some good resources) - ISerializable - Roy Osherove's Blog

My First *real* SQL optimization (and some good resources)

Yeah, I know how to design a database and normalize tables, but this is some optimization stuff I never had to do. It was fun!

We recently encountered the task of optimizing a stored procedure that was taking very long to perform its business. It wasn’t that complicated but it was operating on a large table (350,000 records). The table has indexes on the columns in the select clauses but the procedure still took about 19 seconds to do its work.  (Thanks for the help, Santo!)


Some interesting lessons (and resources) came up from this experience(article)

And here are some very good resources on optimization in SQL server:

  1.   SQL Server execution plan analysis
  2. Tips for Using SQL Server Query Analyzer
  3. The Best SQL server performance tuning tips from SQLTeam (some amazing stuff here!)
  4. Identifying performance issues using SQL Server Profiler
  5. SQL Server Performance - Common Symptoms and Tools (Part I)
  6. Inside SQL Server: Parse, Compile, and Optimize (intro to the query processor)
Published Friday, December 26, 2003 1:23 AM by RoyOsherove
Filed under: ,

Comments

Thursday, December 25, 2003 12:59 PM by TrackBack

# H4ppy H0L1d4ys!

I'm glad to see I'm not the only one putting my day(s) off to good use.

My holiday so far has been spent playing with some toys/tools that I haven't previously had time to really sit down and give the effort needed. I have been able to finally check out the Frans' offerings: LLBLGen (the free, open source version and a demo of the Pro version). The Pro version is only a demo, so I couldn't really test it except for on the Northwind database, but it is