we are having ongoing time out issues/conenction issues with our Sql server db 2003. some people think if we add three more drives (up from 5 now) this will spread the load and cut down on these time out issues. What do you think?
this was the advice (below) does this make sense?
Add at least three more disk volume e.g. Log File: F drive Tempdb: G Drive Backup Drive or external storage: K ( Full/Differential Database Backup, Transaction backup)
- Move tempdb database on G drive
- Move log file of database like Enterprise and ssdn on F drive.
- Logs database are in FULL recovery model. if this is only for audit and only have insert operation, i would suggest to change it to Simple recovery model.
- DO NOT TAKE BACKUP IN data or log file drive. (Currently transaction log backup happening in E Drive which is data and log file location)
- Configured user options e.g. “Set Nocount on” at Server Level as user didn’t use as best practice.