I think someone could make it their whole job to work with SQL Server. Grin. OK, I know many people actually do :) But for my company, I do it when I'm not doing other stuff. I guess that sort of tells you how much room for optimization we probably have.
I've been pushing hard to get us focused on one simple fact: Doubling the user load and increasing the data being worked with by a staggering factor (from 200 new records per day to 10,000) within the next six months means that the system will probably DIE :) We need to prepare, plan, purchase, optimize, etc. Of those "choices" believe it or not my company would prefer to "purchase." If just buying a "big bad mother-of-all-servers" machine would do the trick, they would probably go for it. But, you know, I want to actually *learn* this stuff :)
So, I've managed to get approved a huge thing: We're signing up for some in-house training with Solid Quality Learning. In case you don't know them, this is a consultancy consisting of some of the "big names" in the SQL Server training world. These guys "write the books" and "do the talks" etc. Go to their website at http://www.solidqualitylearning.com/ to see more about them. Anyway, we're working on getting someone out to our site!
Instead of going and taking a class, I'll have someone right here looking at my own database, in my own environment. I'm sure it will be as embarrassing as it is productive :) I can't wait!
In the meantime, I've been working my way through the book I mentioned in an earlier post. () What a great book. I'm working my way through learning the Profiler, and then to be able to actually optimize a query once I know which one to optimize, etc. Basically, so far I run the Profiler for an hour or so, saving the trace to a database table. Then I analyze the output by looking at the top 5 hitting queries in these categories: CPU, Reads, Duration, and Frequency. Then I look at any queries that are in the top 5 of all four categories. Then I mess with those queries on my development machine until I think I have something good. Like McDonald's says "I'm lovin it!"
| posted on Tuesday, January 27, 2004 8:06 AM