Red Gate forums :: View topic - SQL Server Metrics all zero for one server
Return to www.red-gate.com RSS Feed Available

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

SQL Server Metrics all zero for one server

Search in SQL Monitor 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
BlueBSH



Joined: 28 Sep 2012
Posts: 3

PostPosted: Fri Aug 16, 2013 4:54 pm    Post subject: SQL Server Metrics all zero for one server Reply with quote

I have SQL Monitor 3.5 set up right now to monitor two servers.

The monitor service and website are on a server external to these two servers.

Right now physcal server 1 is logging data fine, all the SQL Server metrics are getting values and graphing great under analysis

When you go to physcal server 2, all the (machine metrics) windows performance logs are there with values, but the sql server metrics are wrong... every one of them is a constant zero except for SQL Server: processor time.. what would cause this? I have two instances on this second physical server, neither of them show anything for these server metrics, but physical server 1 shows them just fine.

(by physical server, I mean a physical hardware server, which is running instances of SQL Server on it) Smile

Under configuration of monitored servers, there is not errors all instances across the two physical servers say "Monitor connected" with a green check mark
Back to top
View user's profile Send private message Send e-mail
Brian Donahue



Joined: 23 Aug 2004
Posts: 6589

PostPosted: Mon Aug 19, 2013 4:15 pm    Post subject: Reply with quote

Hello,

Usually, an absence of data means one of two things: data is not being collected or counter data points are not making it back to the repository for storage.

We can probably tell by the SQL Monitor base monitor log file, if you can send that in reply to our support case (#1471) email.
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