mibuso.com

Microsoft Business Solutions online community
It is currently Mon Sep 01, 2014 9:28 am

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 13 posts ] 
Author Message
 Post subject: SQL Low Performance than Native Database
PostPosted: Mon Oct 10, 2011 7:32 am 
Offline

Joined: Thu Jun 15, 2006 11:16 am
Posts: 6
Location: Delhi
Country: India (in)
Scenario: SQL Database Vs Native Database
------------------------------------------
1. Currently I am using SQL database for one of my client and not able to run adjust cost on daily basis in 6 Hrs.

Task already done for SQL performance improvement
Quad Core Processor(64 Bit)
52 GB RAM
SQL Database is already divided into 10 Disk with RAID proper configurations.
Maintenance Plan run on regular basis including index maintenance

2. For month closing I need to take backup of system and restore in native database.
I don't don't want to do this activity again.

My requirement is make SQL performance up to Native database performance.

Friends pls suggest me the best feasible way out to improve SQL performance considering above scenarios.

Database figures:
GL - 10020561
ILE- 1631169
VLE- 6873680
3 Months Transactions

_________________
KRISHNA PAL SINGHMS-Dynamics -NAVISION


Top
 Profile E-mail  
 
 Post subject: Re: SQL Low Performance than Native Database
PostPosted: Mon Oct 10, 2011 12:05 pm 
Offline
MVP Microsoft Dynamics NAV
NAV TechDays 2014 attendee

Joined: Thu Jul 31, 2003 12:00 pm
Posts: 640
Location: Nürnberg
Country: Germany (de)
I highly recommend to search MIBUSO (specifically) and the WWWeb (generally) about "NAV SQL Performance". This is actually a persistent topic which is permanently discussed - I'm sure you'll find gazillions of valuable advices!

_________________
Jörg A. Stryk (MVP - Dynamics NAV)
NAV/SQL Performance Optimization & Troubleshooting
STRYK System Improvement
The Blog - The Book - The Tool


Top
 Profile E-mail WWW  
 
 Post subject: Re: SQL Low Performance than Native Database
PostPosted: Mon Oct 10, 2011 12:13 pm 
Online
Moderator
MVP Microsoft Dynamics NAV
NAV TechDays 2014 attendee

Joined: Wed Jul 02, 2003 10:13 am
Posts: 7689
Location: Milan
Country: Italy (it)
[Topic moved from 'NAV/Navision Classic Client' forum to 'SQL Performance' forum]

_________________
Regards,Alain Krikilion
Use the SEARCH,Luke! || No PM,please use the forum. || May the <SOLVED>-attribute be in your title! || Read Forum Rules before making a posting

»»» Mark your calendar: NAV TechDays 2014 - 20 & 21 November 2014 ««« Visit the conference website: http://www.navtechdays.com


Top
 Profile  
 
 Post subject: Re: SQL Low Performance than Native Database
PostPosted: Mon Oct 10, 2011 12:14 pm 
Offline
MVP Microsoft Dynamics NAV
NAV TechDays 2014 attendee

Joined: Tue Jul 19, 2005 4:49 pm
Posts: 4179
Location: Olst
Country: Netherlands (nl)
SQL Server wil probably never,ever outperform Native as it comes to posting documents.

_________________
Mark Brummel | Freelance Dynamics NAV (Navision) Specialist

Author of the book : Microsoft Dynamics NAV Application Design

MY BLOG : http://markbrummel.wordpress.com


Top
 Profile E-mail WWW  
 
 Post subject: Re: SQL Low Performance than Native Database
PostPosted: Mon Oct 10, 2011 1:00 pm 
Online
Moderator
MVP Microsoft Dynamics NAV
NAV TechDays 2014 attendee

Joined: Wed Jul 02, 2003 10:13 am
Posts: 7689
Location: Milan
Country: Italy (it)
Mark Brummel wrote:
SQL Server wil probably never,ever outperform Native as it comes to posting documents.

But with everything optimized, SQL server can get very close.

_________________
Regards,Alain Krikilion
Use the SEARCH,Luke! || No PM,please use the forum. || May the <SOLVED>-attribute be in your title! || Read Forum Rules before making a posting

»»» Mark your calendar: NAV TechDays 2014 - 20 & 21 November 2014 ««« Visit the conference website: http://www.navtechdays.com


Top
 Profile  
 
 Post subject: Re: SQL Low Performance than Native Database
PostPosted: Mon Oct 10, 2011 2:43 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Tue Aug 14, 2001 7:01 am
Posts: 5349
Location: Prague
Country: Czech Republic (cz)
kriki wrote:
Mark Brummel wrote:
SQL Server wil probably never,ever outperform Native as it comes to posting documents.

But with everything optimized, SQL server can get very close.


But that is not what Mark said. 8)

_________________
David Singleton
Dynamics NAV Freelancer
Dynamics Book
Go-Live International


Top
 Profile E-mail WWW  
 
 Post subject: Re: SQL Low Performance than Native Database
PostPosted: Mon Oct 10, 2011 4:18 pm 
Online
Moderator
MVP Microsoft Dynamics NAV
NAV TechDays 2014 attendee

Joined: Wed Jul 02, 2003 10:13 am
Posts: 7689
Location: Milan
Country: Italy (it)
David Singleton wrote:
kriki wrote:
Mark Brummel wrote:
SQL Server wil probably never,ever outperform Native as it comes to posting documents.

But with everything optimized, SQL server can get very close.


But that is not what Mark said. 8)

Mark said that native will always post documents faster than SQL. (at least that is what I understood). And I wrote that posting documents on SQL can get close to the speed of native if it is (heavily) optimized to post documents.

_________________
Regards,Alain Krikilion
Use the SEARCH,Luke! || No PM,please use the forum. || May the <SOLVED>-attribute be in your title! || Read Forum Rules before making a posting

»»» Mark your calendar: NAV TechDays 2014 - 20 & 21 November 2014 ««« Visit the conference website: http://www.navtechdays.com


Top
 Profile  
 
 Post subject: Re: SQL Low Performance than Native Database
PostPosted: Mon Oct 10, 2011 10:12 pm 
Offline

Joined: Fri Aug 06, 2004 9:30 pm
Posts: 1053
Location: Richardson
Country: United States (us)
What version of Navision are you running?
There are different optimizations for each version - generally better each new release

_________________
David Machanick
http://mibuso.com/blogs/davidmachanick/


Top
 Profile  
 
 Post subject: Re: SQL Low Performance than Native Database
PostPosted: Mon Mar 05, 2012 2:39 pm 
Offline

Joined: Tue Oct 04, 2011 10:26 am
Posts: 94
Country: Belgium (be)
Being an SQL wizard myself I can probably give another avenue.
Indexes, when migrating the native database to sql server every key in native is translated to an index in SQL server [-X, while this helps performance in the native to many indexes slow SQL Server's performance.

It is like having a book with an index at the back, and then an index on each page for that individual page.

Check what indexes and keys you really need in the SQL database.

In a last statement relational databases like SQL Server can easilly outperform native, but they need to be configured correctly.


Top
 Profile E-mail  
 
 Post subject: Re: SQL Low Performance than Native Database
PostPosted: Mon Mar 05, 2012 5:01 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Thu Jan 02, 2003 6:37 pm
Posts: 7990
Location: Howell, MI
Country: United States (us)
Resender wrote:
SQL Server can easilly outperform native, but they need to be configured correctly.

No, not true, misleading at best. There is no such thing as an "easy configuration" that will make NAV on SQL Server outperform the native DBMS. Index tuning is just part of a potential solution, and that requires a development effort, so you can't call that configuration.

_________________
Daniel Rimmelzwaan
MVP - Dynamics NAV


Top
 Profile  
 
 Post subject: Re: SQL Low Performance than Native Database
PostPosted: Mon Mar 05, 2012 5:14 pm 
Offline

Joined: Tue Oct 04, 2011 10:26 am
Posts: 94
Country: Belgium (be)
I've seen an SQL database turn over data out of a database thats more complex and larger then the one in our navision faster.

I find the native to be clumbersome and prone to more mistakes.
The native might be more suited for Navision/Dynamics itself but if you want to export that data to 3th party tools or a website SQL beats native


Top
 Profile E-mail  
 
 Post subject: Re: SQL Low Performance than Native Database
PostPosted: Mon Mar 05, 2012 5:58 pm 
Offline
MVP Microsoft Dynamics NAV
NAV TechDays 2014 attendee

Joined: Tue Jul 19, 2005 4:49 pm
Posts: 4179
Location: Olst
Country: Netherlands (nl)
You're high jacking an old post. This should be discussed somewhere else.

_________________
Mark Brummel | Freelance Dynamics NAV (Navision) Specialist

Author of the book : Microsoft Dynamics NAV Application Design

MY BLOG : http://markbrummel.wordpress.com


Top
 Profile E-mail WWW  
 
 Post subject: Re: SQL Low Performance than Native Database
PostPosted: Mon Mar 05, 2012 8:18 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Tue Aug 14, 2001 7:01 am
Posts: 5349
Location: Prague
Country: Czech Republic (cz)
Resender wrote:
I've seen an SQL database turn over data out of a database thats more complex and larger then the one in our navision faster.


I have seen Ferraris that go faster than Volkswagens, but that has as much relevance to this thread as your comment.

_________________
David Singleton
Dynamics NAV Freelancer
Dynamics Book
Go-Live International


Top
 Profile E-mail WWW  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 13 posts ] 

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: