Post reply

Multiprocessor: How to prove all processors are used by SQL

  • November 7, 2006 at 7:42 am

    #116179

    Hi All,

    I've got an interesting question for those of an more technical bent.

    How do you prove that SQL Server 2000 Enterprise is fully utilising all processors on it's server. (Win 2003). This needs more than checking the config - proof is required as the maximum known load equals 1 processor and has never gone above that level.

    In this regard, are there any tools/methods/queries out there that could be run against SQL to force high CPU.

    Any and all advice welcome!

     


    The Aethyr Dragon

    Cape Town
    RSA

  • November 7, 2006 at 9:04 am

    #670303

    most dbcc commands will use multiple processors.

    write a rubbish view or query that forces a parallel plan - monitor processor use.

    write a number of heavy cursor based inserts/updates - run from twice as many workstations as you have procs.

    use a stress tool.

    If you have resaonable user activity it will always use all procs - task manager/perfmon will show each proc working. at 20 trans/sec I see 8 procs used on an 8 way.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • November 8, 2006 at 11:10 am

    #670660

    Try executing this command:

        DBCC SQLPERF(UMSSTATS)

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • November 9, 2006 at 1:47 am

    #670776

    Thanks for all the advice - MUCH appreciated!

    Cheers


    The Aethyr Dragon

    Cape Town
    RSA

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

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