Capacity planning

• stephanie_balir

  SSC Journeyman

  Points: 89

  More actions

  January 26, 2009 at 5:54 am

  #199282

  Hi Im new to SQL and need help,

  Are there any algorithms i can use to help predict trending levels, so that when space/ memory/ queues reach a certain threshold say 80% an automatic alert can be sent.

  thanks in advance

• Roy Ernest

  SSC-Dedicated

  Points: 38780

  More actions

  January 26, 2009 at 8:42 am

  #932634

  There are lots of tools out there that can be used to Monitor these details. You can configure them to send emails as well.

  You can also write your monitors as well. Take a look at SQlH2. It is good for comparison and monitoring.

  -Roy