Share via

I/O subsystem requirements for the tempdb database

  • Article

I've been catching up on my KB reading, I was prompted to go read this article by Robert Dorr, one of our Escalation Engineers. He was answering a question on one of our internal alias's (dbtalk) asking about using Solid State Disks for tempdb.

Comments

  • Anonymous
    June 29, 2006
    The comment has been removed
  • Anonymous
    July 07, 2006
    Jake,
    As a general rule Microsoft does not certifiy 3rd party storage products. RamSan may well work but it will not have been tested by the SQL Team and hence its impossible to its fine to use it.

    If under your testing it works just fine and the vendor is willing to provide you with support/integretity assurances then its your call.
  • Anonymous
    August 14, 2006
    We are getting a TMS ramdrive in sometime this week. I know that our app doesn't have any disk queing to speak of, so it will be interesting to see if we get a performance increase or if we just move the load to somewhere else in the server.

    Either way, I will check back in and share the results of the benchmarking.
  • Anonymous
    September 15, 2006
    Travis - have you implemented the ramdrive yet?  Any thoughts or observations to share on it?

    Thanks!