Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.6K 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
- 296 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
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
sql 2008 vs. 2005
ara3n
Member Posts: 9,256
Hello
I saw a blog a while back on migration from sql 2005 to 2008. Has anybody done any detail test on performance comparisons?
MS has released the compatibility document in August.
https://mbs.microsoft.com/partnersource ... page=false
I saw a blog a while back on migration from sql 2005 to 2008. Has anybody done any detail test on performance comparisons?
MS has released the compatibility document in August.
https://mbs.microsoft.com/partnersource ... page=false
0
Comments
Not really answering your question but...
I was working with a client recently that run 4.00sp3 on Windows 2008 with SQL 2008, they have been running for about 6 weeks and say that it all works fine. But I was involved because they have serious performance issues. They upgraded from Win2003/SQL2005 thinking that 2008/2008 would fix all their problems, which of course it did not.
Keep in mind that the advantages of SQL 2008 were designed for BIG databases, 100 to 1,000 times bigger than what we use in Navision, so I still don't see where 2008 will provide any major benefits to us yet. I would think that 2008 would make better use of CPUs though.