Post reply

Processor

  • February 25, 2005 at 11:50 am

    #163488

    If you right click SQL server Property you will see tab for Processor

    What is 1 Processor or 2 processor( which I see on radio button)????

    What is Cofigured Value and Running Value???

     

    Please someone can explain me in shorter will be great.

    Thanks

    Nita

  • February 25, 2005 at 12:04 pm

    #544230

    This allows you to set how many of your available processors for parallel query execution.  By default, its use "all".

  • February 25, 2005 at 12:07 pm

    #544232

    Thanks, In my production its showing as 1, so 1 is default you mean.

    Thanks in advance

    Nita

     

  • February 28, 2005 at 5:24 am

    #544385

    The default is to use all available processors to parallel queries.

    Which radio button is checked? "Use all available processors" or "Use"?

    As for the configure & running.  Don't really understand that myself.  When you select running, it greys everything out...Not quite sure what that achieves!!

  • February 28, 2005 at 9:08 am

    #544447

    See Default it will show all the processors available in the system and all of them will be selected (used) by default.

    Here SQL is giving you a choice of how many processors you want to use for ur SQL server. You can uncheck the checkbox after stopping the sql server (if more than one processor is available)


    subban

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

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