Post reply

SQL Scheduling

  • February 14, 2011 at 12:14 pm

    #246689

    I understand that the SQLOS uses schedulers to manage the the execution of user requests, and that the schedulers map 1-1 to the CPU's. But is this per core or per socket?

  • February 14, 2011 at 12:26 pm

    #1286676

    SQL will use all available cores unless you tell it not to; you can select it by right clicking the server>>Properties as seen below; my machine is a single proc 4 core machine...you can see that all cores appear in SSMS:

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • February 14, 2011 at 12:29 pm

    #1286679

    The SQLOS schedulers map 1-1 with the cores presented to the OS: http://www.runsmall.com/2009/03/sqlos-move-along-nothing-to-see-here.html

  • February 14, 2011 at 12:31 pm

    #1286682

    thanks for the reply lowell & adam, just remembered sys.dm_os_schedulers too. oops.:-D

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply