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 |
|
mvanwyk
Yak Posting Veteran
99 Posts |
 Posted - 2009-06-17 : 03:27:03
|
| Hi Guys.I'm running a performance counter on sqlservr.exe process and want to figure out which counter reflects the actual memory usage for this process?I've read on the net that you have to look at "Page File Bytes".Now if i look at "Task Manager" it reports that sqlservr.exe uses 1,430,728 K now that to me looks like 1.4 GBNow looking at the performance counter Page File Bytes it reports 1500573696 which if you do the math it looks like this.1500573696 / 1024 = 1465404 K1465404 / 1024 = 1431.05859375 MB1431.05859375 / 1024 = 1.397518157958984375 GBNow if i restart sqlservr.exe and in the performance counter reads anything below 1GB for example in task manager it reads 67,744 K which to me is about 67 MB the performance counter reads 183083008 bytes and again i do the math.183083008 / 1024 = 178792 K178792 / 1024 = 174.6015625 MB (already something is not working out 100%) why is that?Any point or help would be appreciated. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-06-17 : 03:44:31
|
Are your number about 8 times as high as you expect?
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
mvanwyk
Yak Posting Veteran
99 Posts |
Posted - 2009-06-17 : 05:04:49
|
| Ah nope about 2.5 times bigger.I found the problem i'm reading the wrong performace counter. i have to read the "Working Set" and not the Page File Bytes.Cheers |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-06-17 : 05:06:00
|
Great!Good luck.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
|
|
|
Performance Counter math problem.