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.
| Author |
Topic |
|
walidb
Starting Member
4 Posts |
 Posted - 2008-02-24 : 06:55:58
|
| Hi,I have installed two instances for the sql for two different application, and the task manager in Windows is showing that I am using 3.5 GB from the RAM (I have 4 GB RAM on my server).Can sombody tell me the stebs to have monitoring on the RAM and how to have the best performance for SQL 2005.I appreciate your help.Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-02-24 : 08:41:58
|
| You can use SQL server System monitor counters for this purpose. Have a look at Buffer Manager & Memory Manager countershttp://msdn2.microsoft.com/en-us/library/aa905151(SQL.80).aspx |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-02-24 : 11:05:22
|
| If you install 2 instances on 4 GB server , of course you won't get optimal performance. You can find lots of articles about Performance tuning in:www.Sql-server-performance.com |
|
|
|
dewacorp.alliances
452 Posts |
Posted - 2008-02-24 : 16:03:35
|
quote:
Originally posted by walidb
Hi,I have installed two instances for the sql for two different application, and the task manager in Windows is showing that I am using 3.5 GB from the RAM (I have 4 GB RAM on my server).Can sombody tell me the stebs to have monitoring on the RAM and how to have the best performance for SQL 2005.I appreciate your help.Thanks
You mentioned that you have 4Gb but it's only showing 3.5GB. It seems that Windows physical address extension feature (PAE) has not been activated. Have a look on this blog: http://www.dewateam.com/?p=31Thanks. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-25 : 14:41:54
|
| Pae is for memory above 4gb. If server has hot swap memory feature, firmware needs 500mb memory for that. |
|
|
|
|
|
|
Performance In SQL 2005