Top tips on reducing CPU load

- Indexing really helps

- Check your SQL queries are efficient (do you need all the data, are the joins optimal)

- Moving queries in stored procs used to help

- Are you doing too many queries and then combining them in a web page script when maybe one query would do

- If it is many reads to one write then maybe consider doing a bit more calculation before saving the data if that is possible. (eg rather than writing a date and then always querying the day of the year, save the day of the year)

Hope this helps...