I'm trying to figure out whether its worth defragging a 2GB mssql database. indexs are above 70% fragmented but queries don't appear to be talking too along.

That being said I am having a delay when requesting to play multiple voice files and havent figured out yet if this because of a delay when our software requests the path of the .wav from the Database, or if its down to some other factor

enter image description here

  • 2
    ONLY If index has page_count >1500 then it makes sense to rebuild or reorganize it. For such a small database there would just be few indexes
    – Shanky
    Jul 2, 2018 at 12:59
  • Generally, no: Why Defragmenting Your Indexes Isn’t Helping. Jul 2, 2018 at 13:02
  • 1
    Also, the database may be memory resident if you have adequate memory and not much else on the server. Fragmentation isn't a concern in that case. I suggest you mine the sys.dm_exec_procedure_stats and/or sys.dm_exec_query_stats DMVs to see how long queries are actually running, and perhaps a trace too.
    – Dan Guzman
    Jul 2, 2018 at 13:11
  • Does it take a long time to start playing the file, or does it take along time for the system run the query that gets the file to play? Jul 2, 2018 at 13:32


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Browse other questions tagged or ask your own question.