SQL Server query times out after changing nvarchar 3000 to nvarchar 4000
<p>There is a table in a production database in which I changed one of the column lengths from <code>Nvarchar(3000)</code> to <code>Nvarchar(4000)</code>. </p>

<p>After that the application team is getting a timeout error. Could any of you suggest how to troubleshoot this issue? </p>

<p>There were no blockings when the query was executed.</p>