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 |
|
rerichards
Starting Member
10 Posts |
 Posted - 2006-01-25 : 21:14:36
|
| I am running SQL 2K enterprise having 8GB RAM, with AWE enabled, using the 3GB/PAE switch in the boot.ini. Fixed memory is set at 6079MB. I returned the following performance counters and was hoping somebody could tell me if thereare any signs of memory bottl enecks. I was curious among other things about the Total and Target memory counter values being the same. I read that if the Total and Target memory were the same that more RAM should be considered. The values specified are in the order of Average, Minimum, and Maximum.Memory: Pages/sec 1, 0, 34Memory: Available MB 1246, 1232, 1266Memory: Page Faults/sec 433, 99, 4252SQL Server Buffer Manager: Buffer Cache Hit Ratio 99.820, 99.805, 99.832SQL Server Buffer Manager: Free Pages 36453, 26288, 37214SQL Server Memory Manager: Memory Grants Pending 0, 0, 0SQL Server Memory Manager: Target Server Memory (KB) 6276405, 6276344, 6276698SQL Server Memory Manager: Total Server Memory (KB) 6276405, 6276344, 6276698 |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-01-25 : 21:55:27
|
| I think the target counter behaves differently when you put the server into AWE mode. THe servers we have that are running with AWE enabled all behave in the same way (in regards to total/target being the same).looking at the other counters, nothing really jumps out at me. Are you having a specific performance problem, or are you just being proactive?-ec |
 |
|
|
rerichards
Starting Member
10 Posts |
Posted - 2006-01-25 : 22:08:11
|
quote:
Originally posted by eyechart
Are you having a specific performance problem, or are you just being proactive?
Yes, I am dealing with some performance issues. An application is having very slow response times. Last week, RAM was increased, AWE enabled, the 3GB/PAE set in boot.ini. This reduced the problem by about 50%, but the performance is still unacceptable.I posted my physical disk counters in a separate email in this forum and am waiting a reply, so I will not duplicate that post.Thanks |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-01-25 : 22:19:54
|
quote:
Originally posted by rerichards
quote:
Originally posted by eyechart
Are you having a specific performance problem, or are you just being proactive?
Yes, I am dealing with some performance issues. An application is having very slow response times. Last week, RAM was increased, AWE enabled, the 3GB/PAE set in boot.ini. This reduced the problem by about 50%, but the performance is still unacceptable.I posted my physical disk counters in a separate email in this forum and am waiting a reply, so I will not duplicate that post.Thanks
have you run any profiler traces?-ec |
|
|
|
rerichards
Starting Member
10 Posts |
Posted - 2006-01-25 : 22:41:01
|
| [quotehave you run any profiler traces?[/quote]I have 2 profiler traces based upon duration and table scans. |
|
|
|
|
|
|
|
|
Memory issue??