• Welcome to TechPowerUp Forums, Guest! Please check out our forum guidelines for info related to our community.

Cost of SQL server, software, etc?

OrbitzXT

New Member
Joined
Mar 22, 2007
Messages
1,969 (0.32/day)
Location
New York City
System Name AX-01
Processor Intel Core i5-2500K @3.7 GHz
Motherboard ASRock Z68 Extreme3 Gen3
Cooling Zalman 9700
Memory Kingston HyperX T1 Series 8GB DDR3 1600 MHZ
Video Card(s) GTX 590
Storage Intel X25-M
Display(s) 42" Samsung LED HDTV
Case Antec Twelve Hundred
Audio Device(s) HT | OMEGA STRIKER 7.1
Power Supply Kingwin 1000W
Software Windows 7 64-Bit
My boss is doing some business with some people and asked me if this cost sounded right to him. I wasn't sure so I thought I'd ask here. Here's what was written in the email:

The SQL server which will require a server tower, a copy of Windows Small Business Server and a copy of SQL server. The exact costs of the equipment and licensing needs to be determined, but the server, licensing and labor should not cost more than 4,000

If you ignore the labor which they'll determine, how much do the other items cost roughly?
 

Fourstaff

Moderator
Staff member
Joined
Nov 29, 2009
Messages
10,020 (1.91/day)
Location
Home
System Name Orange! // ItchyHands
Processor 3570K // 10400F
Motherboard ASRock z77 Extreme4 // TUF Gaming B460M-Plus
Cooling Stock // Stock
Memory 2x4Gb 1600Mhz CL9 Corsair XMS3 // 2x8Gb 3200 Mhz XPG D41
Video Card(s) Sapphire Nitro+ RX 570 // Asus TUF RTX 2070
Storage Samsung 840 250Gb // SX8200 480GB
Display(s) LG 22EA53VQ // Philips 275M QHD
Case NZXT Phantom 410 Black/Orange // Tecware Forge M
Power Supply Corsair CXM500w // CM MWE 600w
Friend thinks its a bit pricey, he can use MySQL which is free, and some consumer grade stuff it should be about half the price, depending on components. He also said consider standard server edition, rather SBS edition.

Not sure how accurate his views might be, but he has some experience with maintaining servers so I wouldn't ignore his views.
 

brandonwh64

Addicted to Bacon and StarCrunches!!!
Joined
Sep 6, 2009
Messages
19,542 (3.66/day)
Do you have network racks with UPSes? If so then pickup a rack mounted case and a cheap MOBO/RAM/CPU combo, then maybe 4x1TB drives for storage. Install free MySQL and setup for your network. DONE
 
Joined
Feb 18, 2006
Messages
5,147 (0.78/day)
Location
AZ
System Name Thought I'd be done with this by now
Processor i7 11700k 8/16
Motherboard MSI Z590 Pro Wifi
Cooling Be Quiet Dark Rock Pro 4, 9x aigo AR12
Memory 32GB GSkill TridentZ Neo DDR4-4000 CL18-22-22-42
Video Card(s) MSI Ventus 2x Geforce RTX 3070
Storage 1TB MX300 M.2 OS + Games, + cloud mostly
Display(s) Samsung 40" 4k (TV)
Case Lian Li PC-011 Dynamic EVO Black
Audio Device(s) onboard HD -> Yamaha 5.1
Power Supply EVGA 850 GQ
Mouse Logitech wireless
Keyboard same
VR HMD nah
Software Windows 10
Benchmark Scores no one cares anymore lols
depending on your install the base price of the server 2008 R2 64-bit and SQL Server R2 64-bit Enterprise should be in the range of 8000$ for typical small business licensing. (handful of SQL licenses, 1-2 servers) It could be less depending on what you're using it for, if you can get away with less licenses, and if you're business can apply for any discount. Since my work does online learning and has charter schools we use the education pricing.

This is why for small businesses it's more typical to see a MySQL setup on a linux server. But this of course requires someone more familiar with linux.

In the end the quote is a quote. It will be far more accurate than any advice on here becuase they'll know your specifications and what you need it for. Get several and compare them. Any good purchaser would.


edit: to be clear the cost sounds low to me, make sure you're getting quality hardware and correct licensing for what you need. But then again you could be looking for bare minimum and 4000$ would be that.
 

Easy Rhino

Linux Advocate
Staff member
Joined
Nov 13, 2006
Messages
15,443 (2.43/day)
Location
Mid-Atlantic
System Name Desktop
Processor i5 13600KF
Motherboard AsRock B760M Steel Legend Wifi
Cooling Noctua NH-U9S
Memory 4x 16 Gb Gskill S5 DDR5 @6000
Video Card(s) Gigabyte Gaming OC 6750 XT 12GB
Storage WD_BLACK 4TB SN850x
Display(s) Gigabye M32U
Case Corsair Carbide 400C
Audio Device(s) On Board
Power Supply EVGA Supernova 650 P2
Mouse MX Master 3s
Keyboard Logitech G915 Wireless Clicky
Software The Matrix
like others said, scrap M$

get yourself a free copy of Centos6, and load up MySQL 5.6 on it with phpmyadmin. stick on any decent quad core and you've got yourself a small business database for cheap.
 

OrbitzXT

New Member
Joined
Mar 22, 2007
Messages
1,969 (0.32/day)
Location
New York City
System Name AX-01
Processor Intel Core i5-2500K @3.7 GHz
Motherboard ASRock Z68 Extreme3 Gen3
Cooling Zalman 9700
Memory Kingston HyperX T1 Series 8GB DDR3 1600 MHZ
Video Card(s) GTX 590
Storage Intel X25-M
Display(s) 42" Samsung LED HDTV
Case Antec Twelve Hundred
Audio Device(s) HT | OMEGA STRIKER 7.1
Power Supply Kingwin 1000W
Software Windows 7 64-Bit
Thanks all for the information. I'm not sure if this is contractual work he's doing where specifications say he must use the M$ options, or if it's something personal where he can do as he pleases. I'll ask him about it and present the options that were given here.
 
Joined
Aug 10, 2007
Messages
4,267 (0.70/day)
Location
Sanford, FL, USA
Processor Intel i5-6600
Motherboard ASRock H170M-ITX
Cooling Cooler Master Geminii S524
Memory G.Skill DDR4-2133 16GB (8GB x 2)
Video Card(s) Gigabyte R9-380X 4GB
Storage Samsung 950 EVO 250GB (mSATA)
Display(s) LG 29UM69G-B 2560x1080 IPS
Case Lian Li PC-Q25
Audio Device(s) Realtek ALC892
Power Supply Seasonic SS-460FL2
Mouse Logitech G700s
Keyboard Logitech G110
Software Windows 10 Pro
MySQL is good. SQL Express is also good and free, just to be fair to MS :)

Being quoted for SBS? My thought is that this build is not just to host an SQL server but perhaps a domain controller and other roles?
 

Easy Rhino

Linux Advocate
Staff member
Joined
Nov 13, 2006
Messages
15,443 (2.43/day)
Location
Mid-Atlantic
System Name Desktop
Processor i5 13600KF
Motherboard AsRock B760M Steel Legend Wifi
Cooling Noctua NH-U9S
Memory 4x 16 Gb Gskill S5 DDR5 @6000
Video Card(s) Gigabyte Gaming OC 6750 XT 12GB
Storage WD_BLACK 4TB SN850x
Display(s) Gigabye M32U
Case Corsair Carbide 400C
Audio Device(s) On Board
Power Supply EVGA Supernova 650 P2
Mouse MX Master 3s
Keyboard Logitech G915 Wireless Clicky
Software The Matrix
MySQL is good. SQL Express is also good and free, just to be fair to MS :)

Being quoted for SBS? My thought is that this build is not just to host an SQL server but perhaps a domain controller and other roles?

maybe, but hopefully he should know that putting a sql server on the same host as a domain controller is certainly not best practice.

they should setup a nice dual quad machine with 32 gigs of ram on a windows server 2008 R2 license since they must have it. then get the windows hyper-v and create a domain vm, an AD vm and a sql server vm. you could then also setup a few development vms to test upgrades before putting them in production.
 
Joined
Aug 10, 2007
Messages
4,267 (0.70/day)
Location
Sanford, FL, USA
Processor Intel i5-6600
Motherboard ASRock H170M-ITX
Cooling Cooler Master Geminii S524
Memory G.Skill DDR4-2133 16GB (8GB x 2)
Video Card(s) Gigabyte R9-380X 4GB
Storage Samsung 950 EVO 250GB (mSATA)
Display(s) LG 29UM69G-B 2560x1080 IPS
Case Lian Li PC-Q25
Audio Device(s) Realtek ALC892
Power Supply Seasonic SS-460FL2
Mouse Logitech G700s
Keyboard Logitech G110
Software Windows 10 Pro
Normally true.

I believe that's partially why SBS gets such a bad rap. Some may have legitimate reasons for their dislike of SBS, but many times I see judgement made before understanding SBS. It doesn't follow the standard best practices and has been tailored to be domain-in-a-box value solution for small businesses. And not all of them, just ones would take advantage of a majority of the bundled features.

My thinking is that the consultant went with SBS for a reason instead of Foundation or Standard. We'll have to see after Orbitz talks with the boss man.
 
Top