stek0 ✭✭✭✭✭

Tell me if I'm wrong, but I disagree with this. First because SQL Server needs memory for performance, and to get it clear: its not the scripts which are stored in the memory buffer cache, its the pages. If the SQL Server service is taking to much memory, you can configure the maximum memory settings on the instance level.…

Roses are red, violets are blue, I dont do comments, Flowetry.

totally agree!

Maybe this content of @"KMSigma.SWI" can help you out? https://thwack.solarwinds.com/t5/NPM-Documents/Muted-Nodes-Resource/tac-p/526201

spoiler alert! but i also find this a hard and confusing one. You can find it under Community > "See All Groups" > ...

SAP MaxDB

Hi koleydeb, you can go to your settings > manage nodes > select the node you want to modify and click on list resources. there you can select the AppInsight SQL Server instance. (If you have an installed and activated SAM)

Hi @"itnetworkteam2", you can edit this alert if you have the "SolarWinds Application Monitor" Licence (SAM). All Settings > (PRODUCT SPECIFIC SETTINGS) SAM Settings > (APPLICATION MONITORS) Manage Application Monitors > (APPLICATION MONITOR TEMPLATES) AppInsight for SQL ... you can Edit this template and setup your Full…

Hello jakkidi, you have 2 options from this point: 1. restore the Database to the last know functioning state. 2. repair the Database... (make sure to make a Database Backup before you start) You can repair the Database using DBCC with REPAIR options using SQL Server Management Studio USE [master] GO ALTER DATABASE…

Maybe you can go with this: SELECT Nodes.Caption, Nodes.IP_Address, Interfaces.FullName, Interfaces.InterfaceName, Interfaces.InterfaceTypeDescription, Interfaces.InterfaceSpeed, Interfaces.InBandwidth, Interfaces.OutBandwidth, Interfaces.Caption, Interfaces.IfName FROM [dbo].[Interfaces] INNER JOIN [dbo].[Nodes] ON…

Im not sure if you can do this with the World Map. But propably you can create your own "Network Map" or "Wirless Heat Map" using Orion Network Atlas.

The SWID (SolarWinds Customer ID) is a unique company identifier for your company at SolarWinds. When logged into the portal, you will be able to see your company name and SWID at the top of the screen. Rel:…

In my opinion you dont need to monitor the memory of a SQL Server. Usualy you configure your SQL Server to use 95% fix. If you think to monitor the memory due to performance bottlenecks, I would rather recommend you to monitor the Page-Life-Expactancy (PLE). This is the avarage time the SQL Server page can stay in memory,…

Me personally would not recomend it, but according to the documentation you can run your SW Orion environment in the cloud: https://documentation.solarwinds.com/en/Success_Center/orionplatform/Content/Core-Orion-Requirements-sw1916.htm#Microsof2

There is a standard Widget close to your requirements. is this what you look for or do you need a query to modify?

for WebConsole you need to check your Browser settings. https://support.solarwinds.com/SuccessCenter/s/article/The-Orion-Web-Console-displays-dates-in-American-format-in-some-browsers?language=en_US#:~:text=When%20you%20access%20the%20Orion,DD%2DMM%2DYYYY%20format. also see:…

I guess you already tried just adding a new node with entering the iDRAC IP address by using SNMP. When I do it like this, Orion does not show any Disks in the discovered ressources: But you can add the Node like this and than add a New Universal Device Poller using the DELL OID for physikal disks state…

Hi Kennie, we had a similar Problem with our Orion deployment reaching 96% of the maximum polling rate and we needed to add much more Nodes. To lower the polling rate, we first tried to increase the time between the polls on the global settings. But after that, the warning was still showing up with 96% of the maximum…

I cant give you a statement of all interfaces, maybe because i dont have SolarWinds UDT. But I can serve you a Statement to get all IP Adresses of all SolarWinds managed Nodes: SELECT [NodesData].[IP_Address], [NodesData].[Caption], [NodesData].[Description] FROM [SolarWindsOrion].[dbo].[NodesData]

First you need to check if you have the Permissions on the SQL Server instance (AppInsight for SQL Permissions ) But also Orion sometimes still doesnt discover my SQL Server instances: I dont know what this behavior is, maybe its a bug, but I will show you my expirience with AppInsight for SQL Server: I have a Server with…

Hi Doktor, I had the same issue and finally changed the collation of our Orion SolarWinds database from Latin1_General_CI_AS to SQL_Latin1_General_CP1_CI_AS. (After a few unsuccessful attempts ...) I ended up solving this similar like you, with some additions: * Back up all constraints, indices, stored procedures and views…

Hi Jon, can you specify the deployment Warning? There can be a Warning about the database collation or about the SQL Server Instance collation (or both) PS: The SQL Server Collation can affect the performance in some cases like Case-Sensitive and Case-Intensitive querying. (The Orion Platform does not support…