August 20, 2018 at 12:30 pm
I am new to DB Administration and I'd like to know how to determine exact hardware settings for SQL Server Instance which gonna have 1000 concurrent users? What should be the CPU frequency or RAM. I know the min and max requirements, but it is obvious that this numbers are not the most efficient ones. If it has 1000 users does it mean it should have 1000 IOPS?
Thanks in advance.
August 20, 2018 at 2:23 pm
That answer is going to depend on more factors than just user count.
For example, if your database is 100MB and those users are only pulling a single record a day, you won't need much.
You have to get more details regarding database sizing and volume of activity expected.
I would ask the business the following types of questions:
1. How much data? How much data in the long run?
2. Warehouse or OLTP?
2. Who are the users? What types of queries will they be running?
They aren't going to know or predict all the requirements, but it will get them thinking along these lines and hopefully get you more details.
There isn't an exact science to this. Ultimately you are going to guestimate what is needed based on their requirements, and test/tweak in non production before going live.
August 20, 2018 at 5:59 pm
elea.grig - Monday, August 20, 2018 12:30 PMI am new to DB Administration and I'd like to know how to determine exact hardware settings for SQL Server Instance which gonna have 1000 concurrent users? What should be the CPU frequency or RAM. I know the min and max requirements, but it is obvious that this numbers are not the most efficient ones. If it has 1000 users does it mean it should have 1000 IOPS?
Thanks in advance.
As said in the previous post above, you need a whole lot more information before you can even take a stab at how big the power plug should be. My recommendation is to hire a consultant to help you. Just remember, with so little information, even a good consultant won't be able to help you. You need to come up with much better info including the intended use and the 5-7 year plan for how big your data will grow, what the DR plan should be, etc, etc.
--Jeff Moden
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply