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 |
|
pcnetnet
Starting Member
7 Posts |
 Posted - 2007-07-15 : 10:11:14
|
| Hi All, I have SQL server 2000 SP4 and windows 2003 R2 and 16GB memory , but In windows Task manager display max 170mb mem usage ??? i use /3GE /PAE in boot.ini , and enable the AWE , so many time display "No more buffers can be stolen" i need restart the server , this problem so trouble , and i try disable the AWE in SQL , In task manager use about 2GB mem usage , but the error also , i need enable the AWE or not ? how to fix the no more buffers ???? THANks ALL |
|
|
b.veenings
Yak Posting Veteran
96 Posts |
Posted - 2007-07-15 : 13:30:53
|
quote:
Originally posted by pcnetnet
Hi All, I have SQL server 2000 SP4 and windows 2003 R2 and 16GB memory , but In windows Task manager display max 170mb mem usage ??? i use /3GE /PAE in boot.ini , and enable the AWE , so many time display "No more buffers can be stolen" i need restart the server , this problem so trouble , and i try disable the AWE in SQL , In task manager use about 2GB mem usage , but the error also , i need enable the AWE or not ? how to fix the no more buffers ???? THANks ALL
it should be /3gb /pae, look at your sqlserver properties what the max is configured for you server and what the minimum is.Need an SQLDB consultant?check www.veeningsengineering.nl |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-15 : 20:47:37
|
| You should look at perfmon. |
|
|
|
pcnetnet
Starting Member
7 Posts |
Posted - 2007-07-15 : 23:24:57
|
| i try use performance monitor , monitor (Buffer cache hit ratio , Active Transactions,Databases(_Total)\Transactions/sec,User Connections,Number of Deadlocks/sec,Memory\Pages/sec,Avg. Disk Queue Length,% Processor Time,) but what data value is normal , what data value is error, how to find ??? Thanks, |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-16 : 22:47:22
|
| Look at target memory and total memory. |
|
|
|
|
|
|
|
|
SQL process display in task 100mb memory ????