Analysis doesn't show SQL Server counters

• 
  Hi,
  
  Apologies for the error.
  
  Would it be possible to use 'Looking back in time' functionality in Overviews and verify whether data is present for that period (time range which you are trying to plot on Analysis page) for the problematic counters on Overviews?
  
  Also, are there any errors on Configuration > Monitored servers page? Are you seeing this issue for any particular SQL Server or all of your SQL Server?
  
  Thanks,
  Priya

  priyasinha December 22, 2010 09:33

  - 0 +
• 
  Hi Priya,
  
  I went to Global Overview and chose the server.
  
  When I scroll down to system processes (top 10), I see it's been collecting data since 12/15/2010. Keep in mind, I can see the Analysis for Machine counters. It's not particular counters, it's all counters under 'SQL Server' and 'Database' . In fact, when I choose Database, it just shows No object selected.
  
  Where exactly do I look for the same counters on the Overview page?
  
  
  I don't see any errors on the Monitored servers page.
  
  Thanks,
  Lori

  lmsparkle December 22, 2010 17:51

  - 0 +
• 
  Hi Lori,
  
  On the left hand navigation, expand and then select the SQL Server. This will then show you 'SQL Server Overview'. You would be able to view all the sql counters on this page e.g. Batch requests/ sec, Page splits/ sec etc.
  
  If it is working as expected then you would also see list of database on this page. Click on the name of any the database and you should be able to view 'Database overview'.
  
  Let us know if you see sparlines here or not? Also, are there any connection errors for these SQL Servers?
  
  Thanks,
  Priya

  priyasinha December 23, 2010 04:50

  - 0 +
• 
  HI,
  
  In the Overviews tab area, I don't see any 'databases' for the Server under 'Global Overview'.
  
  Here is what I do see:
  
  SQL Server Instances
  CPU
  Memory
  Disks
  Network
  Properties
  System Processes (top 10)
  
  I don't see any server errors, and time in the porperties is up-to-date.
  
  What else should I check?
  
  Thanks,
  Lori

  lmsparkle January 04, 2011 15:13

  - 0 +
• 
  Hi,
  
  Thanks for your post. I have emailed you just now for more information. Let me know if you have not received the email yet.
  
  Regards,
  Priya

  priyasinha January 05, 2011 08:34

  - 0 +

Add comment

Please sign in to leave a comment.