question

AbdulBasith-2983 avatar image
0 Votes"
AbdulBasith-2983 asked SeeyaXi-msft edited

Not recommending to overcommit the CPU's for Tire 1 SQL Workloads (vCPU:pCPU= 1:1) Compression is recommended to do in Database Table levels for OLTP databases (Not recommend to use storage level dedup & compression )

No 1. Not recommending to overcommit the CPU's for Tire 1 SQL Workloads (vCPU:pCPU= 1:1)

No 2. Compression is recommended to do in Database Table levels for OLTP databases (Not recommend to use storage level dedup & compression )

Can i get MS recommendations with supported links

azure-sql-databaseazure-sql-virtual-machines
· 4
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.

Can you give a context for this question? From where are you getting these messages? You tagged Azure Sql Database. Is this related to Azure SQL VMs?

0 Votes 0 ·

yes azure sql vm

0 Votes 0 ·

Hi @AbdulBasith-2983,

Welcome to Microsoft Q&A!
Since I refer to some Microsoft documents, I think you are using Azure SQL VMs. But I still need to confirm with you.
If it is, I will modify the tag for you.

Best regards,
Seeya

0 Votes 0 ·

Yes Azure SQL vm

0 Votes 0 ·

1 Answer

TomPhillips-1744 avatar image
0 Votes"
TomPhillips-1744 answered TomPhillips-1744 edited

MS does not have a general guidelines for non-MS VMs. You should consult your VM manufacturer.

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.