I have the SolidWorks users defrag their desktop/laptops at least once a week and that has a noticable imporvement on performance. So that leads to the question from IT; should they should be defragging the server with EPDM and SQL on it?
Thanks,
Tom
Great question and timing! I just setup a cold storage schema and have moved 320GB of data to the storage device. With all the open space I was thinking of defraggin as well!
Hi Tom and Ryan,
Per the TS team:
From the IT side, it is always good to defrag a disk. Probably won't see much improvement in SQL if SQL is set up to use Simple recovery mode and the server has enough RAM to hold all the MDF files in memory. Will most likely see better disk I/O performance for the Archive folder drive.
Don’t defrag too often though as it could shorten the lifespan of the drives. Maybe once every month or every other week or so depending on usage. We don’t think there will be too much gain on the serverside though.
Hope it helps,
Joy
Hi Joy,
That is great and what was assumed but it's always good to hear it from the best!
Actually I was asking becasue we noticed that SQL keeps taking a lot of space (and then getting slow) on theserver. But if we restart the server every few days that stays in check. So should I be optimizing the SQL database somehow?
Thanks again,
Tom
Hi Tom,
See solution: S-042552
SolidWorks recommends rebuilding the file vault database indexes at least once a month to improve overall performance. In cases of larger databases and more activity - more frequent rebuilds such as once per week may prove beneficial.
The solution contains the PDF with the instructions.
Regards,
Joy
Joy,
Thanks for updating us with the SW rebuild recommendation.This is the first I've heard of this. I assumed WorkGroup was the only SW PDM system that required this action.
Thanks again,
Rob
Hi Tom and Ryan,
Per the TS team:
From the IT side, it is always good to defrag a disk. Probably won't see much improvement in SQL if SQL is set up to use Simple recovery mode and the server has enough RAM to hold all the MDF files in memory. Will most likely see better disk I/O performance for the Archive folder drive.
Don’t defrag too often though as it could shorten the lifespan of the drives. Maybe once every month or every other week or so depending on usage. We don’t think there will be too much gain on the serverside though.
Hope it helps,
Joy