{"id":344,"date":"2010-08-22T17:33:07","date_gmt":"2010-08-22T22:33:07","guid":{"rendered":"http:\/\/lakamsani.wordpress.com\/?p=344"},"modified":"2018-10-16T19:14:00","modified_gmt":"2018-10-16T19:14:00","slug":"sql-server-cost-in-cloud-with-simple-calculation-internal-sql-server-vs-cloud-based-sql-server","status":"publish","type":"post","link":"https:\/\/lakamsani.me\/blog\/2010\/08\/22\/sql-server-cost-in-cloud-with-simple-calculation-internal-sql-server-vs-cloud-based-sql-server\/","title":{"rendered":"SQL Server Cost in cloud with simple calculation ( Internal SQL Server Vs Cloud based SQL Server)"},"content":{"rendered":"<h3>Internal SQL Server Cost Vs SQL Server Cloud (SQL Azure Cost<\/h3>\n<p>A quick back-of-the-envelope calculation using a 2-cpu server with 8gb ram, SATA drives, Windows 2008 and 2 CPUs of SQL Server Standard at list price puts me around $15,000.\u00a0 (Yes, enterprises get dramatically discounted stuff, but enterprises don\u2019t need SQL Azure at rack price either.)<\/p>\n<p>Let\u2019s say I use this server for five years \u2013 that\u2019s $416 per month.\u00a0 That does not include:<\/p>\n<ul>\n<li>Power<\/li>\n<li>Connectivity costs (but neither does the Azure $9-$99 price, either.\u00a0 Remember that bandwidth costs extra for Azure.)<\/li>\n<li>Management (but neither does Azure, since you still have to roll some of your own utilities.\u00a0 Remember that Azure doesn\u2019t support things like Profiler.)<\/li>\n<li>Backups (but neither does Azure, and no, Microsoft telling me \u201cit\u2019s backed up\u201d doesn\u2019t count.)<\/li>\n<li>Clustering or geographic high availability.\u00a0 I probably wouldn\u2019t achieve three nines of uptime with this configuration, but if I wanted to go for that, I\u2019d add a second server in another location with SQL Server\u2019s database mirroring.<\/li>\n<\/ul>\n<p>The tough part of all this is the future:<\/p>\n<ul>\n<li><strong>Will SQL Azure\u2019s costs go down?<\/strong> Hardware prices always go down, so it\u2019s interesting to try to compare long-term pricing between the two.<\/li>\n<li><strong>Will SQL Azure add more features?<\/strong> I can back up a locally hosted database easily, but backing up Azure is going to be a little tricky for now.\u00a0 If I want to add filestream data or TDE, that\u2019s a piece of cake with local databases, but not with Azure.<\/li>\n<li><strong>Will SQL Azure stick?<\/strong> If I had a dollar for every piece of technology built then Microsoft abandoned, I\u2019d be Steve Jobs.\u00a0 The nice thing about developing for SQL Azure is that it\u2019s a subset of SQL Server anyway.\u00a0 Worst case scenario, Microsoft abandons SQL Azure \u2013 you just light up your own SQL Server and deploy your app there anyway.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Internal SQL Server Cost Vs SQL Server Cloud (SQL Azure Cost A quick back-of-the-envelope calculation using a 2-cpu server with&#8230;<\/p>\n","protected":false},"author":4,"featured_media":622,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7,10],"tags":[],"class_list":["post-344","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-business-related","category-future","wpcat-7-id","wpcat-10-id"],"_links":{"self":[{"href":"https:\/\/lakamsani.me\/blog\/wp-json\/wp\/v2\/posts\/344","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/lakamsani.me\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/lakamsani.me\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/lakamsani.me\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/lakamsani.me\/blog\/wp-json\/wp\/v2\/comments?post=344"}],"version-history":[{"count":1,"href":"https:\/\/lakamsani.me\/blog\/wp-json\/wp\/v2\/posts\/344\/revisions"}],"predecessor-version":[{"id":584,"href":"https:\/\/lakamsani.me\/blog\/wp-json\/wp\/v2\/posts\/344\/revisions\/584"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/lakamsani.me\/blog\/wp-json\/wp\/v2\/media\/622"}],"wp:attachment":[{"href":"https:\/\/lakamsani.me\/blog\/wp-json\/wp\/v2\/media?parent=344"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/lakamsani.me\/blog\/wp-json\/wp\/v2\/categories?post=344"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/lakamsani.me\/blog\/wp-json\/wp\/v2\/tags?post=344"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}