Hi,
I have speed problems because my SQL database is at 95%. I have it with Unrestricted Growth and 10% File Growth.
In the Installation manual it says that when the database expands, it will do it by this 10%. But.... do you know when it will trigger this expansion?
Regards,
:bug:
Navision Developer
0
Comments
SQL will trigger it when it needs it, it is impossible to predict it. You can do it manually with File=>Database=>Alter and altering the sizes.
Check the topics for possible reasons of performance problems.
Some examples:
-No good SQL statistics
-No Re-indexing of the tables in SQL
-RAID5
-Etc...
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
RIS Plus, LLC
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
Do not rely on auto-expansion. Watch your file growth and expand manually during off-hours. Auto-expansion is there as a safety net.