Been there, done that :-) It turns out I was wrong about the sqlserver2005 performing fine. Executing the statements directly on the sqlserver2005 is slow as well, and it seems to be sorting the data is very slow. Is there any special considerations to be done about tempdb ? Regards Jan S Dahlsgaard Fujitsu DK
________________________________ Fra: [email protected] [mailto:[EMAIL PROTECTED] På vegne af mit Sendt: 14. marts 2007 06:26 Til: [email protected] Emne: RE: [development-axapta] Slow performance with SQLServer2005 Hi Try to rebuild SQL statistiscs. Use Dynamics "long running queries" to determine which plan is used by the SQL server. Regards Michael Troelsen EG Utility A/S _____ From: [email protected] <mailto:development-axapta%40yahoogroups.com> [mailto:[email protected] <mailto:development-axapta%40yahoogroups.com> ] On Behalf Of Dahlsgaard Jan Sent: 12. marts 2007 12:36 To: [email protected] <mailto:development-axapta%40yahoogroups.com> Subject: [development-axapta] Slow performance with SQLServer2005 Hi This weekend we tried installing a sqlserver2005 on a new server, and copied our sqlserver2000 database to this server (using backup/restore). We have been using Axapta 3.0 KR2 for a while, but we now experience very poor performance. Some forms used to open in seconds, now takes several minutes. The tables used on the tested forms have cluster indexes, so this should not be the issue. The sqlserver2005 seems to be running fine, with no performance problems, but accessing data from axapta is extremely slow. Any good ideas as to what is the problem ? Regards Jan S Dahlsgaard Fujitsu DK [Non-text portions of this message have been removed] -- This message has been scanned for viruses and dangerous content by the <http://www.secpoint.com <http://www.secpoint.com> > SecPoint Protector -- This message has been scanned for viruses and dangerous content by the SecPoint Protector for more information please see http://www.secpoint.com <http://www.secpoint.com> [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
