1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

SAS or SSD dedicated server

Discussion in 'Web Hosting' started by funkseo, Nov 19, 2012.

  1. funkseo

    funkseo Newbie

    Joined:
    Sep 27, 2012
    Messages:
    20
    Likes Received:
    1
    Hello guys,

    Anybody using dedicated server with SAS or SSD disk?
    My websites use high SQL Server I/O.
    So I need a good dedicated server with SAS or SSD.

    Thanks in advance
     
  2. closedCaption

    closedCaption Regular Member

    Joined:
    Oct 3, 2011
    Messages:
    289
    Likes Received:
    111
    It depends...if you get enterprise SSD then go for it, in other case choose SAS. They work wonders.

    Desktop SSDs can be flaky in Linux (and otherwise), and are not much reliable. Enterprise SSDs
    like those from Intel are made in proper way and will work without problem in server environment.
     
  3. funkseo

    funkseo Newbie

    Joined:
    Sep 27, 2012
    Messages:
    20
    Likes Received:
    1
    is there any hosting provider that you can suggest?
    thanks
     
  4. Zapdos

    Zapdos Power Member

    Joined:
    Oct 22, 2011
    Messages:
    597
    Likes Received:
    708
    Location:
    Eastern North Carolina
  5. RMX

    RMX Power Member

    Joined:
    Nov 16, 2009
    Messages:
    726
    Likes Received:
    389
    Occupation:
    Network Security Admin
    Location:
    London, UK
    Home Page:
    Have a look at my signature. Add a dedicated server to the cart and you'll be able to choose SSD disks.
     
  6. kuzmanin

    kuzmanin Regular Member

    Joined:
    Jul 17, 2010
    Messages:
    386
    Likes Received:
    45
    there is 3 way - server with more ram which can store all table indexes in ram
    consider that way also because ram is much more faster than ssd and sas
     
  7. funkseo

    funkseo Newbie

    Joined:
    Sep 27, 2012
    Messages:
    20
    Likes Received:
    1
    my database size is almost 100 GB, I have several tables that has 1 billion rows.
    So RAM option is not a good option.
    Even first table scan takes lots of time because of the disk read.
     
  8. papa_ji

    papa_ji Jr. VIP Jr. VIP Premium Member

    Joined:
    Jan 22, 2011
    Messages:
    925
    Likes Received:
    118
    Gender:
    Male
    Occupation:
    Founder of BlueAngelHost
    Location:
    Lahore, Pakistan
    Home Page:
    I can provide you dedicated server according your requirement SAS or SSD both are available let me know if you want it
     
  9. Zapdos

    Zapdos Power Member

    Joined:
    Oct 22, 2011
    Messages:
    597
    Likes Received:
    708
    Location:
    Eastern North Carolina
    If your tables do have billions of rows, I would highly suggest looking at optimizing it... Split it into smaller tables and then keep the "fresh" tables in cache and "old" tables not. Considering the size, I would look for a reputable host that is not on BHW. If its mission critical, I would go for WiredTree.com . They have excellent support and they can provision any type of server you would need.
     
  10. funkseo

    funkseo Newbie

    Joined:
    Sep 27, 2012
    Messages:
    20
    Likes Received:
    1
    well I cannot split tables and use cache because any data can be used anytime.
    The only solution I found a better server with high performance disk I/O and memory
     
  11. Zapdos

    Zapdos Power Member

    Joined:
    Oct 22, 2011
    Messages:
    597
    Likes Received:
    708
    Location:
    Eastern North Carolina
    Even though it can be accessed at anytime, you should be looking at optimizing the structure and analyzing how the data is accessed. For example, a news site may have tons and tons of analytical data and all of it can be accessed at anytime, it would make more sense to put the old stuff in a different table/database. But if you want to throw power at it, you could do one of several things (depending on location, #3 may not be available.) 1) Dedicated server. Obvious choice but can get expensive. You're also limited to what the provider allows. For high-end offers, expect to pay $800+/month 2) Cloud hosting. Not so obvious, but very expensive. Probably $1400+/month for your needs. Only good for scaling. 3) Colo hosting. This has much more upfront cost and requires you to be in a suitable location, but you get the option of parting out your own hardware and getting it exactly the way you need. Some places allow you to get a full rack for ~$800/month and a 100mbps port. The downside is you need to know what you're doing and you need to have money ready. For #1, WiredTree is my suggestion. For #2 and #3, webhostingtalk.com can help.
     
    Last edited: Nov 21, 2012
  12. obosor

    obosor Newbie

    Joined:
    Mar 15, 2012
    Messages:
    17
    Likes Received:
    1
    You may checkout webnx offer on webhostingtalk. They have great deal with SSD and SAS drive.
     
  13. Danny1111

    Danny1111 Elite Member

    Joined:
    Jul 5, 2011
    Messages:
    2,096
    Likes Received:
    2,480
    I have WiredTree Dedicated with Intel SSD

    having come from VPS's that always had one problem or another - my sites operate extremely efficiently and when you can afford it - it's the way to go.

    sorry I am not as technical as many in this thread - so can't answer anything as too that.

    yes go to webhostingtalk check out the latest coupons/deals and ask questions before you jump in.

    all the best.