July 8, 2009 at 9:26 am
True SA. My straight question to everyone here. Does defrag also affect index defrag. This is not an an easy question and this depends on how defrag affects data pages. Has anyone experienced this or some errant behaviour after defrag is done?
-MJ
Please do not print mails and docx unless it is absolutely necessary. Spread environmental awareness.
July 8, 2009 at 1:46 pm
1. Disk volumes need to be defragged.
2. I prefer PerfectDisk (defraggler seems to work nicely too) - both are faster than Diskeeper, and all three are many times better than the Default Defragger.
3. Disk defrag is separate from Index defrag. Idx defrags must also be done.
4. In addition to defrag, you should verify cluster sizes and paritition alignment of your database volumes. These will also have significant impact on disk performance.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 8, 2009 at 1:46 pm
1. Disk volumes need to be defragged.
2. I prefer PerfectDisk (defraggler seems to work nicely too) - both are faster than Diskeeper, and all three are many times better than the Default Defragger.
3. Disk defrag is separate from Index defrag. Idx defrags must also be done.
4. In addition to defrag, you should verify cluster sizes and paritition alignment of your database volumes. These will also have significant impact on disk performance.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 8, 2009 at 1:47 pm
1. Disk volumes need to be defragged.
2. I prefer PerfectDisk (defraggler seems to work nicely too) - both are faster than Diskeeper, and all three are many times better than the Default Defragger.
3. Disk defrag is separate from Index defrag. Idx defrags must also be done.
4. In addition to defrag, you should verify cluster sizes and paritition alignment of your database volumes. These will also have significant impact on disk performance.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 8, 2009 at 1:48 pm
1. Disk volumes need to be defragged.
2. I prefer PerfectDisk (defraggler seems to work nicely too) - both are faster than Diskeeper, and all three are many times better than the Default Defragger.
3. Disk defrag is separate from Index defrag. Idx defrags must also be done.
4. In addition to defrag, you should verify cluster sizes and paritition alignment of your database volumes. These will also have significant impact on disk performance.
5. I would also recommend shutting down SQL services - but it is not required.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 8, 2009 at 1:53 pm
1. Disk volumes need to be defragged.
2. I prefer PerfectDisk (defraggler seems to work nicely too) - both are faster than Diskeeper, and all three are many times better than the Default Defragger.
3. Disk defrag is separate from Index defrag. Idx defrags must also be done.
4. In addition to defrag, you should verify cluster sizes and paritition alignment of your database volumes. These will also have significant impact on disk performance.
5. I would also recommend shutting down SQL services - but it is not required.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 8, 2009 at 1:59 pm
1. Disk volumes need to be defragged.
2. I prefer PerfectDisk (defraggler seems to work nicely too) - both are faster than Diskeeper, and all three are many times better than the Default Defragger.
3. Disk defrag is separate from Index defrag. Idx defrags must also be done.
4. In addition to defrag, you should verify cluster sizes and paritition alignment of your database volumes. These will also have significant impact on disk performance.
5. I would also recommend shutting down SQL services - but it is not required.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 8, 2009 at 2:00 pm
1. Disk volumes need to be defragged.
2. I prefer PerfectDisk (defraggler seems to work nicely too) - both are faster than Diskeeper, and all three are many times better than the Default Defragger.
3. Disk defrag is separate from Index defrag. Idx defrags must also be done.
4. In addition to defrag, you should verify cluster sizes and paritition alignment of your database volumes. These will also have significant impact on disk performance.
5. I would also recommend shutting down SQL services - but it is not required.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 8, 2009 at 2:00 pm
1. Disk volumes need to be defragged.
2. I prefer PerfectDisk (defraggler seems to work nicely too) - both are faster than Diskeeper, and all three are many times better than the Default Defragger.
3. Disk defrag is separate from Index defrag. Idx defrags must also be done.
4. In addition to defrag, you should verify cluster sizes and paritition alignment of your database volumes. These will also have significant impact on disk performance.
5. I would also recommend shutting down SQL services - but it is not required.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 9 posts - 16 through 23 (of 23 total)
You must be logged in to reply to this topic. Login to reply