MS SQL
Web Hosting Solutions
MS SQL web hosting comprises of windows 2000 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 250 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 150 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 with
dual scsi drives in raid level 1 configuration so that there is no change
of any outage. The backend is MS SQL 2000 database with 16 databases totaling to a size of over 700 MB.
Daily backups of each of the database is done, zipped up using winzip
command line feature and sent via ftp to 2 other independent
servers.
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.
|
