Requirements 
Author Message
 Requirements
I am looking to move my ISAM database curently running on SCO to MSSQL. i
know the hardware requirements are higher than those of the Unix box, so i'd
like a rough estimate of what i need in a SQL server. my current database is
215MB and we usually has 28 concurrent connections. what should i be looking
for?


Sat, 29 May 2004 06:25:06 GMT
 Requirements

that doesn't sound like you need a beefy server for a 215
mb dbase.

i think your safe with at least a good pentiumIII class
processor, 128mb ram - and ram is so cheap these days - it
wouldn't hurt to bump that up to 256.  

and stick with a good brand name server like compaq, dell,
hp, etc.

hardware wise you could get away with even a good
workstation class box but have an ms server os running on
it.

hope this helps.

ChrisB
MCDBA MCSE
www.MyDBA2000.com

Quote:
>-----Original Message-----
>I am looking to move my ISAM database curently running on
SCO to MSSQL. i
>know the hardware requirements are higher than those of

the Unix box, so i'd
Quote:
>like a rough estimate of what i need in a SQL server. my
current database is
>215MB and we usually has 28 concurrent connections. what
should i be looking
>for?

>.



Tue, 01 Jun 2004 09:32:44 GMT
 Requirements
4 of the 28 will be using it for great plains dynamics
i DO mean 215 Megs, which will probably swell to 330 MB with SQL.
no one is using data mining/analytical software, it will be some data entry
and mostly running precreated reports and queries and running daily EDI. the
EDI are rather large reports and are transmitted by modem or over the
internet.


Quote:

> >I am looking to move my ISAM database curently running on SCO to MSSQL. i
> >know the hardware requirements are higher than those of the Unix box, so
i'd
> >like a rough estimate of what i need in a SQL server. my current database
is
> >215MB and we usually has 28 concurrent connections. what should i be
looking
> >for?

> You have not really given us eough information (are the users Heavy or
> Light? Are they using "Analysis Services" type apps to generate huge
> reports, or are they simply doing data capture work?)

> Having said that, 23 users on a 215 MB (You do mean Meg and not Gig?)
> should usually be dealt with easily by any modern server.

> Feel free to Email me if you have specific questions.

> Neil Boyle
> www.impetus-sql.co.uk
> www.swynk.com/friends/boyle



Sat, 29 May 2004 09:57:43 GMT
 Requirements

Quote:

>4 of the 28 will be using it for great plains dynamics
>i DO mean 215 Megs, which will probably swell to 330 MB with SQL.
>no one is using data mining/analytical software, it will be some data entry
>and mostly running precreated reports and queries and running daily EDI. the
>EDI are rather large reports and are transmitted by modem or over the
>internet.




>> >I am looking to move my ISAM database curently running on SCO to MSSQL. i
>> >know the hardware requirements are higher than those of the Unix box, so
>i'd
>> >like a rough estimate of what i need in a SQL server. my current database
>is
>> >215MB and we usually has 28 concurrent connections. what should i be
>looking
>> >for?

>> You have not really given us eough information (are the users Heavy or
>> Light? Are they using "Analysis Services" type apps to generate huge
>> reports, or are they simply doing data capture work?)

>> Having said that, 23 users on a 215 MB (You do mean Meg and not Gig?)
>> should usually be dealt with easily by any modern server.

>> Feel free to Email me if you have specific questions.

>> Neil Boyle
>> www.impetus-sql.co.uk
>> www.swynk.com/friends/boyle

I'd suggest that even a server with just one gig of RAM could cache
the whole database, assuming you use it for nothing else (I know
_Nothing_ about Great Plains btw) - 2 GIG of RAM might be excessive,
but it' so cheap right now, who cares.

Allocate some funds for a good fast CPU, A Mirrored or Raid 5 disk set
(more for security than performance)  with a  Smartarray controller
and a backup solution. I like having 2 MICs in a server, & they are
not too expensive

I'd suggest that a multi-cpu solution is not really required here,
specially since Micro$oft moved to per-processor licencing.

Neil Boyle
www.impetus-sql.co.uk
www.swynk.com/friends/boyle



Sun, 30 May 2004 03:08:23 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. SQL server requirement for C/S deployment

2. Hardware Requirements

3. Memory requirements

4. Full-Text Storage Requirements

5. The minimum requirement to create cube with AS

6. Requirements for SQL Machine.

7. Estimating Space Requirements for Processing a Cube

8. Hardware requirements for SQL Server

9. Complex data security requirement: User + Computer

10. System requirements

11. replication memory and disk requirements

12. Harware Requirements for Clustering SQL 2000?


 
Powered by phpBB® Forum Software