Hi! Welcome to dynamicsusers.net Please, search the forums for "SQL Performance" and you'll see, that these issues are actually permanetly discussed. Performance Optimization of NAV on SQL Server is a complex task, and you will get "gazillions" of valuable advice! Good Luck! Jörg