RAM allocation for the BD - SQL Server Forums

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

General SQL Server Forums

New to SQL Server Programming

RAM allocation for the BD

Author

Topic

andresayala
Starting Member

2 Posts

Posted - 2011-11-01 : 15:53:46

Good day.
I would like to clarify a confusion that I have ..
I have a server charges 6 Gb of RAM on x32 server
and is assigned to SQL Server 3 GB of RAM and still gets slow server could asiganarle 4GB and 2 GB for the Operating System?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-11-01 : 16:20:13

Define "slow server". What are you seeing in SQL Profiler and PerfMon?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

andresayala
Starting Member

2 Posts

Posted - 2011-11-01 : 19:16:56

if the two also. version sql server 9.00.1399.06 RTM Standard Edition

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-11-01 : 20:53:25

Why don't you have service pack 4 installed for SQL Server 2005!? There's have been a few very serious security bugs since the RTM version, plus features added, other bugs fixed, and performance improvements!

What does "if the two also" mean?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources