Thanks all for their suggestion. Help me a lot to understand what are different ways and risks.

Now,we have decided to reorganize indexes or tell development team to partition table.

We have...

Thanks a lot Kevin for you suggestion.

Hardware perspective, we can't do anything. we have New hardware and SQL 2014 for other products but this one is old.

Moreover, some other...