Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

What percentage of memory utilization is server bottleneck? Expand / Collapse
Author
Message
Posted Friday, August 8, 2014 3:16 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 3:19 AM
Points: 449, Visits: 882
We are using Virtual machine 32bit OS, created on Windows server 2008 64 bit, and Installed SOL server 2005 32 bit. there is memory (RAM) utilization high as 70% and above. Is this a bottleneck?
What percentage of memory utilization in server is bottleneck?


Ali
MCTS SQL Server2k8
Post #1601080
Posted Friday, August 8, 2014 3:21 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 5:25 AM
Points: 43,024, Visits: 36,185
Wrong question

SQL 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?



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1601084
Posted Friday, August 8, 2014 4:03 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 3:07 PM
Points: 4,356, Visits: 6,189
GilaMonster (8/8/2014)
Wrong question

SQL 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 at GMail
Post #1601099
Posted Today @ 3:26 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 3:19 AM
Points: 449, Visits: 882
GilaMonster (8/8/2014)
Wrong question

SQL 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?


Thank you very much GilaMonster


Ali
MCTS SQL Server2k8
Post #1614770
Posted Today @ 3:27 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 3:19 AM
Points: 449, Visits: 882
thanks to all and TheSQLGuru

Ali
MCTS SQL Server2k8
Post #1614771
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse