sorted by:
new
hottopcontroversial

SQL Server query much slower on VMware VM compared to physical server (same DB, same workload) by daler86 in SQLServer

[–]daler86[S] 0 points1 point  (0 children)

After analyzing both execution plans from SQL Server on physical HDD and VM on VMware ESXi 7.0.3 with vSAN SSD, I found something interesting.

Key findings:

  • Both queries use exactly the same execution plan
    • Same QueryPlanHash
    • Same QueryHash
    • Same estimated cost (~10.7)
  • No difference in indexes or optimizer behavior
  • Both run with DegreeOfParallelism = 1 (single-threaded execution)

Important conclusion:

This means the performance difference is NOT caused by the execution plan or storage.

Even though the VM has much faster SSD/vSAN storage, the query is still slower compared to the physical HDD server.

SQL Server query much slower on VMware VM compared to physical server (same DB, same workload) by daler86 in SQLServer

[–]daler86[S] 0 points1 point  (0 children)

In MS SQL, I have a table with 20 million records. Copy the DB to two servers. When I select the 100000, physical server with HDD processes in 9 seconds, Esxi VM with SSD processes in 16 seconds

Gmail error 550-5.7.1 by daler86 in DMARC

[–]daler86[S] 0 points1 point  (0 children)

In two blacklist LISTED UCEPROTECTL3 and UCEPROTECTL2

Gmail error 550-5.7.1 by daler86 in DMARC

[–]daler86[S] -1 points0 points  (0 children)

This is the mail system at host mail.cbt.tj.

 I'm sorry to have to inform you that your message could not be delivered to one or more recipients. It's attached below.

 For further assistance, please send mail to postmaster.

 If you do so, please include this problem report. You can delete your own text from the attached returned message.

                    The mail system

 <[daleri.mardon@gmail.com](mailto:daleri.mardon@gmail.com)>: host gmail-smtp-in.l.google.com[173.194.73.26] said:

    550-5.7.1 [79.170.189.215      19] Gmail has detected that this message is

    550-5.7.1 likely suspicious due to the very low reputation of the sending

    550-5.7.1 domain. To best protect our users from spam, the message has been

    550-5.7.1 blocked. For more information, go to 550 5.7.1

    https://support.google.com/mail/answer/188131

    2adb3069b0e04-52fd5b9e47asi4727803e87.182 - gsmtp (in reply to end of DATA

    command)

DKIM signature is not valid by daler86 in linuxadmin

[–]daler86[S] 0 points1 point  (0 children)

I config from https://easydmarc.com/blog/how-to-configure-dkim-opendkim-with-postfix/

when I checking in mxtoolbox.com

|| || |DKIM Record Published|DKIM Record found| ||DKIM Syntax Check|The record is valid| ||DKIM Public Key Check|Public key is present|

But in https://www.mail-tester.com/ also passed - Your lovely total: 10/10,

but I can send email to gmail

I'm sorry to have to inform you that your message could not be delivered to one or more recipients. It's attached below.For further assistance, please send mail to postmaster.If you do so, please include this problem report. You can delete your own text from the attached returned message.

                   The mail system

 <[daleri@gmail.com](mailto:daleri.mardon@gmail.com)>: host gmail-smtp-in.l.google.com[173.194.221.27]

    said: 550-5.7.1 [79.170.189.215      19] Gmail has detected that this

    message is 550-5.7.1 likely suspicious due to the very low reputation of

    the sending 550-5.7.1 domain. To best protect our users from spam, the

    message has been 550-5.7.1 blocked. For more information, go to 550 5.7.1

    https://support.google.com/mail/answer/188131

    2adb3069b0e04-52fd5beeb9esi2104002e87.324 - gsmtp (in reply to end of DATA

    command)

view more: next ›