Hello,
I am working on a project for a potential customer.
The project will basically involve an ASP.Net 2.0 application and a
database (ideally MS SQL). The customer has already a hosting plan but it
does not currently include a MS SQL database. This option is offered as a
rather expensive add-on (600 US $ /year).
If we need cost saving, I could offer to set-up a MS SQL 2005 DB on my own
hosting plan in a different company (I may have 10 DB's) and use it as the
database for my customer's web site.
This would be a cheaper alternative but . do you think that there would be a
efficiency penalty ? I believe that as the IIS server and the MS SQL server
resides on separate machine with their own IP's it should be transparent
for my application and there should be no penalty in terms of user's
perceived efficacy
Thanks in advance for your feedback and advice,
Michel
NB: Last indication my hosting company is physically in the US and the
customer's hosting is in the UK 7 1775
You can do this if need be. I'm doing it for one of my clients because of
the exact same cost reason for them. As to how much of a performance hit
you'll take, it will depend upon where the database server resides in
relation to the web server. There is always a penalty in performance due to
latency. This could cause your app to appear slower since you could be
running even half a second slower for database activities. To improve this
performance try limiting the number of data accesses on a page. If your
would normally return a number of datareaders, try getting one datareader
with multiple resultsets that you can iterate through. This can improve
performance because you're only using the one connection instead of
numerous. You can run a trace (using tracert at the command prompt) to find
the path to the various hosts to get an idea of where the datacenters are
actually located and this could help you figure out a rough idea of the
latency.
--
Hope this helps,
Mark Fitzpatrick
Microsoft MVP - FrontPage
"Michel Couche" <Contact //@// michelcouhe.net wrote in message
news:eV******** *******@TK2MSFT NGP05.phx.gbl.. .
Hello,
I am working on a project for a potential customer.
The project will basically involve an ASP.Net 2.0 application and a
database (ideally MS SQL). The customer has already a hosting plan but it
does not currently include a MS SQL database. This option is offered as a
rather expensive add-on (600 US $ /year).
If we need cost saving, I could offer to set-up a MS SQL 2005 DB on my own
hosting plan in a different company (I may have 10 DB's) and use it as the
database for my customer's web site.
This would be a cheaper alternative but . do you think that there would be
a efficiency penalty ? I believe that as the IIS server and the MS SQL
server resides on separate machine with their own IP's it should be
transparent for my application and there should be no penalty in terms of
user's perceived efficacy
Thanks in advance for your feedback and advice,
Michel
NB: Last indication my hosting company is physically in the US and the
customer's hosting is in the UK
Yes, theoretically, you can host SQL Server and your web app far from apart.
The key issue is the connection speed. If the communication between the two
hosts is via regular internet connection, as you use at home "High-Speed",
say, a few Mbp, then your web app would be literally useless. So, you may
need make sure you have a very good connection between the two host, maybe a
dedicated line with speed of 10, 50, or 100Mbp, which may well cost ten or
hundred times higher than $600/year hosing fee.
"Michel Couche" <Contact //@// michelcouhe.net wrote in message
news:eV******** *******@TK2MSFT NGP05.phx.gbl.. .
Hello,
I am working on a project for a potential customer.
The project will basically involve an ASP.Net 2.0 application and a
database (ideally MS SQL). The customer has already a hosting plan but it
does not currently include a MS SQL database. This option is offered as a
rather expensive add-on (600 US $ /year).
If we need cost saving, I could offer to set-up a MS SQL 2005 DB on my own
hosting plan in a different company (I may have 10 DB's) and use it as the
database for my customer's web site.
This would be a cheaper alternative but . do you think that there would be
a efficiency penalty ? I believe that as the IIS server and the MS SQL
server resides on separate machine with their own IP's it should be
transparent for my application and there should be no penalty in terms of
user's perceived efficacy
Thanks in advance for your feedback and advice,
Michel
NB: Last indication my hosting company is physically in the US and the
customer's hosting is in the UK
Am I being pedantic here. $600 bucks per year is peanuts, its not even a
day or two's consultancy rates for a cheap consultant.
Having SQL in a different hosting company is certianly do-able - but
different SLA's and having to seek support from two teams instead of one,
anthe potnetial latency of SQL traffic pales that figure into a sum not even
worth worrying about.
Regards
John Timney (MVP) http://www.johntimney.com http://www.johntimney.com/blog
"Michel Couche" <Contact //@// michelcouhe.net wrote in message
news:eV******** *******@TK2MSFT NGP05.phx.gbl.. .
Hello,
I am working on a project for a potential customer.
The project will basically involve an ASP.Net 2.0 application and a
database (ideally MS SQL). The customer has already a hosting plan but it
does not currently include a MS SQL database. This option is offered as a
rather expensive add-on (600 US $ /year).
If we need cost saving, I could offer to set-up a MS SQL 2005 DB on my own
hosting plan in a different company (I may have 10 DB's) and use it as the
database for my customer's web site.
This would be a cheaper alternative but . do you think that there would be
a efficiency penalty ? I believe that as the IIS server and the MS SQL
server resides on separate machine with their own IP's it should be
transparent for my application and there should be no penalty in terms of
user's perceived efficacy
Thanks in advance for your feedback and advice,
Michel
NB: Last indication my hosting company is physically in the US and the
customer's hosting is in the UK
You could also host the site at DiscountASP.NET : http://www.discountasp.net/features.aspx
$90/yr. for the basic hosting plan + $10/month for adding SQL Server access.
See http://www.discountasp.net/features.aspx#addons for the addons pricelist.
Their SQL Server and their ASP.NET servers are hosted in the same network,
so you'd have good bandwidth between them.
They have reseller plans, so you could make a bit of money on those rates, too.
Disclaimer : I am not connected to DiscountASP.NET in any way.
Juan T. Llibre, asp.net MVP
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en español : http://asp.net.do/foros/
=============== =============== ========
"Michel Couche" <Contact //@// michelcouhe.net wrote in message news:eV******** *******@TK2MSFT NGP05.phx.gbl.. .
Hello,
I am working on a project for a potential customer.
The project will basically involve an ASP.Net 2.0 application and a database (ideally MS SQL). The customer has
already a hosting plan but it does not currently include a MS SQL database. This option is offered as a rather
expensive add-on (600 US $ /year).
If we need cost saving, I could offer to set-up a MS SQL 2005 DB on my own hosting plan in a different company (I may
have 10 DB's) and use it as the database for my customer's web site.
This would be a cheaper alternative but . do you think that there would be a efficiency penalty ? I believe that as
the IIS server and the MS SQL server resides on separate machine with their own IP's it should be transparent for my
application and there should be no penalty in terms of user's perceived efficacy
Thanks in advance for your feedback and advice,
Michel
NB: Last indication my hosting company is physically in the US and the customer's hosting is in the UK
600 a year isn't bad but a little high to add SQL db to your existing site.
That comes out to be 50 a month.
I should up my hosting rates with SQL. :)
"John Timney (MVP)" <x_****@timney. eclipse.co.ukwr ote in message
news:Rp******** *************** *******@eclipse .net.uk...
Am I being pedantic here. $600 bucks per year is peanuts, its not even a
day or two's consultancy rates for a cheap consultant.
Having SQL in a different hosting company is certianly do-able - but
different SLA's and having to seek support from two teams instead of one,
anthe potnetial latency of SQL traffic pales that figure into a sum not
even worth worrying about.
Regards
John Timney (MVP) http://www.johntimney.com http://www.johntimney.com/blog
"Michel Couche" <Contact //@// michelcouhe.net wrote in message
news:eV******** *******@TK2MSFT NGP05.phx.gbl.. .
>Hello,
I am working on a project for a potential customer.
The project will basically involve an ASP.Net 2.0 application and a database (ideally MS SQL). The customer has already a hosting plan but it does not currently include a MS SQL database. This option is offered as a rather expensive add-on (600 US $ /year).
If we need cost saving, I could offer to set-up a MS SQL 2005 DB on my own hosting plan in a different company (I may have 10 DB's) and use it as the database for my customer's web site.
This would be a cheaper alternative but . do you think that there would be a efficiency penalty ? I believe that as the IIS server and the MS SQL server resides on separate machine with their own IP's it should be transparent for my application and there should be no penalty in terms of user's perceived efficacy
Thanks in advance for your feedback and advice, Michel NB: Last indication my hosting company is physically in the US and the customer's hosting is in the UK
Hmm. I use gate.com for two separate ASP.NET 2.0 sites, I get a 25% discount
on the 2nd one, it averages $8.75 per month each and each one has its own SQL
2005 database. Am I missing something?
-- Peter
Recursion: see Recursion
site: http://www.eggheadcafe.com
unBlog: http://petesbloggerama.blogspot.com
BlogMetaFinder: http://www.blogmetafinder.com
"Michel Couche" wrote:
Hello,
I am working on a project for a potential customer.
The project will basically involve an ASP.Net 2.0 application and a
database (ideally MS SQL). The customer has already a hosting plan but it
does not currently include a MS SQL database. This option is offered as a
rather expensive add-on (600 US $ /year).
If we need cost saving, I could offer to set-up a MS SQL 2005 DB on my own
hosting plan in a different company (I may have 10 DB's) and use it as the
database for my customer's web site.
This would be a cheaper alternative but . do you think that there would be a
efficiency penalty ? I believe that as the IIS server and the MS SQL server
resides on separate machine with their own IP's it should be transparent
for my application and there should be no penalty in terms of user's
perceived efficacy
Thanks in advance for your feedback and advice,
Michel
NB: Last indication my hosting company is physically in the US and the
customer's hosting is in the UK
Hello! Good Site! Thanks you! bdiztgiqmxmpmi This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: cooldv |
last post by:
i am running a website on Windows 2000 server with ASP 3 webpages and
Access 2000 database. (with a hosting company)
traffic is slow at this time but expect to grow. lately i have been
reading about sql database and sql server, specially this article:
http://www.aspfaq.com/show.asp?id=2195
will someone help me understand:
1. with *SQL Server*, do i keep my current Access 2000 database and
ASP pages?
|
by: Uncle Ben |
last post by:
Some ASP hosting companies allow users to upload any ASP programs that they
want. But, as you know, ASP programs can do virtually everything, including
running components, doing disk operations, even reformatting a hard-disk!
How do ASP hosting companies prevent users from doing harmful operations
like that?
|
by: Troy |
last post by:
My ISP provides me with 2 servers: one for normal web hosting
(non-PHP) and a CGI server (with PHP). I create my website using
fusion 7 and upload this in its entirity to the web hosting server. If
I want to run CGI scripts, I can do so with an external link to a page
on the CGI server. The problem however is that I have to maintain two
sites and all associated links.
Ideally, I'd like everything to be in one place, but I'm not allowed...
|
by: John |
last post by:
Do you guys have any idea if web hosting companies usually give access to
SQL Server databases through Enterprise Manager?
I used to have have access to my DB through EE with my previous provider and
now the more I am looking into offers on the net the less I can see this
feature specified.
What can I do without EE to backup my database in a completely automated
way? Can I assume SQLDMO will always be available so that I can backup the...
|
by: Carl Gilbert |
last post by:
Hi
I feel as if I'm fighting a loosing battle with shared hosting at the
moment. I have an account with 1&1. For a whopping £16.99 a month I get
6GB of shared Microsoft hosting.
I also get the ability to have as many domains as I like, 5 web applications
and large SQL databases.
I'm currently experiencing some difficulties with a website.
"Request for the permission of type
| |
by: Vincent Delporte |
last post by:
Hello
I'm interested in hearing reflections by seasoned web app
developpers about the different ways to write PHP apps, and especially
how they compare in terms of performance, whether it's the PHP part or
connections to MySQL.
As far as I know, there are different ways to write a PHP application:
- CGI, ie. the usual way : some PHP code in web pages, and the PHP
interpreter is loaded each time a PHP page is called
|
by: Steve Holden |
last post by:
I know there are quite a few hosting companies now who represent
themselves as Python-friendly. Rather than trawl through the Wiki pages,
however, and email each one separately I am sending this request to the
comp.lang.python list (and putting it on my blog) in the hope of
attracting those companies who are more involved with the Python community.
There is a particular problem, highlighted recently by this comment from
Dennis Lee Beiber:
|
by: mp- |
last post by:
I want to be able to allow people to check their email from my PHP
online application.
Given only the users 1) email address, 2) username (if applicable) and
3) password - how can I auto detect a remote IMAP/POP3 server so that
I can connect and fetch mail for the user. (Ultimately, I don't want
users to have to know what the IMAP/POP3 server name / port is .... I
would like to auto-detect all of that).
At first I thought I could use...
|
by: adlloyd |
last post by:
Hi all,
I'm doing a little research into Windows-based managed/dedicated servers.
There are a few companies that provide what I want with a reputation to back it up: rackspace.co.uk (recommended by a few people) and zen.co.uk (from personal experience of other products).
Both of these solutions are at the upper end of the price bracket (between £250 and £400 per month based on dedicated or managed). I've also found lots and lots of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |