SQL server?? solid state HDD??

Discussion in 'PC Hardware, Software and Displays' started by London Geezer, Jan 31, 2003.

  1. London Geezer

    Legend Subscriber

    Joined:
    Apr 13, 2002
    Messages:
    23,536
    Likes Received:
    9,317
    right, here some doubts i just need to get rid of...

    we just got a new SQL server at work and it is just 10000000x faster than the old one we used to have... now, why is that exactly?!


    also......... i heard here and there about solid state HDD's..... but whats the fuss all about?

    thanx... :lol:
     
  2. RussSchultz

    RussSchultz Professional Malcontent
    Veteran

    Joined:
    Feb 6, 2002
    Messages:
    2,855
    Likes Received:
    55
    Location:
    HTTP 404
    People are making solid state HDDs from flash memory.

    These have limited write cycles (~100k or maybe ~1M) and are generally slower to write to than rotating media. They're also much more expensive, bit per bit.

    Supposedly there's a push to enable MEMs (nanotechnology) as a very dense "solid state" storage media that won't suffer from the problems that flash has. Of course, its probably years off...
     
  3. London Geezer

    Legend Subscriber

    Joined:
    Apr 13, 2002
    Messages:
    23,536
    Likes Received:
    9,317
    so what would be the advantage in developing a technology which is not better than the existing technology and is also more expensive? :?
     
  4. pcchen

    pcchen Moderator
    Moderator Veteran Subscriber

    Joined:
    Feb 6, 2002
    Messages:
    2,906
    Likes Received:
    410
    Location:
    Taiwan
    SSDs have very low latency. For many applications, such as real-time applications, latency is much important than raw bandwidth.
     
  5. RussSchultz

    RussSchultz Professional Malcontent
    Veteran

    Joined:
    Feb 6, 2002
    Messages:
    2,855
    Likes Received:
    55
    Location:
    HTTP 404
    Different applications. Flash based HDDs are great for portable devices that don't need to write much in real time. (like mp3 players!) Or for embedded devices that don't need too many write cycles. (Like air plane black boxes).

    They don't do well as a scratch disk for windows.
     
  6. London Geezer

    Legend Subscriber

    Joined:
    Apr 13, 2002
    Messages:
    23,536
    Likes Received:
    9,317
    THANKS...

    so what about SQL servers? :oops:
     
  7. Joe DeFuria

    Legend

    Joined:
    Feb 6, 2002
    Messages:
    5,994
    Likes Received:
    71
    I would assume that Flash based (and solid state in general), storage is much more reliable than mechanical storage. Above all, that is probably a key advantage in database servers.

    Mechanical storage is relatively cheap....but then you have to factor in RAID and and other redundancy techniques with the mecahnical devices which as basically just assumed to break-down at some point.

    So in short, I would say that Solid Sate storage is more about reliability, than performance....
     
  8. KnightBreed

    Newcomer

    Joined:
    Feb 7, 2002
    Messages:
    203
    Likes Received:
    0
    What is your question, exactly? Why are the new "SQL servers" faster?

    Just to clear up some confusion: SQL Server is a database application from Microsoft. You purchase a regular computer and then install the SQL Server application onto it. Just like any application you can speed up its processes by upgrading the hardware in the computer.

    The servers are faster because your IT department probably added more RAM or faster CPUs or something along those lines.
     
Loading...

Share This Page

  • About Us

    Beyond3D has been around for over a decade and prides itself on being the best place on the web for in-depth, technically-driven discussion and analysis of 3D graphics hardware. If you love pixels and transistors, you've come to the right place!

    Beyond3D is proudly published by GPU Tools Ltd.
Loading...