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.

 All Forums
 Other Forums
 Other Topics
 2 Gig? Or not 2 Gig?

Author  Topic 

SamC
White Water Yakist

3467 Posts

Posted - 2004-08-29 : 22:43:55
I'm ordering a new laptop. I'm wondering if 2 Gig would improve performance much over 1 Gig. It's almost another $800 for the 2nd Gig.

I run IIS and SQL Server on my current laptop. Visual Studio, Dreamweaver MX, Outlook. That's it, all in 1 Gig memory. How can I get a metric that will indicate whether the additional Gig of memory will be worth the dollars?

If the answer is to look at memory paging statistics, how do I pull that up in Windows XP?

Sam

rockmoose
SQL Natt Alfen

3279 Posts

Posted - 2004-08-30 : 01:27:07
I can give You my opinion.
I don't think the extra Gig is worth it on your laptop.
I have 512 Mb, running IIS, SQL, VS, Outlook, and it rarely uses all of the RAM.
If you later are dissatisfied with your 1 GIG, It is easy to purchase and plug in an extra GIG if you want to.

Where I live $800 ~= 200 beers !

Here is a performance thread: [url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=37656[/url]
where my Dull laptop whips some competition

( btw. is this post in any ways related to the "Fix My Laptop topic )

/rockmoose

/* Chaos is the nature of things...Order is a lesser state of chaos */
Go to Top of Page

mohdowais
Sheikh of Yak Knowledge

1456 Posts

Posted - 2004-08-30 : 02:08:43
I would agree with Rockmoose. 1 Gig is aplenty, and the only reason I can imagine you would need 2 gig is if you have more than Virtual Machine running, AND you want to have VS.net running too. Or you are going to use this machine as an application server on the network (hey who knows!). btw, it's pretty easy to exhaust 512MB of memory if you are running Reporting Services on an IIS+SQL machine along with VS.NET.

Here's an easy test to determine how much memory you really need: right-click on your taskbar and select task manager. In the performance tab, see how much Physical memory is available. If this number periodically dips to below 100K, you need more RAM. Also check your paging file size and usage (Commit Charge on the same screen), the limit should be over 1GB and peak lower than 700K. Make sure you check these while you are running your usual heavy combination of applications and been accessing IIS and SQL Server for a few minutes.

OS
Go to Top of Page

SamC
White Water Yakist

3467 Posts

Posted - 2004-08-30 : 08:09:35
Thanks for the comments and BTW, I didn't know about available memory.

BUT, I forgot to mention I'm scheduled to start Reporting Services development in September, so if that's gonna eat memory, let me know.

Also, it isn't so easy to add a 2nd gig. The old wives tale says memory is faster if both sockets are populated. Is this still true? If I buy 1 Gig, I'd buy 2 half-gig simms to save money and improve performance...

Ah'm a-headin out fer the day boys. Gotta go paddlin.

Back tomorry.
Go to Top of Page

mr_mist
Grunnio

1870 Posts

Posted - 2004-08-31 : 03:14:17
I think that memory is only faster across two sockets if the board is a dual channel type.

Two gig sounds like a lot of memory.

-------
Moo. :)
Go to Top of Page

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2004-08-31 : 03:42:02
get the 2 gigs, forget people who say that 1 gig is enough. When can you ever have too much memory?



-ec
Go to Top of Page

rockmoose
SQL Natt Alfen

3279 Posts

Posted - 2004-08-31 : 03:58:23
Get a laptop with 4 GIGS $$$


rockmoose
/* Chaos is the nature of things...Order is a lesser state of chaos */
Go to Top of Page

SamC
White Water Yakist

3467 Posts

Posted - 2004-08-31 : 07:53:09
Thanks guys.

Since seeing the "available memory" on my 1G laptop, I think I'm going to stay at 1G on the new laptop.

Sam
Go to Top of Page

rockmoose
SQL Natt Alfen

3279 Posts

Posted - 2004-08-31 : 07:56:35
Just earned $$$, if you are still content with the 1GIG in the near future,
how about buying a round ?

rockmoose
/* Chaos is the nature of things...Order is a lesser state of chaos */
Go to Top of Page
   

- Advertisement -