Follow the below process to increase number of records for a particular user,

Supported Way:

Step 1: Open Microsoft Dynamics CRM Online / On-premise. Click on Gear Icon on Top Right Corner. Click on Options.

Step 2: Under General tab, select “Records Per Page” to the required records count per page. (Min: 25 and Max: 250)

Step 3: Click on OK.

UnSupported Way:

In MS CRM OnPremises, Open Microsoft SQL Server Management Studio.

Right Click on the required MSCRM Organization (OrganizationName_MSCRM) and click on New Query.

For Example, I am providing PAGINGLIMIT = 500 AND FULLNAME = ‘Arun Potti’ in the below query

Copy & Paste the below query and Execute,

UPDATE USERSETTINGS
SET PAGINGLIMIT=500
WHERE SYSTEMUSERID =
(
SELECT
TOP 1
SYSTEMUSERID
FROM
SYSTEMUSER
WHERE FULLNAME ='Arun Potti'
)

Refresh CRM Page and open any Entity or Advanced Find to see the effect.

Provide your valuable feedback on the article.