Urgent Help And Advise...pls Help , I Am At My Wits Ends :(

Hi all experts ,

I am current webmaster of asianwinners.com , due to the popularity of my site , and my initial mistake of engaging my programmer to do ASP instead of PHP platform , my site is being "shutdown" by my server admin .

Apparantly another website on the same server complain that his site is slow , and the server admin traced it to my site forum running webwizguide and MS SQL server . Therefore he set limits for my site maximum utilizing of 1gig ram out of 2 , max 4 mins of running CPU load of >50% more than 8 mins etc etc ... if i exceed these limits i will have SERVICE UNAVAILABLE display to my user and the server will restart my site

initailly i can still get by with the limits , but apparantly the other website complain again and this time my admin set the death blow to me - max concurrent user = 20

Following the admin move my site can never be online for more than 1 mins without service unavailable.

Because alot of my other application is based on ASP and MS SQL i cannot afford to rewrite the whole site again ( also due to $$$ ) , i am thinking of hosting my other less resources draining application on my existing server , and i intend to get another account with my server on linux with MySQL ( e.g : forum.asianwinners.com ) , because all my userbase is intergrated into my MS SQL , if i want to do this forum.asianwinners.com , i do not want my user to re-register again , or future users when they register with my site using the scripts running on NT , i want the NT scripts to add in the username automatically into the linux MySQL database too .

Is the above possible ??

Also when my users changed their password , email etc etc , or when i login to my admin section to adminster my users i want the changes to be made to the linux site too , is all these mention possible ??

I do not need my old forum info except for the username and their password

Will all the kind soul out there advise on this ? and if possible would you like to take up this job ?

Thank you in advance
Regards
weeee

As advice here, it's a bit of a misconception that ASP/SQL is a server resources if it's done well. PHP is a good language, and I'll never argue a day in my life that a *nix based OS isn't faster than a Windows based one, but is your site making SO much traffic that your hosting plan really doesn't cut it?

If you are, and you're making money through certain advertising, it would really be best to find a host who offers dedicated hosting plans. Basically where the server is yours.

We can't say that the person who originally did the coding, did so sloppily and thus ate up a lot of resources in doing so, but I manage 13 servers and a website/intranet myself, and you do gotta know when you're getting too big for your host's breeches

If the forums are your biggest problem, then it is only they who require your attention. Take things in a modular approach. The site can be subdomained (site.domain.com) to a different server, and database conversions can be done while keeping data intact. (MSSQL -> MySQL)

First thing's first. BACKUP YOUR DATA. Ask your host to export the database to a file and keep that file safe. If push comes to shove and something messes up, you'll have the chance to do it over.