Ed Wagner (1/14/2013)
I have read that SQL Server will consume as much memory as you throw at it and want just a little bit more. No matter how much more you give it, it'll always use more. 😀
memory usage not only dependent on how much memory you provide but also other factors too like
•Slow, cheap storage (like SATA hard drives and 1Gb iSCSI)
•Programs that needlessly retrieve too much data
•Databases that don’t have good indexes
•CPUs that can’t build query plans fast enough
--------
-(Thanks for bent ozar here :-D)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)