SQL Server Performance

Slow Performance with SQL2005 Express

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by joecrit, Sep 27, 2006.

  1. joecrit New Member

    I recently upgraded a client that was running MSDE2000 with Microsoft Dynamics Accounting application. They were running into the 2GB database size limitation.

    I upgraded them to SQL2005 Express, and since that they have been complaining about the performance on data entry. (They can type faster than the screen will allow)

    It is my understanding that this may be a memory setting, I also understand I can use the Studio to make adjustments, not sure where I do this or what the seting should be.

    Any help would be appreciated.

    Joe

    Joe Critchlow
    R.L. Nelson
    724-733-4102
  2. kpayne New Member

    Joe,

    It sounds like an application problem if the keystrokes aren't appearing quickly enough.

    Keith Payne
    Technical Marketing Solutions
    www.tms-us.com

Share This Page