Results 1 to 2 of 2

Thread: tempdb

  1. #1
    Join Date
    Nov 2006
    Posts
    5

    Unanswered: tempdb

    How to handle mutiple tempdb?
    Have any drawbacks or any conflict problem while handling the tempdb?

    Plz give me some idea or any good links.

  2. #2
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    Make sure that you are the latest patch level of Sybase to use MTB feature.

    You can isolate logins based on applications, or access privileges, or even resource consumption. Always reserve a tempdb for a sso/sa priveled account.

    This also slightly increases your recovery period whenever you recycle your dataserver. So, keep the MTB's to the lowest size that you can afford.

    The login bindings are stored in master..sysattributes, take a nightly backup of sysattributes, so this can be restored in the event of an failure.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •