Lee posted on June 26, 2009 16:11
The acceptable level, or threshold, for you to contemplate

 

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.


 

 


Posted in: SQL Server Performance  Tags:

Comments

Add comment




  Country flag

biuquote
  • Comment
  • Preview
Loading




by Lee Everest, M.S.

Search


Ads

Calendar

«  July 2010  »
MoTuWeThFrSaSu
2829301234
567891011
12131415161718
19202122232425
2627282930311
2345678
View posts in large calendar

Tags

Disclaimer
The opinions, code, examples, et.al. expressed herein are my own personal opinions and do not represent my employer's view in any way, shape form, or fashion.  All code for demonstration purposes - no guarantees, either written or implied, are made.

© Copyright 2010 Lee Everest's SQL Server, etc. weblog