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

Windows 2003 Advanced Server
SQL Server 2K sp3a
There was an existing reporting services database on the SQL Server
Instance. Tried to perform an new install of Reporting Services and point to
this existing database, ReportServer DB. Installation was successful.
However, RS would not activate becuase it thought I was adding to a WEB Farm.
To acivate I needed to run rsactivate from the active RS Server, there was
none. Decided to remove the databases and RS and start clean. Now, everytime
I try to install RS its trying to point to a database that does not exist and
the installation fails. Can anyone help?
ThanksWhat do you mean it tries to point to a DB that doesn't exist? During setup
you can specify a DB that does not exist, it should then create that DB.
What error are you getting?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"FredG" <FredG@.discussions.microsoft.com> wrote in message
news:4C8C08D6-59AE-4F08-8EF4-B9D64C7B9A58@.microsoft.com...
> Windows 2003 Advanced Server
> SQL Server 2K sp3a
> There was an existing reporting services database on the SQL Server
> Instance. Tried to perform an new install of Reporting Services and point
> to
> this existing database, ReportServer DB. Installation was successful.
> However, RS would not activate becuase it thought I was adding to a WEB
> Farm.
> To acivate I needed to run rsactivate from the active RS Server, there was
> none. Decided to remove the databases and RS and start clean. Now,
> everytime
> I try to install RS its trying to point to a database that does not exist
> and
> the installation fails. Can anyone help?
> Thanks|||I know its suppose to create the database if it does not exist. The error is
"Database ReportServer does not exist".
"Daniel Reib [MSFT]" wrote:
> What do you mean it tries to point to a DB that doesn't exist? During setup
> you can specify a DB that does not exist, it should then create that DB.
> What error are you getting?
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "FredG" <FredG@.discussions.microsoft.com> wrote in message
> news:4C8C08D6-59AE-4F08-8EF4-B9D64C7B9A58@.microsoft.com...
> > Windows 2003 Advanced Server
> > SQL Server 2K sp3a
> >
> > There was an existing reporting services database on the SQL Server
> > Instance. Tried to perform an new install of Reporting Services and point
> > to
> > this existing database, ReportServer DB. Installation was successful.
> > However, RS would not activate becuase it thought I was adding to a WEB
> > Farm.
> > To acivate I needed to run rsactivate from the active RS Server, there was
> > none. Decided to remove the databases and RS and start clean. Now,
> > everytime
> > I try to install RS its trying to point to a database that does not exist
> > and
> > the installation fails. Can anyone help?
> >
> > Thanks
>
>|||At what point in setup do you get this? Have you tried changing the DB
name?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"FredG" <FredG@.discussions.microsoft.com> wrote in message
news:A8598F84-FDBF-49E5-BB2B-24CFA774A7C7@.microsoft.com...
>I know its suppose to create the database if it does not exist. The error
>is
> "Database ReportServer does not exist".
> "Daniel Reib [MSFT]" wrote:
>> What do you mean it tries to point to a DB that doesn't exist? During
>> setup
>> you can specify a DB that does not exist, it should then create that DB.
>> What error are you getting?
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "FredG" <FredG@.discussions.microsoft.com> wrote in message
>> news:4C8C08D6-59AE-4F08-8EF4-B9D64C7B9A58@.microsoft.com...
>> > Windows 2003 Advanced Server
>> > SQL Server 2K sp3a
>> >
>> > There was an existing reporting services database on the SQL Server
>> > Instance. Tried to perform an new install of Reporting Services and
>> > point
>> > to
>> > this existing database, ReportServer DB. Installation was successful.
>> > However, RS would not activate becuase it thought I was adding to a WEB
>> > Farm.
>> > To acivate I needed to run rsactivate from the active RS Server, there
>> > was
>> > none. Decided to remove the databases and RS and start clean. Now,
>> > everytime
>> > I try to install RS its trying to point to a database that does not
>> > exist
>> > and
>> > the installation fails. Can anyone help?
>> >
>> > Thanks
>>|||Hello Daniel,
After I have completed all the setup questions then selected next. The
installation was running fine then it bombed out with that message. I was
able to track down the log file located in the C:\Progam Files\Microsoft SQL
Server\80\RS Setup Bootstrap\Log directory. I noticed that the account RS
setup was trying to use to create the database was DOMAIN\SERVER_NAME$, (I
believe this occured becuase I was running the Windows service under NT
AUTHORITY\NETWORK SERVICE). Once I added this account to SQL server and
granted CREATE DATABASE it worked fine. I have done other installs of RS and
never ran into this problem.
Thanks
"Daniel Reib [MSFT]" wrote:
> At what point in setup do you get this? Have you tried changing the DB
> name?
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "FredG" <FredG@.discussions.microsoft.com> wrote in message
> news:A8598F84-FDBF-49E5-BB2B-24CFA774A7C7@.microsoft.com...
> >I know its suppose to create the database if it does not exist. The error
> >is
> > "Database ReportServer does not exist".
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> >> What do you mean it tries to point to a DB that doesn't exist? During
> >> setup
> >> you can specify a DB that does not exist, it should then create that DB.
> >> What error are you getting?
> >>
> >> --
> >> -Daniel
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "FredG" <FredG@.discussions.microsoft.com> wrote in message
> >> news:4C8C08D6-59AE-4F08-8EF4-B9D64C7B9A58@.microsoft.com...
> >> > Windows 2003 Advanced Server
> >> > SQL Server 2K sp3a
> >> >
> >> > There was an existing reporting services database on the SQL Server
> >> > Instance. Tried to perform an new install of Reporting Services and
> >> > point
> >> > to
> >> > this existing database, ReportServer DB. Installation was successful.
> >> > However, RS would not activate becuase it thought I was adding to a WEB
> >> > Farm.
> >> > To acivate I needed to run rsactivate from the active RS Server, there
> >> > was
> >> > none. Decided to remove the databases and RS and start clean. Now,
> >> > everytime
> >> > I try to install RS its trying to point to a database that does not
> >> > exist
> >> > and
> >> > the installation fails. Can anyone help?
> >> >
> >> > Thanks
> >>
> >>
> >>
>
>