|
|
firechild
regular
Reg'd: Wed
Posts: 30
|
|
I use DBCC Reindex for internal fragmentation, but what about external fragmentation? Over time it seems performance is flying out the window like a witch on a broom and final users start complaining about the delays. It is a great irritation for me! What can I do?
|
|
greysts
regular
Reg'd: Thu
Posts: 17739
Loc: Colchester
|
|
Can you please explain what your post means?
--------------------
Do you know that we're all in line for succession to the throne? Really?
Well, if forty-eight million, two hundred thousand, seven hundred and one people died I'd be Queen.
|
firechild
regular
Reg'd: Wed
Posts: 30
|
|
The re-index will arrange things to speed up the access of files because the "pointers" are organised for quick searches etc. But the files are still in actual fact in fragments so when users want to access files, it still takes too long and the delays in locating the data the users need, is growing. Its one thing to keep doing a reindex, but its not the solution...
|
greysts
regular
Reg'd: Thu
Posts: 17739
Loc: Colchester
|
|
I presume you are referring to a SQL Database on a server in a business environment. This forum is for personal users who do not have the luxury of an iT department or access to an iT professional. I will close this thread.
--------------------
Do you know that we're all in line for succession to the throne? Really?
Well, if forty-eight million, two hundred thousand, seven hundred and one people died I'd be Queen.
|
|
|
Previous
Index
Next
Threaded
Edit
Reply
Quote
