Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K 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
- 264 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 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
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Very slow NAV 5.0 with SQL2005
SBN
Member Posts: 26
Hello,
I'am working with Dynamics Nav 5.0 with SQL Server 2005,it's going very slow with a lot of Lock error!!! :-k
For more information about our System:
Hard:
Intel Xeon Quad 2,5GH
6GB RAM
Network 100MB of speed
3 logic partition of HD 400GB
Soft:
Widows server 2003 R2
Our DB has:
Used Space:94,2GB
Reserved Space:104,2GB
Object cache:3,2GB
Thanks in advance
I'am working with Dynamics Nav 5.0 with SQL Server 2005,it's going very slow with a lot of Lock error!!! :-k
For more information about our System:
Hard:
Intel Xeon Quad 2,5GH
6GB RAM
Network 100MB of speed
3 logic partition of HD 400GB
Soft:
Widows server 2003 R2
Our DB has:
Used Space:94,2GB
Reserved Space:104,2GB
Object cache:3,2GB
Thanks in advance
0
Comments
That's problem for such a big database... logic partitions are not good, and only one HDD is not good too...
You need one HDD for Temp table, one for Transaction log and one for NAV DB as minimum... BUT NOT LOGICAL DISC! It must be physical discs...
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
Our sever have 32bits SQL and Windows,and about discs we have 3 physical : one for DB files,the second for LOG file and the third for the OS.
What about this config?
What is true?
Are the HDDs in some RAID?
What about network?
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
Any terminal servers?
http://mibuso.com/blogs/davidmachanick/
For Kine:
1:I'am sorry ,We have realy 3 physical HDs, after a small verification I conclude this.
2:How can I verify that discs are ih the same RAID or not?
3:About network we have 100MB of speed.
For davmac1:
1:We have a licence of 30 users but realy there are only 20 users connected to the DB.
2:About terminal servers ,we have 7 users connected to the server with VPN.
Thank you for Help
Please one by one that I can understand you.
=D>
Based on the vagueness and high level general nature of your questions, I recommend you find some qualified professional who can help your organization.
There are contributors in this forum who specialize in these services who are extrememly competent.
I recommend you engage one of them and ask them for a quote for services.
http://mibuso.com/blogs/davidmachanick/