how to know inadvance that a tempdb will run out of space

• koteswara kishore K.

  Ten Centuries

  Points: 1122

  More actions

  December 10, 2007 at 6:40 am

  #154009

  how to know inadvance that a file is going to be full?

  E.g. a log file will run out of space or tempdb will run out of space

  Thanks

  Kishore

• skrilla99

  SSCertifiable

  Points: 5795

  More actions

  December 10, 2007 at 7:00 am

  #758570

  You could set up monitoring to watch tempdb or data/log space used and have it send you alerts when the threshold you set is met.

  Sincerely,

  -Dan B