Locks and slow preformance?

Hello
I have one question about locks and slow preformance. I have some
application that connect to database, there i have also some ISAPI
application which connect to SQL. Ockey, when i restart SQL server,
performance is very good, but at the en of week preformance on sql server
fall to mybe 1/5 of time. So if some query take 2 seconds to execute at the
and of week it takes more than 10sec. I try to figure out what coold be
wrong, and i recognize if my locks increse mort than about 60 process (and
there are may sleeping locks) in Locks/Process ID the preformance fall down,
then i also try to kill some proces and aplication runs faster. I have all
default values,
So can somebody explain me why this happend
thanksHi
Ensure that you have suitable indexes for your queries. Run Profiler to see
what queries are being executed.
Run Sp_who2 to see if what is blocking what.
Regards
Mike
"Matej Kavèiè" wrote:

> Hello
> I have one question about locks and slow preformance. I have some
> application that connect to database, there i have also some ISAPI
> application which connect to SQL. Ockey, when i restart SQL server,
> performance is very good, but at the en of week preformance on sql server
> fall to mybe 1/5 of time. So if some query take 2 seconds to execute at th
e
> and of week it takes more than 10sec. I try to figure out what coold be
> wrong, and i recognize if my locks increse mort than about 60 process (and
> there are may sleeping locks) in Locks/Process ID the preformance fall dow
n,
> then i also try to kill some proces and aplication runs faster. I have all
> default values,
> So can somebody explain me why this happend
> thanks
>
>