question

SagarK-6765 avatar image
0 Votes"
SagarK-6765 asked Cathyji-msft commented

Server Sizing for SQL sever

How to calculate cores required for SQL server depends upon the number of IOPS and size of data.

sql-server-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @SagarK-6765,

We have not received a response from you. Did the reply(s) could help you? If the response helped, do "Accept Answer". If it is not, please let us know. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

0 Votes 0 ·
DanGuzman avatar image
0 Votes"
DanGuzman answered

The number of cores needed is not directly dependent on IOPS or data size. It depends more on the overall workload characteristics, considering the types of queries (i.e. OLTP versus reporting), query frequency, and performance SLAs.

Estimating hardware resources is not an exact science but you might be able to get reasonably close by analyzing a reference system with the same or similar workload.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered

Hi @SagarK-6765,

Quote from the blog SQL Server Hardware Sizing.

The core-balanced approach starts with the throughput of the CPU core, and then builds a balanced system that is based on that metric. It is important to realize that Maximum Consumption Rate (MCR) is purely a measure of SQL Server data throughput for a single core and does not include disk read operations or network I/O. The goal is to determine the core’s MCR and use that to calculate the number of cores that are required to support the target data throughput rate.

If I misunderstood your issue, please let me know.


If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar thread.



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.