[thelist] SQL Sever 2005 on a laptop

[James Conley]

Based on my own highly subjective experience:

When you say "serving pages to itself" - I assume you mean running IIS
on the machine as well?
When you say "development environment" - I assume you are running some
sort of development software - VS.Net perhaps?

IIRC recommended configuration for a full load of SQL Server Developer
2005 including Reporting services is around 1 gig of memory.
Add to that a couple hundred meg for IIS
Add to that a couple hundred meg for VS.Net if that is what you are
running for development.
Add an extra 512Meg for SQL Server 2000 if you plan on running that as
well.

Again - That's what I would do. I'm sure that you can physicall run them
all with as little as 512Meg on the machine with no problem except for
slowness when trying to switch apps, compile, etc.


James c.

-----Original Message-----
From: thelist-bounces at lists.evolt.org
[mailto:thelist-bounces at lists.evolt.org] On Behalf Of Ian Anderson
Sent: Tuesday, March 21, 2006 7:05 PM
To: thelist at lists.evolt.org
Subject: Re: [thelist] SQL Sever 2005 on a laptop

James Conley wrote:
> While I don't know the answer to you question, based on my own 
> personal experience, I would put some more memory on that machine if 
> you plan to run SQL Server on it along with other stuff and especially

> if you plan on running two instances of SQL Server.

I don't know either, but presumably this is a development environment -
do you really think this is likely to be a problem? 1Gb of RAM is pretty
chunky for a machine serving pages to itself, I would have thought...

Given the principle that SQL Server 2000 was designed to run extremely
scalably on a range of hardware configurations, has this design
parameter been discarded with 2005?

Cheers

Ian