September 20, 2018 at 6:41 am
Hi,
What is the minimum best hardware for
Microsoft SQL Server 2012 - 11.0.5058.0 (X64) May 14 2014 18:34:29 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: ) (Hypervisor) ?
Currently I've
1. VMware, Inc. VMware Virtual Platform
2. Windows Server 2012 Standard
3. Quad-Core AMD Opteron(tm) Processor 8389, Quad-Core AMD Opteron(tm) Processor 8389
4. Installed RAM, 16 GB
5. NET Framework 4.5
6. ASP.NET 4.5
September 25, 2018 at 1:42 pm
Your question has inadequate detail. You can certainly run SQL 2012 on that hardware, but the only really important question is what kind of workload you expect to get out of it. More important information to feed THAT question is things like number of concurrent users, volume of data in the database, and the umber of transactions per minute that could be expected, given the number of users. Frankly, most workloads are going to be a bit RAM constrained at just 16 GB, and I would consider anything less than 32 GB in the seriously under powered category. Many workloads use considerably more. Do you know what the values are for the number of concurrent users, number of transactions per minute, and size of the database ?
EDIT: at 16 GB, VMWare is probably a waste of money unless your workloads are extremely small.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
September 26, 2018 at 12:25 pm
Are things working well? If so, ask for 32GB RAM, and similar CPU. Of course, better storage than you have now.
If things aren't working well, ask for 128GB of RAM and get time to tune some code.
September 26, 2018 at 10:13 pm
I've 100 concurrent users. Looks like 16 GB RAM is so small for SQL Server 2012 Standard Edition / Enterprise Edition
September 27, 2018 at 10:18 am
Yes, 16 is small, though how much data? If you have <16GB of data, maybe it's fine and you need to worry more about code and indexing.
September 27, 2018 at 4:14 pm
This was removed by the editor as SPAM
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply