SQL database newbie - db optimisation help please

Discussion in 'MySQL' started by spudnik, Nov 4, 2007.

  1. #1
    Hi guys,

    I have inherited an 80gb financial database which has huge data processing run on it nightly and we believe is excessively large and not performing as well as it could.

    I am in financial systems but new to databases.

    My questions are;

    1. Which are the best database performance monitoring utilities?
    2. Any diagnostic tools to spot problems/issues in a db?
    3. Can anyone suggest any good books on db administration/optimisation?

    Thanks,

    Mark.
     
    spudnik, Nov 4, 2007 IP
  2. flippers.be

    flippers.be Peon

    Messages:
    432
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    #2
    what database is it ? oracle ? sql server ? access ? mysql ?
    what version ?
     
    flippers.be, Nov 7, 2007 IP