GilaMonster (8/8/2014)
Wrong questionSQL will use all the memory that it's allowed to use, up to 100% of what's on the machine. You need to set its limits. If you don't, it will try to use everything.
SQL uses a lot of memory, that's by design and how it's intended to work. Using lots of memory is not a problem.
Why on earth are you using 32 bit?
To add, 32 bit has some peculiarities that make it WAY more likely that memory is or can be an issue with performance. But there are a LOT of things that can cause performance issues on SQL Server. Way more than can be covered in some forum posts.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service