SQL Server Connection Status critical
I added SQL server to Logic Monitor. All properties are correct. I have SQL Server Connection Status critical error: Database connection returned an error of 1.0 on ...... Value 1 : General/Unknown error. I also have SQL Server Troubleshooter with this message: MSSQLSERVER error: Read timed out ClientConnectionId: ..... SQL related data sources are not getting any data for monitoring. WMI permissions are correct. SQL permissions seem to be correct too. I am not sure what is the Read timed out message related to. Any ideas how to troubleshoot this issue?38Views4likes6CommentsSQL Server Connection Status critical alert
One of the servers added to Logic Monitor has a SQL Server Connection Status critical alert. SQL Server troubleshooter saying it's Read timed out related. How do i troubleshoot this? Permissions are correct, I can connect to SSMS on that server, proper ports are open. Would IPv6 be an obstacle in this case? Meaning jdbc connection string in properties would have to be changed?34Views1like6CommentsUIv4 instances when there are none?
Perhaps I just wasn't paying attention previously, but does the new UI show everything has an instance even when it's not a multi-instance DataSource now? Is that a recent change? It automatically jumps to the "instance" when you click on the DataSource entry so not really causing an issue but kinda threw me for a loop when I thought a DataSource I was working on was somehow creating instances when it shouldn't. Seems kinda odd and perhaps confusing when training on what instances are if everything looks like it has one.69Views9likes3CommentsReporting on Alerts and SDTs
Hi all, I am having an issue trying to generate a report of alerts that are generated outside of SDT. I have found that the 'In SDT' field is only populated while the alert is outstanding, so any alerts that are cleared do not have the 'In SDT' field set to Y. As a result, I am finding it impossible to screen out alerts generated during SDT. My assumption (incorrect) was that 'in SDT' would do this. My requirement is to be able to generate trend data on alerts that are relevant to particular teams/escalation chains, to say (for example) the Linux team had 10 Critical alerts last month, vs 50 the previous month, but unless I can screen out the alerts that are generated during SDT, these may all have been expected and require no action, so the data is meaningless. I was pointed to wards the Alert dashboard, as this has fields for alert suppression type, but this does not seem to be populated either, or is similarly cleared when the alert clears. Has anyone else found an appropriate way of reporting on Alerts that screens these out?28Views1like2CommentsWinSQLServices DataSource
For WinSQLServices DataSource, do I need specific permissions? Logic Monitor documentation only mentions SQL Server (MSSQLSERVER) Service but what about adding other services such as SQL Server Agent or SQL Browser or SSIS under that DataSource? SQL Server (MSSQLSERVER) service requires permissions specified in documentation. Would adding other SQL Services require more permissions or any changes in way they're added? For example, be part of specific security/admin group or run under service account or managed account?24Views0likes1CommentCollector Server on Azure VM
I have Collector Server Installed on Virtual machine in Azure. I added Collector successfully to Logic Monitor. I can't add other 3 servers. Collector can't communicate with other hosts. Here is the environment: Collector Server on Azure VM | Server1 and Server2 --> vnet1 | | peered | | Server3 --> vnet2 Servers are peered between 2 network that are in two different regions and I still have a problem. Does that mean I have to add two Collectors to Logic Monitor? One per virtual network/region? Ping/Host Status-critical error in Logic Monitor. Collector can't communicate with other servers I want to add to Logic Monitor. All ports are enabled/firewall checked/permissions are correct. (documentation says: There must be at least one collector per CSP account, one per region, and one per VPC. ) Any way to set it up without adding second Collector? Why wouldn't Collector communicate with any of the vnets?60Views0likes5CommentsHistory of LogicModule version changes
I was wondering if there is a way to get the history of specific module version changes? I updated few modules but it looks like I have to revert some of them back for now. I am not sure if I have to go back 1 or 2 updates back. Local History under the module doesn't point to specific version in the past. Is there a way for me to get this information?15Views0likes2CommentsVolume Capacity- Drive is missing
Some servers are not monitoring J Drives anymore. There is J Drive in Physical Disks but not in Volume Capacity. In Audit Logs there is information about new instances being found and some instances disappeared from host but there's no explanation why. Drive exists on the host. I attached screenshot. In Global Definition I run Active Discovery on WinVolumeUsage and there were discovered Drives except the J Drive. Also, received a Active Discovery- 3 instances being filtered out- I attached screenshot. Were there any recent changes in Logic Monitor? I didn't update any modules so that is not a cause.74Views7likes8CommentsLM Production Settings and configuration to be import and export from Prod to Dev ?
Is there a way in Logic monitor to configure or transfer the settings and configuration available from production to Dev(Sandbox) Basically the Dev should be the replica of production but limited for testing ? We have got a new LM sandbox(DEV), we want to configure the settings groups, Custom properties and other configuration which is configured in production to be configure in sandbox(Dev) as well ? What is the best way to do this process? is there any import export option available ?56Views4likes4Comments