• At minimum I would recommend checking the setting for 'max degree of parallelism' and making sure that is set to no more than 8, which is the number of physical cores in your machine.

    Thank you for cleared me doubts.. For the CPU Related points..

    Max Degree of Parallelism – currently showing values is “0” by default values. It means using all the available Logical CPU for SQL Transaction..

    If I have set values 8, SQL Transaction using only 8 logical processor, in which situation we should change the values Max Degree of Parallelism

    thanks

    ananda