Discussions
Activity
Best Of...
Sign In
·
Register
Home
›
SQL Performance
Howdy, Stranger!
It looks like you're new here. Sign in or register to get started.
Sign In
Register
Quick Links
Categories
Recent Discussions
Activity
Best Of...
Unanswered
Categories
All Categories
73
General
73
Announcements
66.6K
Microsoft Dynamics NAV
18.7K
NAV Three Tier
38.4K
NAV/Navision Classic Client
3.6K
Navision Attain
2.4K
Navision Financials
115
Navision DOS
854
Navision e-Commerce
1K
NAV Tips & Tricks
772
NAV Dutch speaking only
615
NAV Courses, Exams & Certification
2K
Microsoft Dynamics-Other
1.5K
Dynamics AX
305
Dynamics CRM
109
Dynamics GP
10
Dynamics SL
1.5K
Other
993
SQL General
384
SQL Performance
34
SQL Tips & Tricks
34
Design Patterns (General & Best Practices)
Architectural Patterns
10
Design Patterns
5
Implementation Patterns
53
3rd Party Products, Services & Events
1.7K
General
1.1K
General Chat
1.6K
Website
79
Testing
1.2K
Download section
23
How Tos section
260
Feedback
12
NAV TechDays 2013 Sessions
13
NAV TechDays 2012 Sessions
Navision 4.0 SP3 is very slow in one company only
mohsin
Member
Posts:
2
2011-04-09
edited 2011-04-11
in
SQL Performance
i am facing problem in 1 of our company data a database consist of 6 companies of navision, 1 company is facing slowness while opening gl total field in chart of accounts, any solution to the prolem.
0
Comments
Savatage
Member
Posts:
7,142
2011-04-09
If using sql check the sql performance forum here at mibuso.
with the limited information provided it's impossible to answer your question.
we can speculate all day without server or system specs.
Harry Ruiz
http://www.BiloBeauty.com
http://www.autismspeaks.org
0
stryk
Member
Posts:
645
2011-04-10
As Harry suggested, you should search the forum about "
SQL Performance
" and you'll get gazillion of advices and reccomendations!
With NAV 4.0 SP3 there's a high chance that basically the SIFT management is causing trouble; check out this one:
http://dynamicsuser.net/blogs/stryk/archive/2010/05/29/optimizing-sift-and-vsift.aspx
Of course, there are probably many more things to be discussed, but for this you need to provide more background information about your system.
Jörg A. Stryk
(MVP - Dynamics NAV)
NAV/SQL Performance Optimization & Troubleshooting
STRYK System Improvement
The Blog
-
The Book
-
The Tool
0
kriki
Member, Moderator
Posts:
9,112
2011-04-11
[Topic moved from 'Navision Financials' forum to 'SQL Performance' forum]
Regards,Alain Krikilion
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
0
Sign In
or
Register
to comment.
Comments
with the limited information provided it's impossible to answer your question.
we can speculate all day without server or system specs.
http://www.BiloBeauty.com
http://www.autismspeaks.org
With NAV 4.0 SP3 there's a high chance that basically the SIFT management is causing trouble; check out this one:
http://dynamicsuser.net/blogs/stryk/archive/2010/05/29/optimizing-sift-and-vsift.aspx
Of course, there are probably many more things to be discussed, but for this you need to provide more background information about your system.
NAV/SQL Performance Optimization & Troubleshooting
STRYK System Improvement
The Blog - The Book - The Tool
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!