SQL Server – HyperThread Ratio

Background

Trained Aireforge Studio against a set of SQL Server Instances that serve one of our one Applications.

 

AireForge Studio

Compare

Image

 

Explanation

The Numbers looked OK

  1. Max Server Memory
    • In Dev, we have 8 GB of RAM
      • We set our Max Memory to 6.2 ( max  server memory )
      • BTW, the number of actual memory is available via total_physical_memory
    • In QA/Test/Prod, we have 64 GB of RAM
      • We have set Max Memory to 58 GB
      • Again, the number of memory installed in box is displayed in the total_physical_memory
      • We have an average of 48 GB available in all three environments
  2. Total Page File in GB & Available Page File in GB
    • Will skip in depth discussion for now
    • Except to note that it is much smaller in Dev, where we have only 8 GB
  3. CPU Count
    • We have 4 CPUs in Dev
    • And, 8 in QA, Test, and Production
  4. HyperThread Ratio
    • In Dev, QA, and Production the Hyper Thread Ratio is 1
    • And, Test is 2

 

HyperThread Ratio

HyperThread Ratio?

Where is HyperThread coming from?

 

SysInternals

Process Explorer

Again, we go back on the SysInternals line, and get Process Explorer.

To get System Information, we click on the menu Item “View” \ “System Information”

TEST

Image

Explanation
  1. Raw
    • Cores is at 8
    • Sockets is at 4
  2. Interpretation
    • Hyperthread ratio is Cores / Sockets
      • 8 /4 = 2

 

 

Prod

Image

Explanation
  1. Raw
    • Cores is at 8
    • Sockets is at 8
  2. Interpretation
    • Hyperthread ratio is Cores / Sockets
      • 8 /8 = 1

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s