Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2002
    Posts
    7

    Unanswered: Risk in moving tempdb to raid 0

    Hi all,
    I wanted to shift tempdb from 0+1 to raid 0 array. I am not worrid about the transactions or rollback. if tempdb raid 0 array crashes, and I put new disk raid 0 array in place of crashed one will server start without any problems? Any other concerns except the transactions are losts.

    Cheers..Prakash

  2. #2
    Join Date
    Feb 2002
    Posts
    7
    Very surprising no reply.....

  3. #3
    Join Date
    Oct 2002
    Posts
    369
    RE: Very surprising no reply.....
    Q1 If tempdb raid 0 array crashes, and I put new disk raid 0 array in place of crashed one will server start without any problems?
    Well, some folks are on holidays; but here is a quick answer:

    A1 Maybe.

    It is best to extensively test any new configuration (especially less redundant ones) for failure recovery issues prior to implementation. Some obvious considerations in this case would pertain to what else may reside on the tempdb raid 0 array with tempdb e.g.(if Model, Master, etc., or some transaction logs of production DBs reside on the same array, there will be various different issues to address). One may also expect possible issues related to how production DBs / stored procedures, etc., will fail in an environment that suddenly loses tempdb with many production stored procedures in progress. For example, it is possible that some production stored procedures have been written in ways that may cause issues with inconsistent data in production DBs (in the event of the sudden loss of tempdb during a period of high production activity). Barring such kinds of issues, tempdb is rebuilt from the model DB each time Sql Server services start up normally (incidentally, ver. 6.5 supports tempdb in ram).

Posting Permissions

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