• 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.50/day)
Likes
59
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
#1
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
9,379 (3.16/day)
Likes
2,101
Location
Home
System Name Asus K50-X5DAB \\ Orange!
Processor Athlon QL-65 2.2Ghz \\ 3570K
Motherboard Laptop \\ ASRock z77 Extreme4
Cooling Laptop \\ H100i
Memory 1x1GB + 1X2GB \\ 2x4Gb 1600Mhz CL9 Corsair XMS3
Video Card(s) Mobility Radeon HD4570 512mb \\ Zotac 660Ti OC 2Gb
Storage 250Gb \\ Samsung 840 250Gb + Toshiba DT01ACA300 3Tb
Display(s) 15.6" 1366x768 \\ LG 22EA53VQ
Case Laptop Chassis \\ NZXT Phantom 410 Black/Orange
Power Supply Power Brick \\ Corsair CXM500w
#2
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,527 (6.39/day)
Likes
6,950
Location
Chatsworth, GA
System Name The StarCrunch Defender! | X58 Cruncher!
Processor I7 6700K @ STOCK | Intel I7-920
Motherboard Gigabyte Z170X-UD5 | Alienware MS-7543 X58
Cooling Corsair A70 Push/Pull | Corsair H50
Memory Crucial Ballistix DDR4 2400 MHz | Pereema 3x2GB DDR3
Video Card(s) Gigabyte Gaming G1 GTX 1070 | Gigabyte 7970 3GB
Storage 2x Samsung Pro 256GB M.2 SSD's in Raid 0 | 4TB Western Digital SATA drive
Display(s) ViewSonic VG2227wm 1080P | OLD viewsonics
Case NZXT Tempest 410 Elite | NZXT Source 210
Audio Device(s) Onboard
Power Supply Corsair 750TX | Enermax Liberty 500W
Mouse MX518 | MX502
Keyboard TESORO Mechanical | ANZO Mechanical
Software Windows 10 Pro on both
#3
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,108 (1.17/day)
Likes
1,284
Location
AZ
System Name Thought I'd be done with this by now
Processor i7 4790K 4.4GHZ turbo currently at 4.6GHZ at 1.16v
Motherboard MSI Z97-G55 SLI
Cooling Scythe Mugen 2 rev B (SCMG-2100), stock on gpu's.
Memory 8GB G.SKILL Ripjaws Z Series DDR3 2400MHZ 10-12-12-31
Video Card(s) EVGA GTX 760 Superclocked replaced HIS R9 290 that was artifacting
Storage 1TB MX300 M.2 OS + Games, 4x ST31000524NS in Raid 10 Storage and Backup, external 2tb backup,
Display(s) BenQ GW2255 surprisingly good screen for the price.
Case Raidmax Scorpio 668
Audio Device(s) onboard HD
Power Supply EVGA 750 GQ
Software Windows 10
Benchmark Scores no one cares anymore lols
#4
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
Joined
Nov 13, 2006
Messages
14,414 (3.53/day)
Likes
4,275
System Name VHOST01 | Desktop
Processor i7 980x | i5 7500 Kaby Lake
Motherboard Gigabyte x58 Extreme | AsRock MicroATX Z170M Exteme4
Cooling Prolimatech Megahelams | Stock
Memory 6x4 GB @ 1333 | 2x 8G Gskill Aegis DDR4 2400
Video Card(s) Nvidia GT 210 | Nvidia GTX 970 FTW+
Storage 4x2 TB Enterprise RAID5 |Corsair mForce nvme 250G
Display(s) N/A | Dell 27" 1440p 8bit GSYNC
Case Lian Li ATX Mid Tower | Corsair Carbide 400C
Audio Device(s) NA | On Board
Power Supply SeaSonic 500W Gold | Seasonic SSR-650GD Flagship Prime Series 650W Gold
Mouse N/A | Logitech G900 Chaos Spectrum
Keyboard N/A | Posiden Z RGB Cherry MX Brown
Software Centos 7 | Windows 10
#5
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.50/day)
Likes
59
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
#6
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,064 (1.07/day)
Likes
1,130
Location
Geneva, 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
#7
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
Joined
Nov 13, 2006
Messages
14,414 (3.53/day)
Likes
4,275
System Name VHOST01 | Desktop
Processor i7 980x | i5 7500 Kaby Lake
Motherboard Gigabyte x58 Extreme | AsRock MicroATX Z170M Exteme4
Cooling Prolimatech Megahelams | Stock
Memory 6x4 GB @ 1333 | 2x 8G Gskill Aegis DDR4 2400
Video Card(s) Nvidia GT 210 | Nvidia GTX 970 FTW+
Storage 4x2 TB Enterprise RAID5 |Corsair mForce nvme 250G
Display(s) N/A | Dell 27" 1440p 8bit GSYNC
Case Lian Li ATX Mid Tower | Corsair Carbide 400C
Audio Device(s) NA | On Board
Power Supply SeaSonic 500W Gold | Seasonic SSR-650GD Flagship Prime Series 650W Gold
Mouse N/A | Logitech G900 Chaos Spectrum
Keyboard N/A | Posiden Z RGB Cherry MX Brown
Software Centos 7 | Windows 10
#8
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,064 (1.07/day)
Likes
1,130
Location
Geneva, 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
#9
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.