Original User: Jamal432@gmail.com
Increasing the performance of enterprise geodatabase (*.mdf),
I have an *.mdf geodatabase which gets really slow when one of layer (stored in it) is accessed. The mdf size is about 4GB while the ldf size is 15GB.
[ATTACH=CONFIG]32022[/ATTACH]
13 versions are permanently linked to this enterprise geodatabase
[ATTACH=CONFIG]32023[/ATTACH]
To increase the performance, I have created a new mdf geodatabse and copied and pasted all the data from the old mdf to it. Then as I access the layers from the new mdf geodatabase, the performance increased dramatically (the versions had to be built again).
I???m sure that this is not the correct approach to increase the performance of an existing mdf geodatabase. What I???m looking for is some tools in the ArcGIS\SQL server that can improve the performance. The documents encourage to apply the ???compress geodatabase??? tool to increase the performance.
[ATTACH=CONFIG]32024[/ATTACH]
What other tools\recommendation might help to enhance the performance dramatically?
Thank you
Best
Jamal
Increasing the performance of enterprise geodatabase (*.mdf),
I have an *.mdf geodatabase which gets really slow when one of layer (stored in it) is accessed. The mdf size is about 4GB while the ldf size is 15GB.
[ATTACH=CONFIG]32022[/ATTACH]
13 versions are permanently linked to this enterprise geodatabase
[ATTACH=CONFIG]32023[/ATTACH]
To increase the performance, I have created a new mdf geodatabse and copied and pasted all the data from the old mdf to it. Then as I access the layers from the new mdf geodatabase, the performance increased dramatically (the versions had to be built again).
I???m sure that this is not the correct approach to increase the performance of an existing mdf geodatabase. What I???m looking for is some tools in the ArcGIS\SQL server that can improve the performance. The documents encourage to apply the ???compress geodatabase??? tool to increase the performance.
[ATTACH=CONFIG]32024[/ATTACH]
What other tools\recommendation might help to enhance the performance dramatically?
Thank you
Best
Jamal
Jamal,
There could be several suggestions for you:
1. Shrink the database.
in SQL Server management Studio-->R-Click on the database-->Tasks--> Shrink
Shrinking the Transaction Log:
http://technet.microsoft.com/en-us/library/ms178037(v=sql.105).aspx
2. rebuild indexes
http://support.esri.com/cn/knowledgebase/techarticles/detail/24518 (the link is valid for new SQL Server versions as well)
3. Reconcile/Post all versions and compress to state 0
Give these a try and check whether this helps!