Forwarded Records threshold in SQL Server

Regarding forwarded records, I did not see anything published on Google!, in Lori Brown’s article in SQL Server Magazine (April 2009), or anywhere else for that matter regarding the level or number of acceptable forwarded records in a SQL Server database, so I thought that I would add something here for you. Based on research from Microsoft, and from suggestions from their Risk Assessment Program (RAP), the number of forwarded records should be less than 10 for every 100 batch requests. (Which is a silly way of saying < 10%, right?).

To translate, let’s say that you open up Performance Monitor and add both counters, and you see 3000 batch requests and 1000 forwarded records on average. In this example, you are well over the amount of acceptable forwarded records in your database, and they should be cleaned up accordingly.

Lee

-----------------------------

Or, if you’re smart, add a clustered index to each table and be done with it.