KiwiMonitor.com

Kiwi tools support Forum
It is currently Fri Aug 17, 2018 3:20 am

All times are UTC




Post new topic Reply to topic  [ 4 posts ] 
Author Message
PostPosted: Wed Nov 11, 2015 3:00 am 
Offline

Joined: Wed Nov 11, 2015 2:16 am
Posts: 2
I am monitoring MS SQL server process and trying to trigger a script on "This app: memory load is above XX MB" but the trigger is not working when the memory is higher than 2GB.

I notice that when memory reach 2048Mb or more, the value on the label "Current Memory Usage" turns to any negative integer value.

Please help me,

Thank you


Attachments:
Screen Shot 2015-11-10 at 6.20.36 PM.png
Screen Shot 2015-11-10 at 6.20.36 PM.png [ 223.18 KiB | Viewed 22140 times ]
Screen Shot 2015-11-10 at 6.56.25 PM.png
Screen Shot 2015-11-10 at 6.56.25 PM.png [ 233.56 KiB | Viewed 22142 times ]
Screen Shot 2015-11-10 at 6.21.11 PM.png
Screen Shot 2015-11-10 at 6.21.11 PM.png [ 242.5 KiB | Viewed 22142 times ]
Top
 Profile  
 
PostPosted: Wed Nov 11, 2015 1:11 pm 
Offline
Site Admin
User avatar

Joined: Mon Jan 16, 2012 11:35 am
Posts: 109
Strange behavior. Kiwi uses numbers provided by Windows itself and this never happened before.
However, I included an absolute function to filter those negative numbers out. Sending you the new executable so you can test it (attached)


Attachments:
Kiwi Application Monitor.zip [923.91 KiB]
Downloaded 1385 times
Top
 Profile  
 
PostPosted: Thu Nov 12, 2015 6:09 pm 
Offline

Joined: Wed Nov 11, 2015 2:16 am
Posts: 2
Now it shows the Absolute value. But the value on this case does not make any sence for my trigger.

More Details:
sqlserv.exe has a memory limit to 4Gb (According to SQL Server )

And I leave an image with the zipped version running and the OS details.

I am giving to you more details about this behavior. If you need more, please let me know.

For now I have the trigger looking on "Computer Memory Load Above XX" and is working according my nescesities.

Thank you.


Attachments:
KW_TEST_SQL_DET.png
KW_TEST_SQL_DET.png [ 35.74 KiB | Viewed 22132 times ]
KW_TEST_DET.png
KW_TEST_DET.png [ 154.34 KiB | Viewed 22132 times ]
Top
 Profile  
 
PostPosted: Fri Nov 13, 2015 1:34 pm 
Offline
Site Admin
User avatar

Joined: Mon Jan 16, 2012 11:35 am
Posts: 109
I'm glad it works for you now.

Regarding negative numbers i've found: "Negative values can appear if the page file has grown at some point in the past, and has since shrunk. SQL Server uses lots of memory and pages a lot, so this type of behavior is pretty common for SQL Server."


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 4 posts ] 

All times are UTC


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group