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 |
|
coolerbob
Aged Yak Warrior
841 Posts |
 Posted - 2008-09-29 : 06:29:54
|
| I have a 64 bit server with 16 gig ram (14 gig for SQL Server), 6 disks on raid 10, temp db on separate raid 1. Four 3.2Ghz processors (But hyper-threading, Dual Core makes it look like 16 etc...)Perf Counter: Memory: Pages/sec Average: 1400Isn't that way too high? Shouldn't it be less than 20 or so?(SQL Buffer Hit Cache Ratio & % Processor Time is good)Also, Physical Disk: % Disk time: 1300 (on the raid 10 with 6 disks)Isn't that way too high? Shouldn't it be less than 50 or so?(Should I be deviding 1300 by 6?) |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-29 : 08:38:25
|
| Do you have 'Lock in memory pages' enabled in 64-bit server? How long did you run Perfmon to take average? |
 |
|
|
coolerbob
Aged Yak Warrior
841 Posts |
Posted - 2008-09-30 : 10:13:27
|
| No, i don't have that enabled. Do you think it is pushing the % disk time up? I ran it for 40 minutes during peak time. |
|
|
|
|
|
|
Perf Counters