Re: Desired capacity

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Keith Kratochvil (sqlguy.back2u_at_comcast.net)
Date: 08/05/04 

Date: Thu, 5 Aug 2004 06:59:42 -0500

How big a vehicle do I need to haul my family around?
That is a difficult question to answer without knowing specifics. So is
your question.

A few things that would help us:
What are the specs of your current machine?
How many users?
How large are your databases?
Where is your bottleneck now? (have you run PerfMon?) 

-- 
Keith
"Don Johnson" <don@gcsagents.com> wrote in message
news:00ec01c47a5c$0ae7cd80$3501280a@phx.gbl...
> Hello!
>
> I am new to SQL Server, so bear with me.
>
> We have a server in our environment which is woefully
> inadequate, and would like to put a new machine in place
> to handle only SQL (another machine will have IIS, another
> for network/mail, etc).
>
> Please give me some opinions on how to identify a good
> spec for this machine - processors, speed, memory, HDD
> configurations (SCSI, ATA, etc), anything else...
>
> Thanks - please reply to the above email address.
>
> Don

Relevant Pages

  • Re: Help with Query
    ... What the @!$% specs for this?? ... > mind and guess that you want to see only those rows whose col_1 groups ... this is not what minimal nettiquette is about. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
  • Re: Access migration to SQL Server
    ... How can we convert MS-Access import specs to SQL Server. ... Regarding reports, must we leave them in Access? ... >> Your main issue will be with the queries as the syntax can be slightly ...
    (microsoft.public.access.conversion)
  • Re: Access migration to SQL Server
    ... How can we convert MS-Access import specs to SQL Server. ... Regarding reports, must we leave them in Access? ... > Your main issue will be with the queries as the syntax can be slightly ...
    (microsoft.public.sqlserver.server)
  • Re: Access migration to SQL Server
    ... How can we convert MS-Access import specs to SQL Server. ... Regarding reports, must we leave them in Access? ... >> Your main issue will be with the queries as the syntax can be slightly ...
    (microsoft.public.sqlserver.server)
  • Re: Access migration to SQL Server
    ... How can we convert MS-Access import specs to SQL Server. ... Regarding reports, must we leave them in Access? ... > Your main issue will be with the queries as the syntax can be slightly ...
    (microsoft.public.access.conversion)