Red Gate forums :: View topic - Anyone Using SQL MOn w/SQL On VMWare/SANS Box with Stats I..
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Monitor 4
SQL Monitor 4 forum

Anyone Using SQL MOn w/SQL On VMWare/SANS Box with Stats I..

Search in SQL Monitor 4 forum
Post new topic   Reply to topic
Jump to:  
Author Message
EdCarden



Joined: 25 Nov 2008
Posts: 90

PostPosted: Wed Jun 11, 2014 4:43 pm    Post subject: Anyone Using SQL MOn w/SQL On VMWare/SANS Box with Stats I.. Reply with quote

NOTE: I am no sysadmin nor am I versed in VMWare so the below may sound like a dumb question...

Anyone Using SQL Monitor w/SQL On VMWare/SANS Box with Stats Issues like SQL Monitor capturing Disk Avg Read/Write times that differ greatly from what the Hardware is showing for the same time period and drive(s)?

I have a formal support request to Read-Gate submitted but I was curious if anyone on the forums uses SQL Mon for a SQL Instance running on a VMWare managed SANS and if so have you had any conflicting stats between SQL Mon and what the Hardware/Servers showing/capturing? SQL Monitor is capturing Avg Disk Read/Write times that differ greatly from what the SANS Hardware’s on monitoring is capturing/showing for the same time frame. I’m talking about a difference of seconds (as captured by SQL Monitor) and milliseconds (as captured by the hardware’s monitoring). For one specific 10 minute period SQL Monitor captured Disk Avg Read times in the 1 to 4 second range while the servers own internal monitoring shows that as never going above 500 milliseconds.
Back to top
View user's profile Send private message
maddave



Joined: 11 Apr 2013
Posts: 19

PostPosted: Thu Jul 03, 2014 10:11 am    Post subject: Reply with quote

I use SQL Monitor to monitor SQL servers running on VM's hosted by VMWare ESX 5.1. I have noticed descrepencies in the stats collected too, such as CPU will be showing as maxed out via Virtual Center, but never going over 80% via SQL monitor.

I took this down to being due to the different ways the two system monitor the server. Namely, SLQ monitor doesn't look all the time, but polls the system.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
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 vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group