Hello there,

I am experiencing performance problems with an aplication running over a SQL
Server 2000 Database. The server that holds SQL Server has 2.8 GB of RAM
memory. When there are just on or two users working, the aplication
performance is suportable, but when more users are using the aplication,
there picks when its almost impossible work normaly.

My question is: what can possible cause this loss of performance?

All workstations have an ODBC connection with 'sa' user. Can it be
important?

What can I do to troubleshoot this problem?

The are serveral important tables with many fields and many records. I think
that I have created indexes correctly.

Can anybody help me? Thanks.

Regards,

Marco Pais

Please don't post independently in separate newsgroups. You can add
multiple newsgroups to the header and then all the answers appear as one.
See my reply in the other newsgroup.


--
Andrew J. Kelly SQL MVP


"Marco Pais" <mpaisIGNORE (AT) foruminformatica (DOT) pt> wrote