• 20 seems high, but your real issue is the scans (as you already know).

    Are the indexes and stats being created, maintained, reviewed and altered as appropriate?

    ------------------------------------------------------------------------------------------------Standing in the gap between Consultant and ContractorKevin3NFDallasDBAs.com/BlogWhy is my SQL Log File HUGE?!?![/url]The future of the DBA role...[/url]SQL Security Model in Plain English[/url]