| Author |
Topic |
|
textless
Starting Member
2 Posts |
 Posted - 2010-04-27 : 14:53:15
|
| I have an application that makes use of a single sql server 2008 database hosted by a 3rd party provider. My service level is "shared" meaning that I'm sharing a single instance of sql server with other customers. In fact, I can see other customers' database out there but, of course, cannot access them.Now, I'm trying to migrate to the provider's "semi dedicated" hosting plan meaning that a finite number of customers share a cluster of servers (better performance promised). I've started trying to migrate my users ids and database to the new server and domain only to run into name conflicts! When I attempted to recreate my database "XYZ" on the new server, I got an error message saying a database with that name already existed. Same for my user ids. So, as far as I can tell, my new "semi dedicated" service points to the exact same sql server instance as my other (still operational) shared plan. I don't see how they can tell me I'm going to get better performance if that's the case!Is something "squirrely" going on here?Thank you (and sorry, I know very little about SQL Server admin and configuration). |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2010-04-27 : 15:24:53
|
| You could be getting ripped off, but it is just as likely that they are simply incompetent and have no idea what they are doing.Probably amounts to the same thing in the end.CODO ERGO SUM |
 |
|
|
textless
Starting Member
2 Posts |
Posted - 2010-04-27 : 15:49:29
|
| Well, now they're telling me that accounts on the semi-dedicated plan do, in fact, share the same db instance as customers on the lower-end shared plan (my old plan), but that semi-dedicated accounts get a "higher priority for resources". This contradicts their online description of the semi-dedicated plan which says you share a cluster with at most 10 other semi-dedicated customers. If I hadn't tried to create a DB on the "new server" with the same name I'd used before (on the "old server"), I wouldn't have had a clue that "new server" == "old server". |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2010-04-27 : 17:09:03
|
| Maybe they used this to describe their semi dedicated hosting plan in order to "target granular niches" and "productize granular infrastructures":http://www.dack.com/web/bullshit.htmlCODO ERGO SUM |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
DBA in the making
Aged Yak Warrior
638 Posts |
Posted - 2010-04-27 : 17:28:32
|
quote:
Originally posted by Michael Valentine Jones
Maybe they used this to describe their semi dedicated hosting plan in order to "target granular niches" and "productize granular infrastructures":http://www.dack.com/web/bullshit.html
I can't wait to generate some sexy relationships in order to leverage my one-to-one experiences. :)------------------------------------------------------------------------------------Any and all code contained within this post comes with a 100% money back guarantee. |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2010-04-27 : 17:56:49
|
| On the following topic, Merkin implemented the Web Economy Bullshit Generator as a stored procedure with public availability as a web service and a .Net console app to call the web service.http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=47055"Press announcement for immediate release (March 16, 2005):“EMerkin, a leading provider of business portal web services, has announced the release of their Bullshit Generator Eservice. Bullshit Generator Eservice is built on best-of-breed technologies and it’s proprietary Bullshit Generation Engine utilizes a scalable N-tier architecture to cost effectively deliver Bullshit to the Enterprise, while standards compliance insures easy integration with existing applications.EMerkin provides extensions to the Bullshit Generation Eservice to serve important vertical markets with industry specific Bullshit: Auto Sales, Telemarketing, Time Sharing Sales, Government, and IT Consulting Services. EMerkin provides consulting services for custom extensions to the Bullshit Generation Eservice to serve the needs of customers with special needs.Early adopters have leveraged Bullshit Generator Eservice to achieve tremendous productivity gains in the mission-critical generation of Bullshit for Sales, Marketing, Customer Support, and Senior Management.The Transaction Processing Performance Council has placed Bullshit Generator Eservice at the number one spot on its prestigious TPC-WBS benchmark, far ahead of the former record holder, Oracle CEO, Larry Ellison. http://www.tpc.org”CODO ERGO SUM |
|
|
|
|
Am I getting ripped off by sql srvr hosting srvc?