Reducing the Size of tempdb

The tempdb (temporary) database provides storage for temporary tables and other temporary working storage needs. If you have a corrupted disk that contains portions of tempdb, you should first reduce tempdb to its default size and then extend it onto any new device.

• Reset tempdb to Default Size
  SAP ASE must be in single-user mode to prevent another user from altering the database while you manually update sysusages.