Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dreamweaver547
Starting Member
6 Posts |
 Posted - 2010-03-15 : 14:04:47
|
| Hi-I have a five year old laptop (Celeron processor, 1GB RAM, 1.2GHz processor). Technically, this meets the requirements for SQL Server 2005. But I have tested 2005 and 2008 and there is a noticeable degradation in pc performance.However, I'm looking to run something much lighter which consumes a minimal amount of processor and RAM and am considering SQL Server 2000. Are the default settings OK in this or does it need to be adjusted to take it easy on my hardware?Thanks. |
|
|
ray-SQL
Starting Member
18 Posts |
Posted - 2010-03-15 : 15:47:51
|
| I am not sure on the hardware specs, but what is your goal of installing SQL? Is it for self studying? If so, you might be better off to get a newer laptop/desktop ($500?) so you can install 2005 or 2008 and learn the new features. Not a lot of jobs looking for SQL 2000 experiences. Not mentioning the overall boost you will get for everyday computing needs. Otherwise if you need to learn SQL for work, you might talk your boss into letting you install SQL 2008 Express (free) on a workstation.Ray Dai |
 |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2010-03-16 : 03:25:34
|
| You can try to run SQL Server Express but I suspect it will cause the performance to be degraded equally on such a low spec machine. The reason for this is that sql server will by design grab as much RAM as it can and this will naturally cause the rest of your server to slow down if you don't have much to begin with. You can eight-click the server instance in sql server management studio though and try to limit the max amount of memory used by sql server...or you can stop the sql server services when you're not using it...- LumbagoIf the facts don't fit the theory, change the facts. Albert Einstein |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-03-16 : 04:39:24
|
| " You can eight-click the server instance "Now that's just server-instance-abuse !! |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2010-03-16 : 05:20:35
|
Hehe...  - LumbagoIf the facts don't fit the theory, change the facts. Albert Einstein |
|
|
|
|
|
|
Which SQL Server Version?