Hi
Another thing to note is if you are running benchmarks then please run the
benchmarks in multi-user environment. SQL Server 2005 is much better than
'2000' in handling multi-user environment. (After all your live system works
multi-user)
You will get 100% advantage once you upgrade to 4.0+ version since concurrency
has even been introduced in the AX application.
Regards
Harry
This posting is provided "AS IS" with no warranties, and confers no
rights. Use of included script samples are subject to the terms
specified at http://www.microsoft.com/info/cpyright.htm";
The code provided (if any) may be written from the point of view of a
third party and the programming style/development standards may suit
such a point of view.
From: Harry Deshpande
Sent: Tuesday, December 18, 2007 11:15 AM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: RE: [Axapta-Knowledge-Village] Axapta slower on SQL Server 2005 then
SQL Server 2000?
Hi
As per my experience SQL Server 2005 performance is much better than '2000'.
1. Please check whether the SQL Server setup is in line with Microsoft
recommendations.
2. Go further and check things like disc-alignment. Take a look at
http://sqlblogcasts.com/blogs/christian/archive/2007/10/09/disk-sector-alignment.aspx
3. SQL Server 2005 engine is heavily optimized towards cluster indexes.
You will see a lot of cluster indexes introduced from V4.0 onwards. Please
back-port them. However, please note that there is a small chance that the
cluster indexes for some tables in standard Ax may not be appropriate with your
data usage pattern. In this case you will have to figure out the best fit
cluster index yourself.
4. Last but not the least make sure you are running the database with
compatibility mode 90. (It is easy to forget this).
I must say I am a very happy camper since I started using SQL Server 2005.
Regards
Harry
This posting is provided "AS IS" with no warranties, and confers no
rights. Use of included script samples are subject to the terms
specified at http://www.microsoft.com/info/cpyright.htm";
The code provided (if any) may be written from the point of view of a
third party and the programming style/development standards may suit
such a point of view.
From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On
Behalf Of Steeve Gilbert
Sent: Tuesday, December 18, 2007 10:51 AM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Axapta slower on SQL Server 2005 then SQL
Server 2000?
I read a couple of post here and there about Axapta being slower on SQL
Server 2005 then 2000. I thought that people that have problem post
messages and those who don't stays quiet. That's why I was only seeing
post about SQL 2005 being slower. But then I stubble on a post on MBS
forum
(http://www.microsoft.com/Businesssolutions/Community/Newsgroups/dgbrows
er/en-us/default.mspx?
query=sql+2005&dg=microsoft.public.axapta.database&cat=&lang=en&cr=US&pt
=&catlist=8d3f188d-a0E9-40e4-86e2-
46508a35c759&dglist=&ptlist=&exp=&sloc=en-us). And the quote is :
"First of all Ax database runing on same hardware with SQL2005 is ~20%
slower than SQL200 database (tested)."
I can't find something clearer that this. So, does my friends of the
Axapta Knowledge Village acknowledge this statement?
I'm gonna test this in our dev environment and if it turns out true,
then it's gonna be the end of our SQL Server 2005 migration I guess.
Btw, we are staying at Ax3.0 SP3 even if we migrate to SQL 2005.
[Non-text portions of this message have been removed]
