I have a large db that goes through regular maintenanceevery week. The problem seems to be that while the db is re-indexing some of mykey tables I get time out errors. Are there any suggestions on how I can combatthis problem. Management has tasked mewith having 24 hour access to the db because if people aren't completing theretransactions we don't get paid. I havealso noticed the timeout issue when we are running in files that create newrecords. Is this a basic problem withthe way the db is structured? Are theyany tools that I can use to change our process so that we can maintain the 24hour access to the db. How are othercompanies maintaining 24 hour access to there db?
Thanks in advance.
Don
When you are reindexing the tables do get locked and are inaccessible. You should request for a downtime window, let the users know and do your maintenance during the window. In 2005, there's online indexing available that might be of interest to you.
No comments:
Post a Comment