SQL Server in the Cloud article at Dr. Dobb’s Journal

When You Care Enough to Spend The Very Least

When You Care Enough to Spend The Very Least

Dr. Dobb’s Journal just published an article of mine about SQL Server in the cloud.  In it, I cover:

  • The full espresso-strength option for SQL in the cloud
  • The “instant coffee” version that might just meet your needs
  • Two real world use cases – one that needed espresso, and one that ended up with Nescafe

You can read the article, and then let me know what you think here.  (They don’t have discussions on articles.)

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

Website - Twitter - Facebook - More Posts

4 Responses to SQL Server in the Cloud article at Dr. Dobb’s Journal
  1. Rob Mackenzie
    December 17, 2009 | 8:22 AM

    Hi Brent,

    I was wondering if you had any insight to the current state of database performance with the new Server/Sql 2008 options at Amazon EC2. You had an article a while back which criticized the performance of Sql 2005 on the 2003 servers they had, saying that the throughput was the equivalent of running your db off a thumb-drive. It appears like they’re trying to address some of the previous limitations of Windows on EC2 (server version, boot drive, etc.) and I was wondering if this translated to performance benefits.

    Cheers,
    Rob

    • Brent Ozar
      December 17, 2009 | 8:23 AM

      Rob – good question. I’ve been curious about that myself, but since it costs money to ramp up a new server and do performance testing, I haven’t bothered. I’ve been waiting until I see word from them that there’s a better-performing storage subsystem available, or that they’ve improved it somehow. Have you seen anything to that effect?

      • Rob Mackenzie
        December 17, 2009 | 9:13 AM

        Not to be overly analytical about the new server options, but they do in fact “feel” zippier. It’s definitely cool to see how fast they boot and even cooler that they can sit idle and uncharged in the stopped state. Neither of these perks address day-to-day operations however.

        Maybe in the New Year I could provide the server(s) and you could provide the skill(s) or at least direction to dig into it a little more.

        Thanks for < 1 min. reply,
        Rob

        • Brent Ozar
          December 17, 2009 | 9:15 AM

          You bet! If you give me the login I’d be glad to dig into the storage performance and let you know what I find. Happy holidays, and talk to you next year! :-D

Leave a Reply

Wanting to leave an <em>phasis on your comment?

Notify me of followup comments via e-mail. You can also subscribe without commenting.