| Author |
 Topic  |
|
|
Astralis
Senior Member
USA
1218 Posts |
 Posted - 03 March 2005 : 03:27:31
|
| Everyone talks about how cheap storage is but I'm not experiencing cheap storage when using a SQL DB. Can anyone explain why the data storage is so expensive? |
|
|
MarcelG
Retired Support Moderator
Netherlands
2625 Posts |
Posted - 03 March 2005 : 04:20:56
|
I guess it's just the licensing strategy that MS uses.
SQL is very expensive, and if I'm not mistaking you have to pay per CPU, and per connection.
quote:
SQL Server 2000 Pricing and Licensing
Based on extensive input from customers, partners, and analysts, Microsoft offers three licensing models for customers to license SQL Server 2000. Each model is designed to meet specific customer needs.
Processor license. Optimized for customers building business-to-business (B2B), business-to-consumer (B2C), and business-to-employee Web-based applications. A single license is required for each CPU in the operating system instance running SQL Server. This license does not require any device or user client access licenses (CALs).
Server plus device CALs. Optimized for non-Web-based scenarios in which there are multiple users per device (for example, kiosks). A license is required for the computer running SQL Server 2000, as well as a CAL for each client device.
Server plus user CALs. Optimized for non-Web-based scenarios in which there are multiple devices per user (for example, a laptop, PDA, and home PC). A license is required for the computer running SQL Server 2000, as well as a CAL for each user.
At this page you can see some prices....be prepared to be shocked 
Processor License: Standard Edition ; $4,999 US per processor
Processor License: Enterprise Edition ; $19,999 US per processor
 |
portfolio - linkshrinker - oxle - twitter |
Edited by - MarcelG on 03 March 2005 04:26:22 |
 |
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 03 March 2005 : 05:04:46
|
licenses are per CPU or per connection, not both, but you are correct in that it is expensive, I have a Dual processor version which cost more than all my other server hardware put together.
Charging for the size of your db is a way of recouping the cost, does seem a bit daft to me, as the license is not related to storage, but that is how everyone does it. |
|
|
|
Podge
Support Moderator
Ireland
3776 Posts |
Posted - 03 March 2005 : 07:46:37
|
quote:
Charging for the size of your db is a way of recouping the cost
and preventing 1 user from hogging the server.
Microsoft licencing is not the easiest thing to understand. I read up on it a bit last year before I purchased a 1 CPU Licence.
Hosting providers have the option of licencing SQL Server under the SPLA which is about $169 a month, in fact they're supposed to use that licence if they selling to a third party. If a host has 400 user db's on a server, thats a lot of profit. |
Podge.
The Hunger Site - Click to donate free food | My Blog | Snitz 3.4.05 AutoInstall (Beta!)
My Mods: CAPTCHA Mod | GateKeeper Mod
Tutorial: Enable subscriptions on your board
Warning: The post above or below may contain nuts. |
Edited by - Podge on 03 March 2005 07:46:56 |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 03 March 2005 : 08:10:22
|
quote:
Originally posted by Podge
quote:
Charging for the size of your db is a way of recouping the cost
and preventing 1 user from hogging the server.
Except DB size isn't any indication of how much work the server is doing, a 50Mb db with a lot of activity will use more sql resources than a 1GB database with little activity |
|
|
|
Podge
Support Moderator
Ireland
3776 Posts |
|
|
MarcelG
Retired Support Moderator
Netherlands
2625 Posts |
Posted - 03 March 2005 : 09:24:29
|
| @HuwR ; Very much true, and storage nowadays isn't the big cost factor, but somehow allmost all hosting providers use the storage-need as the way to determine the price. |
portfolio - linkshrinker - oxle - twitter |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 03 March 2005 : 09:50:41
|
quote:
Originally posted by marcelgoertz
@HuwR ; Very much true, and storage nowadays isn't the big cost factor, but somehow allmost all hosting providers use the storage-need as the way to determine the price.
Yes I know, and my own hosting costs are published that way, but I tend to be a lot more flexible over actual usage than most. |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 03 March 2005 : 09:52:23
|
quote:
Originally posted by Podge
Agreed.
HuwR, would you mind if I started a new topic?
I'm interested in any Sql Server maintainence you do or tips you can pass on.
Feel free, but a well setup SQL server should not require too much maintenance once it is running |
|
|
|
Podge
Support Moderator
Ireland
3776 Posts |
|
| |
Topic |
|
Topic Locked
