Members, I would like to create a TSQL similar to SELECT SPID, [Last Command], user, [Login Time], [Last Batch] FROM [SomeHIstoryTable...
Custom Query
read more
SQL Diagnostic Manager for SQL Server
Report/Chart of General SQL "busy"
My management wants to see a chart/report of when the SQL Server has its "heavy" or "lighter" timeframe, like an AVG WEEK. ...
Interpreting Server Waits statistics
On the Server Waits page of SQL Diagnostic Manager, I'm wondering how to interpret the Wait and Total Wait statistics. I'm interested...
SQLdmManagement Servive repeatedly stops running and will not connect to applicaiton servers
Faulting application name: SQLdmManagementService.exe, version: 10.3.0.92, time stamp: 0x5b631bbbFaulting module name: DB2Perf.DLL, version:...
Configuring Alerts – Customising alerts for specific tables
Hi all, Newbie here. I've got a question and I'm hoping someone can help. In DM I've configured my required thresholds with regards to...
how to upgrade the SQL Diagnostic Manager to 10.4 from 10.2
Hi, We are using SQL Diagnostic manager 10.2 now and we are planning to upgrade into SQL Diagnostic manager 10.4 on the same server. is it...
New Monitor request: "Cumulative Blocking Session Wait Time"
Our current "Blocking Session Wait Time" alert trigger is 1,800 seconds for a particular host (business unit's...
Log Full (Percent) Alert not working
We are currently testing a trial of SQL Diagnostic Manager 10.4.0.3432 and have run into an issue. Our transaction logs are set to not autogrow. I...
Missing data in the GUI serveral times every couple of hours
over the course of a day, our idera reading look like this.... I have officers in the company want this fixed as it disturbs them, if I close out...
Dashboard is Unusable
We have the following installed: IDERA SQL Diagnostic Manager Desktop Client 10.3.1.3IDERA SQL Diagnostic Manager Repository 10.3.1IDERA...
Monitoring SQL Server in AWS
I have a SQL server installed on an AWS VM that I am monitoring via a SQLdm install locally. SQLdm has the hooks to monitor a server on a VM...
SQLDM skipping multiple monitoring sessions across multiple servers
We have a rather large SQLDM configuration here, with 140+ servers / 1000+ databases being monitored simultaneously from one SQLDM instance....
Installation failed: Provider cannot be found error in install log
Receiving the following message when trying to install: IDERA SQLdm Installation was unsuccessfull. The %PROGRAMFILES%IderaSQLdm x64 Installation...
Idera SQL DM 10+ Using the "Net Address" column
I'm having difficulty changing the format of the "Net Address" column in the session details. I can convert it from hex to...
SQLdm Mobile issue – Duplicate name in directory cache
This started happening a week or so ago. I have submitted a support ticket but haven't gotten anything resolved yet. When I logon to...
Need to fire the PowerShell script when idera alert is degraded
Hi, Please give us the proper solution for below challenge. Scenario 1: From IDERA alert responses and actions, we are firing the PowerShell script...
Read-only access to SQL DM
Hi, I've had a request from the on-call app support team to have access to SQL DM. Is there a way to grant them just view access to the console?...
Instances not appearing in Dashboard
We recently upgraded to Diagnostic Manager 10.3.1.3 and installed and the Dashboard, which seems to be working (i can connect and login)....
Performance Makers and Breakers
I attended the Idera Webinar on Performance Makers and Breakers with Mindy Curnutt the other dayVery useful. But Mindy referred to a...
SQL Server status is: Unable To Monitor
I'm receiving the following message from a couple different servers... both are SQL 2016. This is on Idera SQL DM 10.1.4.78. I'm...
Server won't reconnect post-DM migration
I just migrated DM from a 2012 server to 2016 - my monitored servers/SQL instances are a mix of 2012-2016, and they all reconnected with DM...
Does Diagnostic manager search the network to find monitored SQL servers?
I have installed sql server 2016 sp1 on a server in my domain. I installed Idera SQL safe backup agent so I could later add it to...
DatabaseFileStatistics table not getting purged
Hello, The DatabaseFileStatistics in our SQLdmRepository db is getting huge... over 67M rows... that go back to 2016 when we installed the...
RegEx to exclude login probe activity
Looking for a way to configure the SQL Server Error Log alert to exclude failed logins for specific login attempts that are probed daily, similar to...