The most recent content from our members.
All SQL Servers under monitoring show: ------ Node is Up. AppInsight for SQL: Application 'MSSQLSERVER' has state: Unknown. ------ AppInsight for SQL - I don't know how to solve it((( Did you come across with that problem before? I provided all required permissions. USE master;GRANT VIEW SERVER STATE TO…
I'm new to SolarWind and I have a question in Tuning Advisor. Does this mean it advise me to create another non-cluster index ? The table already contain cluster index on columns OrderNo and TestCode. And non-cluster index on columns ReceivedDate, HN and OrderDate. When I press Show index DDL. This query message display…
Hi All, I'm currently monitoring a number of SQL Server Managed Instances with DPA version 2022.3.7963, and the deadlock tab always displays No deadlocks detected in this time interval, even when I know there have been deadlock events during the selected time period. I've verified this by logging onto the server and…
This may be a dumb question but ... I am trying to register an instance for dpa but when I enter the sysadmin creds, the same ones I normally use for other SolarWinds activities, and I get the following message below "Error Message: Invalid user and/or password [error=java.sql.SQLException: Login failed for user" kind of…
I am trying to configure a Windows Event Log Monitor in SAM for Event ID 3041 from MSSQLSERVER in Applications. This occurs on our SQL server when a database transaction log backup fails. We had this monitor setup on our old Microsoft SCOM server where an email would be sent out with the database name that failed. We then…
Hi, I am looking to make query for ignite repository(SQL) that would get identical results to what can be seen in webpage Server->Current->Long Running(Average). Maybe someone already has query like that and I will not need to dig through the repository? Regards, Nerdingas
Hey, has anybody an idea how to monitor status of MS SQL Agent and SQL server jobs run status? Is it possible with Event Log monitoring only or any other method (preferred)? MS SQL 2008 Enterprise and Orion Core 2012.1.1, SAM 5.2.0 SP1, NPM 10.3.1, NTA 3.10.0, IVIM 1.4.1
It looks like you're new here. Sign in or register to get started.