Sunday, September 22, 2013

4 NUMA Support MSSQL Server in AWS

I like to test my lab environment with NUMA. However, since it is not possible to simulate that in VMWare and getting my own physical hardware is too expensive. I have been thinking about using AWS.

After truing out different configuration, I finally got what I need with cr1.8xlarg

Here is the coreinfo output:

image

image

SQL Server

image

When check various DMV, it show up 3 nodes. Node 1 and Node 0 are real NUMA node. The Node ID 64 is reserve for DAC.

 

SELECT * FROM SYS.DM_OS_SYS_INFO;
SELECT DISTINCT MEMORY_NODE_ID FROM SYS.DM_OS_MEMORY_CLERKS;
SELECT * FROM SYS.DM_OS_MEMORY_NODES;
SELECT * FROM SYS.DM_OS_NODES;

 

image

image

select * from sys.dm_os_schedulers order by scheduler_id

The scheduler status “HIDDEN” is the scheduler that reserve for Database Engine.

image

 

Reference

http://blogs.msdn.com/b/psssql/archive/2011/11/11/sql-server-clarifying-the-numa-configuration-information.aspx

4 comments:

  1. --------------
    http://bantalsilikon01.blogspot.com/2014/10/rekomendasi-untuk-cloud-dedicated.html
    ---------------
    http://kopiluwakliar01.blogspot.com/2014/07/kopi-luwak-liar-arabica-dari-dataran.html
    http://vvty.in/uncategorized/bantal-silikon-185-000-free-ongkir-seluruh-nusantara/
    http://marinirseo.blogspot.com/2014/10/perumahan-baru-di-tangerang-graha-raya.html
    http://bantalsilikon01.blogspot.com/2014/10/perumahan-baru-di-tangerang-graha-raya.html
    http://bantalsilikon01.blogspot.com/2014/11/bantal-silikon.html
    http://bantalsilikon01.blogspot.com/
    http://marinir-seo.blogspot.com/2014/10/marinir-seo.html
    http://kopiluwakliar01.blogspot.com/2014/10/perumahan-baru-di-tangerang-graha-raya.html

    lkmnprapto@gmail.com
    http://vvty.in/http://vvty.in/http://vvty.in/
    http://vvty.in/http://vvty.in/http://vvty.in/
    http://marinir-seo-konsultan-12a.blogspot.com/2014/10/aaa.html
    http://asdf-14.blogspot.com/2014/10/hhh.html
    http://vvtiin.blogspot.com/2014/10/iii.html
    http://marinir-seo-8.blogspot.com/2014/10/jjj.html
    http://bantaljkt1.blogspot.com/2014/10/sss.html
    http://dfes12.blogspot.com/2014/10/rrr.html
    http://seo-guru01.blogspot.com/2014/10/qqq.html
    http://jksbindo.blogspot.com/2014/10/ppp.html
    http://jkt-49.blogspot.com/2014/10/ooo.html
    http://seokonsultan1.blogspot.com/2014/10/nnn.html
    http://guru-seo-malang.blogspot.com/2014/10/mmm.html
    http://seo-aaa.blogspot.com/2014/10/lll.html
    http://seo-konsultasi-mudah.blogspot.com/2014/10/kkk.html
    http://bantal-silikon15.blogspot.com/2014/10/ggg.html
    http://agen-seo16.blogspot.com/2014/10/fff.html
    http://agen-seo17.blogspot.com/2014/10/eee_30.html
    http://agen-seo18.blogspot.com/2014/10/ddd.html
    http://agen-seo19.blogspot.com/2014/10/ccc.html
    http://agen-seo20.blogspot.com/2014/10/bbb.html
    http://bumbu-pecel01.blogspot.com/2014/10/xxx.html

    bumbupecel1.blogspot.com
    http://bantalasdf.blogspot.com/2014/10/aaa.html
    http://seo-malang-19.blogspot.com/2014/10/bbb.html
    http://agenseomalang18.blogspot.com/2014/10/ccc.html
    http://marinirseo17.blogspot.com/2014/10/ddd.html
    http://bumbupecel16.blogspot.com/2014/10/eee.html
    http://domainhosting15.blogspot.com/2014/10/fff.html
    http://bumbupecel15.blogspot.com/2014/10/ggg.html
    http://marinirseo14.blogspot.com/2014/10/hhh.html
    http://bantalsilikon12a.blogspot.com/2014/10/iii.html
    http://marinirseo12.blogspot.com/2014/10/jjj.html
    http://bumbu-pecel-hz.blogspot.com/2014/10/kkk.html
    http://marinir-seo-001.blogspot.com/2014/10/lll.html
    http://bantal-silikon-murah.blogspot.com/2014/10/mmm.html
    http://vvty-ine.blogspot.com/2014/10/nnn.html
    http://give-a-power.blogspot.com/2014/10/ooo.html
    http://bumbupecel-12.blogspot.com/2014/10/ppp.html
    http://marinir-seo-konsultan.blogspot.com/2014/10/qqq.html
    http://guru-seo-praktisi-123.blogspot.com/2014/10/rrr.html
    http://guru-seminar-online01.blogspot.com/2014/10/sss.html
    http://kopiluwakmalang11.blogspot.com/2014/10/ttt.html

    ReplyDelete
  2. This comment has been removed by the author.

    ReplyDelete
  3. Can I tell you guys about the way that people are working on outsourcing devops? If you guys know about it, then you will be too much happy and you will be doing things that are not for you, but for me also. It will be different.

    ReplyDelete
  4. dewacintaqq
    Bandar poker terpercaya
    Poker Indonesia
    Poker Online Indonesia
    Agen Ceme Online
    Daftar Situs Poker
    Poker Online Terpercaya
    Judi Poker
    Poker Online Uang Asli
    Poker Uang Asli
    Situs Poker Online
    Agen Poker
    Situs Judi Online Terpercaya
    bandar poker
    situs judi
    poker online
    ceme online
    bandar ceme
    situs poker
    bandar judi
    poker idn
    judi poker
    judi online
    agen judi
    bandar judi
    poker idn
    agen poker
    idn poker
    Situs Judi Poker Online
    DominoQQ IDN POKER
    Agen judi kartu deposit uang asli pkv
    games
    poker online
    dominoqq
    bandarqq
    bandar poker
    bandarq
    sakong
    aduq
    capsa susun
    Perang bacarat
    -------------------------------------------------------------------------------------------
    Daftar Dominohalo
    Bandar poker terpercaya
    judi poker online
    bandar poker online
    judi online
    poker online
    dominoqq
    situs judi online
    situs poker online
    -----------------------------------------------------------------------------------------
    Daftar twinpoker88
    Bandar poker terpercaya
    judi online
    situs judi online
    poker online
    dominoqq
    bandarqq
    bandar poker
    bandarq
    sakong
    aduq
    capsa susun
    -----------------------------------------------------------------------------------
    Daftar Delimapoker
    Bandarq online terpercaya
    Delimapoker situs resmi daftar judi online bandar poker
    bandar66
    sakong
    capsa
    domino99
    aduq uang asli qq online domino QQ
    bandarq
    judi online
    bandar poker
    qq online
    ----------------------------------------------------------------------------------
    Daftar Papadomino
    Bandar poker terpercaya
    situs judi online
    judi online
    situs poker online
    poker online
    dominoqq
    domino99
    bandarq

    ReplyDelete

 

SQL Panda Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates