Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
R
Constraint Violating Yak Guru
328 Posts |
 Posted - 2011-08-26 : 05:24:01
|
Our database is hosted on a physical server. This week we had our first query timeout error. Luckily, it was a simple fix that just required a new index. This new index increased performance by a factor of about 100. Shame on my for not doing this previously  My database host has recently started pestering me to host our offerings in the Cloud instead of our physical server. At first I thought this was a good idea, but wondered if I would have ever found out about my poor query execution plan? I mean, if I can pull in extra resources when needed, presumably (at a price) my timeout error would have been handled rather more inefficiently, much to my ignorance?!?Does anyone else host SQL databases in the cloud, and if so, what have your experiences been like? |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2011-08-26 : 09:03:19
|
| I'm skeptical about the cloud for this exact reason...you can never tell how it will perform. Usually it performs "very well" but how can you guarantee it? What about SLA'a?- LumbagoMy blog-> http://thefirstsql.com/2011/07/08/how-to-find-gaps-in-identity-columns-at-the-speed-of-light/ |
 |
|
|
R
Constraint Violating Yak Guru
328 Posts |
Posted - 2011-08-26 : 09:27:17
|
| We use Rackspace for hosting the physical box, but their Cloud sales pitch contains this gem: "In many instances, performance is higher in the cloud because there is more available capacity and scalability. In other cases (most notably running a database server), performance may be less than a traditional server."So how exactly can you benchmark a service that can pull in additional resources as and when it needs to?!? Also, where are the figures to support their nugget of information? There is hardly any information to backup any of these claims. I don't think anyone dare become the person to 'test it out'...! |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-08-26 : 09:31:52
|
| Even the biggest players have cloud problems: http://techcrunch.com/2011/08/08/amazon-ec2-outage/It's hard to say if that's the right solution for you. A friend of mine is at a new job, his VP used to work at Amazon. Naturally he wants to move as much as possible to their cloud, and my friend is also skeptical. He can get a lot of information from Amazon about status, but also can't get the kind of info like you describe that would help him tune queries, etc. And of course the unplanned outages don't help. |
|
|
|
R
Constraint Violating Yak Guru
328 Posts |
Posted - 2011-08-26 : 11:20:48
|
| Hi RobThanks for posting that - that does make for some interesting reading. I don't think my customers would appreciate hearing, "It's not our fault - blame Amazon" when they couldn't get online to access their data...!Stuff like that puts me right off! |
|
|
|
|
|
|
|
|
Discussing poor performance & hosting in the Cloud