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

New installation https issue

Hello,

I had some problems with an upgrade that added in RS to a default upgrade of sql2k to sql2k5. I then went into RS configuration and recreated everything. I am now able to get onto the site with no problems except when I have it checked to require ssl connections. I get the follow message when I have ssl checked using any of the three options "The request failed with HTTP status 401: Unauthorized." The certificate matches the url I am trying to goto: reports.domain.net. If in iis on the default website I force a redirect to https://reports.domain.net /reports it works fine, but it's not enforceing ssl if a user just types in the url http://reports.domain.net.reports. How can I get it to enforce ssl throughout via the RS configuration? Thanks.

John

John,

We are having the exact same issue. Did you ever resolve this?

Tom

New installation https issue

Hello,

I had some problems with an upgrade that added in RS to a default upgrade of sql2k to sql2k5. I then went into RS configuration and recreated everything. I am now able to get onto the site with no problems except when I have it checked to require ssl connections. I get the follow message when I have ssl checked using any of the three options "The request failed with HTTP status 401: Unauthorized." The certificate matches the url I am trying to goto: reports.domain.net. If in iis on the default website I force a redirect to https://reports.domain.net /reports it works fine, but it's not enforceing ssl if a user just types in the url http://reports.domain.net.reports. How can I get it to enforce ssl throughout via the RS configuration? Thanks.

John

John,

We are having the exact same issue. Did you ever resolve this?

Tom