Post reply

how to reduce sorting cost?

  • February 13, 2014 at 6:01 am

    #1688692

    I will try to tuning that blocking query.

    I have configured TEMPDB at initial stage and different location, not in user database files location, Also configured MAXDOP and cost of threshold parallelism as below

    1.MAXDOP currently setting is 8

    Server has CPU device ID = 2 (CPU0, CPU 1)

    CPU0 = Processor Cores = 4, logical Processors = 8

    CPU1 = Processor Cores = 4, logical Processors = 8

    2. Cost of threshold parallelism: 50 (for typical OLTP database)

    I created one additional file NDF file in tempdb, so MDF &NDF file are both are each size 3GB, totally Tempdb allocated 6GB. Again I will monitor tempdb usages during the report generation and how much fee space available during that time.

    Thanks

    ananda

Viewing post 16 (of 16 total)

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