The most recent content from our members.
I've combed through Thwack trying to find an answer, but alas, no luck. We are needing to upgrade our SQL DB backend for NPM and NTA from 2012 to 2017. I am soooo confused by the licensing. Solarwinds takes a neutral stance on this and I get that Microsoft doesn't really have clear answers either. I can't get a straight…
I'm new to using DPA - while monitoring some alerts, I found that we had repeated attempts for a "login failed for user 'domain\User': attempting to use an NT account name with SQL Server Authentication [CLIENT: <local machine>]" After doing a bit of research, we have identified that the attempted logins were coming from a…
We have a report written in sql that use to reside on a MS Reporting server. The frame work is as follows in SQL ;with BaseQuery as ( select distinct n.Caption Node_Name, n.Description, p.Network_Zone, TotalResourceUnit = 1, (in SWQL this line looks like '1' AS [TotalResourceUnit], (thank you dgsmith80) Active_Port_Count…
Since we have the EOC2.2, we are trying to convert some custom reports that we did in MS Reporting server to SWQL. We learned a few things. Custom properties do not appear in the nodes view when using the swql studio however that info does appear in Orion.NodesCustomProperties. So there are two things I am stuck on.…
Need to get only last 30 days data in below query. SELECT TOP 1000 SummaryDate, SourceSiteName, DisplayTarget, AVGofAvgJitter, SourceNodeID, TargetNodeID, AVGofAvgJitterSourcetoDestination, AVGofAvgJitterDestinationtoSource, OperationID FROM Orion.IpSla.OperationsJitter
Good morning, hope all is well. I’m looking for the following metrics Machine Name OS DNS Name CPU Cores RAM (GB) Disk (GB) The thing is I’m looking for this for each SQL Instance in our environment. I know we can get this with SolarWinds AppInsight for SQL, but we have so many databases in our environment that we would…
Most of my SQL servers Eat up 90% to 95% of its memory, my average SQL server build is between 64GB to 512GB of RAM. I am having a hard time setting up alert thresholds based out of percentage. no one cares if you eating 95% of memory because my server builds are huge can anyone give me point on how to setup alerts based…
Hello Everyone, We are installing an enterprise platform and need to know some recommendations for the setup / configuration of SolarWinds. Here are the products we purchased: 1. Network Performance Monitor 2. Web Help Desk 3. Network Configuration Manager 4. Network Traffic Analyzer 5. Dameware We have offices across the…
It looks like you're new here. Sign in or register to get started.