“The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request.”

Question

Hi, While viewing the tempo reports, I got the below error message. &ldquo;The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request.&rdquo; Please provide your suggestions.... 
 OriginalPostID-122665 
 OriginalPostID-122665

Aleksi White · Accepted Answer

This is a configuration on the SQL Server side, and the maximum is 2100:
msdn.microsoft.com/.../ms143432.aspx

As a workaround, you can try cutting the table into blocks of 2000 and then query each block separately

Myles Weber · Answer

If you are hitting max perimeters (or anywhere near it) from SQL server, you will likely have a scaling/performance issue also with this design. Be sure to test with ultimate production data size to ensure your end users will have adequate performance.