The most recent content from our members.
Good morning, I searched through the forum for any information related to SQL Text not showing up for a monitored secondary MSSQL replicas, but I couldn't find anything germane. I have a 3 node cluster/AlwaysOn AG - I added each node , the RW, RO, RO . The one I am concerned with is the RO node that has sprocs executed…
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…
Thanks to this thread Re: Need to create a report that includes the number of CPU sockets, CPU Cores per Socket, CPU Vendor, Total CPU Cores. This should target all physical servers (Windows, Linux, Solaris, ESXi, Nutanix, Xen). I have a great report that gives socket, core and processor info. I would like to try to add a…
Hello SWers, I am working on creating a PS component monitor in SAM. I have been reading as many posts as I can to try to reach my end goal, but I am thinking I need to check with the community to see if what I am trying is possible (I think it is). What I am trying to do is this: I have a SQL query, that I know returns X…
Hi Thwack community, I couldn't find built in report that can help me to filter the triggered alerts in certain time duration, like between 10:00 am to 4:00 pm on Tuesday - Thursday. I have attempted to build sql query with my desired columns and wanted to use BETWEEN function. however the time and the date are stored in…
I have an application monitor set up to monitor SQL server health statistics using a specific query, so I'm using the SQL Server User Experience Monitor component to query SQL servers and return a value. At times the SQL service may not be running so the component just goes critical or down, not a big deal. Our security…
Output of this query is showing 1 hour delay in unmanageFrom and UnmanageUntil and some time showing wrong accountID. any one help me????? Select N.Caption, N.UnManageFrom, N.UnManageUntil, AE.AccountID, N.StatusDescription from Orion.Nodes N LEFT OUTER JOIN ( SELECT NetObjectID, Max(AuditEventID) as [AuditEventID],…
Hi, I am in need of pulling information from another sql server using the below sql query. SELECT * FROM (SELECT XMLMessage.value('(/LogMessage//StateCode/node())[1]', 'nvarchar(max)') AS AlarmType, DATEADD(MINUTE,-300,MessageUTC) AS LocalDateTime FROM JournalLog WHERE MessageUTC >= DATEADD(day, -1, GETDATE())) AS INTAB…
We have been utilizing SQL Server Query Store for dissecting question execution. So far it has worked out really well and it's free. Have any one utilized solarwind's DPA apparatus for execution examination? Assuming this is the case, would you be able to share upsides and downsides and how it analyzes to SQL Server query…
It looks like you're new here. Sign in or register to get started.