poor performance

Hello all,

I recently pick up a SQL-Server Client-Server application system and I saw very poor performance.

for example, if I was doing some join from 3 or 4 tables, our data entry staff can not do anything, the front end VB application would just hang. There are 10 users at maximum logging on the system concurrently.

I am not sql server dba but like to improve it, where should I begin to check? detailed steps are appreciated.

Thanks,

Jane

what version of sql server are you using?

If the VB application hangs, how do you know it's SQL Server that's the problem?

|||

Profiler is the first step.
Identify the long running queries and check out their query plan.

sql