SQL_Hell
SQL Server DBA
- Local time
- Today, 23:47
- Joined
- Dec 4, 2003
- Messages
- 1,361
Ok good,thanks.
So the config looks fine, all at default settings.
But the indexes are really fragmented, so we need to rebuild them. I will be back tomorrow with code to reindex, in the meantime do not try and rebuild them yourself, it has to be done out of hours.
Also can you tell me what the record source of the problematic form is? query, direct tables, stored procedure?
If the reindex doesn't completely fix it,then we need to look at tuning with the ultimate goal of this form opening in under a second.
So the config looks fine, all at default settings.
But the indexes are really fragmented, so we need to rebuild them. I will be back tomorrow with code to reindex, in the meantime do not try and rebuild them yourself, it has to be done out of hours.
Also can you tell me what the record source of the problematic form is? query, direct tables, stored procedure?
If the reindex doesn't completely fix it,then we need to look at tuning with the ultimate goal of this form opening in under a second.