hosting question for database and dns but in doman

OK, I will do my best to answer both of your questions. First, the message states the problem. You were running heavy queries that put a large load on the SQL server so you were suspended. You are going to need to figure out which queries were the problems and then fix them. You should be monitoring your queries anyway to be sure they are efficient and don't take up too many resources. If you have a copy of the database locally, run all of your queries and figure out which ones are the slowest and figure out why. Avoid cursors, loops, UDFs in WHERE clauses, etc. Also, make sure you use indexing properly and take advantage of that indexing. Basically, make sure your database is well developed and healthy. You might also be able to contact your hosting company and get some help in identifying which queries specifically were the problem. They won't help you fix them, but they might be able to tell you which ones were the problem. In the end though, it sounds like you should review your entire database setup and all your queries, UDFs, stored procedures, and views. Also, review any queries that you are developing in code and calling dynamically. These can be very expensive because the server has to develop a plan for each one. Try not to use dynamic queries as much as possible.

As far as hosting your site on two different hosts, yes this is possible and yes you can do it using DNS. However, there is a problem with this. If your visitors are creating data, it won't work to do it this way. If they come back to your site but get directed to the other host, their data won't be there unless you set up replication (which most hosts won't allow to another host). I would recommend against this approach. Instead, I think you should very carefully define your requirements. Why do you want two hosts (write it down - I don't need to know, this is for you). What benefits are you looking to get? Is it uptime? Reliability? Failover? Once you have your requirements, you know what to look for in a hosting provider. A lot of providers offer these features if you go to a different plan. One place you could look would be Windows Azure. You can scale the number of machines you have running your site and they will handle the balancing. They will also do database replication internally. You could also look at the Amazon cloud as well. Finally, larger hosting providers such as Datapipe or Rackspace provide higher-end hosting solutions that might fit your requirements.