If we increase the Threshold value, it will cause to Lock the SQL Server, mean if any other users are trying to get the data from Data Base, it will accessing error...
So to avoid that we have to limit the records to Max value. MIcrosoft has suggested max value is 5000
So it's better don't increase Threshold value
