Stored procedures used for performance benefit

This topic lists the stored procedures that you should run regularly for performance benefits.

Note: This topic applies to only on-premises environments.

sp_updatestats: Run this SQL-supplied stored procedure regularly for statistics updating for all tables in a database. You can get more information about this stored procedure from the SQL online help.
SLServerRestartSp: This stored procedure runs whenever the database server is restarted (since no one is logged in at that time) and performs general cleanup.
PurgeNextKeysSp: Run this stored procedure to clean up the NextKeys table. NextKey records are inserted, never updated to get concurrency. This stored procedure cleans out the extra rows. DO NOT run this utility while others are using the system. The utility will lock users out, but you should log everyone out of the system before running this utility.