Hi Girish,
Thank you for the help. I will check with DB guys about these.
Thank you,
Subbu
Girish B <[EMAIL PROTECTED]> wrote:
Girish B <[EMAIL PROTECTED]> wrote:
Hi Subbu,
There are a few things which you need to check
1. SQL tweaks
a. you could Switch the SQL Priority Boost on if you
are only connected to axapta on that sql server.
b. Use fixed memory - recommended around 750Mb.
c. Reduce the Transaction Log (usually if no settings
are done then you will find that the transaction log
gets bigger than the DB). (since i am not an SQL
expert you can Search Books Online for DBCC
Shrinkfile) it is something like below
DBCC SHRINKFILE
( { file_name | file_id }
{ [ , target_size ]
| [ , { EMPTYFILE | NOTRUNCATE |
TRUNCATEONLY } ]
}
)
2. Double check the way the connection settings are
done i.e which users are connected using 2 tier and
which users 3 tier thin and thick clients. Its
important that you actually get the user connect
remotely and check the performance. We usually tend to
check for performance using the 2 tier connection but
we need to see how it works remotely.
3. you said you had to write codes on
setfocus,lostfocus as you had no choice. are you sure
you tried all the other possibilites?
4. Now if you really dont want to have nightmares as
you go live then get more and more testings done by
the END USERS, which i believe you have already might
have done but it is just my experience and this was
the thing which hit me after i went live with one of
the our clients without the actual users doing much
testing (they usually said they are busy and just did
some basic testings). By end users i mean not just
the people at the manager level but the actual users
(if in production environment then the person who
actually uses this system). This becomes much more
important when many new functionalities are included.
If i remember any more points i will mail you back.
Good luck. Happy implementing.
cheers,
Girish
--- Subrahmanyam Mamidi <[EMAIL PROTECTED]> wrote:
> Hi Arijit,
>
> Thank you for the reply.
> We have
>
> 1. Around as of now 120 users ( may be this would be
> the maximum).
> 2. Connectivity is through Citrix clients. we have
> three Citrix servers for the load balancing and they
> wil be selected by the clients automatically during
> the login time.
> 3. We are located in around 12 locations including
> USA, Germany & UK.
> 4. we have around 84 interfaces, 20 customizations
> and 3 Axapta Localizations with 3 database for each
> localization.
>
> Can you pls share ur exeriences with me?.
>
> Thanks in advance,
> Subbu
>
>
>
>
> Arijit Basu <[EMAIL PROTECTED]> wrote:
> Hi,
> Can you give some more details about the nos of
> users, nos of
> locations, connectivity etc. I may be able to help
> you then.
>
>
> On Tue, 25 Jan 2005 09:17:43 -0800 (PST),
> Subrahmanyam Mamidi
> <[EMAIL PROTECTED]> wrote:
> > Hi,
> >
> > We are approaching live dates pretty quickly. And
> I would like to know some
> > of the performance issues related both Database
> and Axapta.
> >
> > History:
> >
> > We are running Axapta 3.0 SP3 and SQL database 3 -
> tier environment. We have
> > a numerous customizations and interfaces. Hence,
> obviously, there is a
> > tendecy for the system to have a delayed response.
> >
> > Woud like to know :
> >
> > I would like to know your experiences and Ideas on
> what the best we can do
> > for the better performance.
> >
> > 1. DB related ( like, sizing, cluster, etc...)
> >
> > 2. Axapta Code related. Currently, I am following
> the tips and best practice
> > methods suggested in DEV guide. But I have two big
> customizations where it
> > happed to write some modified,
> setfocus,lostfocus()0 methods on the
> > controls. Because I have no other go...
> >
> > 3. General Performance Ideas/Practices
> >
> > Your suggestion are very much valuable to me.
> >
> > Thanking you.
> > SUbbu
> > SDBC
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Tired of spam? Yahoo! Mail has the best spam
> protection around
> > http://mail.yahoo.com
> >
> > Sharing the knowledge on Axapta.
> >
> >
> > ________________________________
> > Yahoo! Groups Links
> > To visit your group on the web, go to:
> >
>
http://groups.yahoo.com/group/Axapta-Knowledge-Village/
> >
> > To unsubscribe from this group, send an email to:
> >
> [EMAIL PROTECTED]
> >
> > Your use of Yahoo! Groups is subject to the Yahoo!
> Terms of Service.
> > ________________________________
> > Yahoo! Groups Links
> > To visit your group on the web, go to:
> >
>
http://groups.yahoo.com/group/Axapta-Knowledge-Village/
> >
> > To unsubscribe from this group, send an email to:
> >
> [EMAIL PROTECTED]
> >
> > Your use of Yahoo! Groups is subject to the Yahoo!
> Terms of Service.
> >
> >
>
>
> --
>
>
> Arijit
>
>
> Sharing the knowledge on Axapta.
>
>
>
> ---------------------------------
> Yahoo! Groups Links
>
> To visit your group on the web, go to:
>
http://groups.yahoo.com/group/Axapta-Knowledge-Village/
>
> To unsubscribe from this group, send an email to:
> [EMAIL PROTECTED]
>
> Your use of Yahoo! Groups is subject to the
> Yahoo! Terms of Service.
>
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam
> protection around
> http://mail.yahoo.com
___________________________________________________________
ALL-NEW Yahoo! Messenger - all new features - even more fun! http://uk.messenger.yahoo.com
Sharing the knowledge on Axapta.
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Sharing the knowledge on Axapta.
| Yahoo! Groups Sponsor | |
|
|
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
