SQL Monitor - Indexes

• 
  Same issue with all on prem servers

  msmit November 29, 2023 01:48

  - 0 +
• 
  Hi, just to confirm, you are looking at overview and clicking into a database. Once you do that you click the Index tab, and nothing shows? It should look like this. 
  
  
  
  
  If the database does not have any indexes, the screen will be blank (example below):
  
  
  Can you confirm that the database you are viewing is expected to have indexes? 
  

  JoshH November 29, 2023 21:03

  - 0 +
• 
  Hi, on my main production instance I currently have 26,817 indexes across all databases. and i get ZERO back in Red-Gate Monitor.
  
  I click on my main prod server from the Overview, then click Indexes and i see nothing.
  
  
  

  IanKeogh November 29, 2023 21:14

  - 0 +
• 
  Ian, I think this will require some troubleshooting on my part. I'll reply to you in our ticket 302808. 
  

  JoshH November 29, 2023 22:20

  - 0 +
• 
  Nothing gets recorded under the various index tables in the actual sql-monitor database, so that points to config issue?

  msmit November 29, 2023 22:24

  - 0 +
• 
  I have the same issue...with some (not all) SQL instances.  I opened a ticket for it (302907).

  TheRealAndy November 30, 2023 14:43

  - 0 +
• 
  is there an update on the issue? I have similar showing on Index page

  amitabh June 12, 2024 14:59

  - 0 +
• 
  @ 2 player games I also encountered the same situation.
  

  PaulIsaac July 01, 2024 08:11

  - 0 +
• 
  Although there was endless support from Redgate, we opted to not use that feature and waste time. Actually we are still on 13.0.42.28300 , but hoping that an upgrade to 14 would change things. We ended up disabling user permissions checks (this was overloading our load balanced DC controllers and causing high CPU) and also simply disabled the index feature (system environment variable SQLMONITOR_Indexes=0). All is fine, excellent product even without those features.

  msmit July 01, 2024 23:34

  - 0 +

Add comment

Please sign in to leave a comment.