I have been reading many things on the internet and I wanted to create a thread asking my question here. We currently do all the re-indexing and show contig's etc to maintain my sql data and to ensure everything is good to go there.
My question is, what about the physical drive and data. We house our mdf's on a raid 1_0 and our ldfs on raid 5. I am wondering if I need to defrag these drives b/c if not am i impacting my I/O on that box. If so should I stop the sql service so that it does not corrupt SQL data? Any help on this topic would be great.
-patrick
IF the database files are set to 'Autogrow' and 'Autoshrink', you can get substaintial file fragmentation.
If you maintain your databases, and deliberately enlarge the files only rarely, then you may not have much file fragmentation.
If necessary to defrag the drives, I would prefer to stop SQL Server (and have recent backups).
No comments:
Post a Comment