MS SQL Web Hosting Solutions

MS SQL web hosting comprises of Windows 2003 web hosting platform with MS SQL database server (database hosting server software) which is used for the storage and manipulation of large amount of data used by a large a large number of users.

The difference between ms access hosting database and ms sql hosting database

The primary difference as far as usage is concerned, between the ms access database and ms sql web hosting is : for ms access database is used when the database size is around 10-20 mb and the number of simultaneous users are less than 30. When the users are more then the there is a marked reduction in the website performance. Incase of ms sql there is no limit on the number of users. The second most important difference is that connecting and manipulation of ms access database using asp is a part of iis / windows operating system itself, ie you can use either odbc or ado. However ms sql is a separate software to be installed which has its own data processing capabilities.

We offer MS SQL web hosting via SQL 2000 server delivering a highly reliable, stable and secure storage medium. Our plans support MS SQL 2000 hosting and in case of high end applications requiring practically 100 percent uptime we have dedicated servers catering exclusively to SQL database hosting. Connectivity to sql databases can be achieved via a Data Source Name (DSN) based connection or a ADO connection. Remote Management of the database under the SQL 2000 hosting plan on Windows hosting platform can be done by means of SQL enterprise manager. Our automated maintenance plan under ms sql hosting backups all databases daily in an automated manner the backup drive. A link is provided to the client for downloading the same. 

Please click below to view all the features and prices.

Order MS SQL hosting on Windows hosting platform

If you need more information about our ms sql hosting service please Contact us.

A few Real time application case studies has been listed below

CASE STUDY 1) Educational University project

Project description
This project was related to the online declaration of the examination results for an particular university with around 20000 students. Students would come online and enter their examination number and retrieve information on their scores for 8 different courses / subjects.
 
Project technical details
The project was initially implemented using ms access database and simple asp programs connecting to the database and retrieving the information. The program was tested out by the developer at the university and everything was working fine on their local machine.
 
Problems faced
The day of the launch the students were complaining that response of the website was very slow and many a time web site would not open at all giving an error that server is busy.
 
Situation analysis
After discussing and coordinating with the programmer we could pinpoint the following
a) There were about 200 students accessing the website any given time creating a tremendous load on the website.
b) The number of queries fired on the database was far beyond the capabilities of the ms access database.
c) The basic connection string to the database was kept in a separate file.

Solution delivered
Within 15 minutes of the analysis of the problem the solution was delivered
a) An ms sql 2000 database was created with a secure username and password
b) The connection string was modified and the database connectivity was checked via the website.
c) The ms access database was imported into the ms sql server database.
d) After the migration was complete the application was tested and launched once again.

Real-time performance
The website performance and query delivery speed had increased by over 20 times.
At the peak usage there were over 1300 users querying the website simultaneously and even so the performance of the website was more than satisfactory
 

CASE STUDY 2)

Logistics management system for Aquarius Logistics and Interasia Lines

Project description
These companies are involved in large scale cargo transportation over the sea and has offices in over 300 locations globally. This project related to order booking and shipping logistics of the containers. Orders were booked in real-time and data is continuously entered by around 200 users at a time. The primary requirement of this application is extremely fast response of the website and 100 percent uptime.

Project Implementation
This project was implemented on high end enterprise level servers Dual Xeon processors, 1 GB ECC RAM 73 GB scsi drives so that there is no change of any outage. The backend is MS SQL 2000 database with 23 databases totaling to a size of over 1000 MB. Daily backups of each of the database is done, zipped up and transferred via ftp to 2 other independent servers for total safety of data. Backups are stored for upto 7 daily backups. Client is provided a web interface to download backups on a daily basis.

Real-time performance
The application performance was excellent delivering the requirements of the customer. Inspite of heavy usage of the application there were no problems. Regular support was delivered during application upgrades which were carried out smoothly.