New Server...

We are running an Enterprise CRM (SalesLogix) on SQL2K
SP3a.
The server we have is a Quad Xeon 500MHz, 4GB RAM.
We currently have 192 users that connect at any given
time, but usually no more than 70-80 at a time.
The perfomance has gradually been getting worse the last
few months and the usage has increased by about 30% since
then as well.
Would upgrading to a quad 1.5GHz Xeon with 4GB RAM
increase performance quite a bit?"Don" <donolwert@.hotmail.com> wrote in message
news:000b01c35c34$ee45c330$a401280a@.phx.gbl...
> We are running an Enterprise CRM (SalesLogix) on SQL2K
> SP3a.
> The server we have is a Quad Xeon 500MHz, 4GB RAM.
> We currently have 192 users that connect at any given
> time, but usually no more than 70-80 at a time.
> The perfomance has gradually been getting worse the last
> few months and the usage has increased by about 30% since
> then as well.
It may be time to rebuild the indices and update the statistics... In
addition, you may want to consider running the Index Tuning Wizard to
determine if performance would benefit by a few carefully placed index's.
> Would upgrading to a quad 1.5GHz Xeon with 4GB RAM
> increase performance quite a bit?
Where is the bottleneck? Is it processor? Is it disk? Some performance
monitor statistics would help answer those questions. I'd start with my
previous suggestions...
Steve|||> It is Processor performance. I haven't noticed any
> bottlenecks and there is 30GB of free space left. The DB
> is 9GB.
Free disk space doesn't indicate that processor performance is poor.
If there are no bottlenecks... then faster processors won't help.
If you are unwilling to try suggestions, and aren't willing to find
bottlenecks, try this:
1. Go out and buy the processors
2. Get fired because performance didn't improve
3. Let someone else have a go at it.
-har|||Sorry for the lack of clarification. Basically what I am
needing are suggestions on how to check for bottlenecks.
Thanks.
Don
>--Original Message--
>> It is Processor performance. I haven't noticed any
>> bottlenecks and there is 30GB of free space left. The
DB
>> is 9GB.
>Free disk space doesn't indicate that processor
performance is poor.
>If there are no bottlenecks... then faster processors
won't help.
>If you are unwilling to try suggestions, and aren't
willing to find
>bottlenecks, try this:
>1. Go out and buy the processors
>2. Get fired because performance didn't improve
>3. Let someone else have a go at it.
>-har
>
>
>.
>|||>--Original Message--
>"Don" <donolwert@.hotmail.com> wrote in message
>news:000b01c35c34$ee45c330$a401280a@.phx.gbl...
>> We are running an Enterprise CRM (SalesLogix) on SQL2K
>> SP3a.
>> The server we have is a Quad Xeon 500MHz, 4GB RAM.
>> We currently have 192 users that connect at any given
>> time, but usually no more than 70-80 at a time.
>> The perfomance has gradually been getting worse the last
>> few months and the usage has increased by about 30%
since
>> then as well.
>It may be time to rebuild the indices and update the
statistics... In
>addition, you may want to consider running the Index
Tuning Wizard to
>determine if performance would benefit by a few carefully
placed index's.
>> Would upgrading to a quad 1.5GHz Xeon with 4GB RAM
>> increase performance quite a bit?
>Where is the bottleneck? Is it processor? Is it disk?
Some performance
>monitor statistics would help answer those questions. I'd
start with my
>previous suggestions...
>Steve
It is Processor performance. I haven't noticed any
bottlenecks and there is 30GB of free space left. The DB
is 9GB.
>
>.
>sql