• Yes I will be updating table stat today , this is a million rows heap table. we had done a rubild indexing but did noit helped last week

    As per the application vendor , its their design not to have cluster PK on the table instead all the tables are non cluster PK.

    This query will run from the app spawing more than 300 connections to the DB and makes lots of SOS_schedular_yeild and making CPU almost 95%. We have to restart the app to get it normal.

    Please let me have the plan of action?

    "More Green More Oxygen !! Plant a tree today"