Hello, I'm new to Idera and trying to configure alert responses. I want the response of a given alert to be run a SQL query and then send an...
Alert response – SQL Script and email
read more
SQL Diagnostic Manager for SQL Server
Stacking Alerts and Scheduling Maintenance time
Hello All, I am very new to SQL Server Diagnostic Manager. We do not have the web portal installed yet, so I am using the desktop version. I...
Idera Alert – Powershell – Create Jira Ticket
This is a sample of how I am creating Jira Tickets from Idera SQLDM. I could not find anything on the internet. #Install-Module...
needs to move the SQL Diagnostic Manager for SQL server to different server
Hi, We are using SQL Diagnostic Manager for SQL server , currently we are shifting all the server to new location, so we needs to move this Tool...
Idera Dashboard — User not able to see data
I created a user in Idera dashboard and granted it with "DashboardGuest" on IderaDashboard. The user is able to login dashboard from...
Reports Not Showing for any Database metrics
HI, I've noticed that I'm unable to get any Database specific metrics to show in the built in reports on our SQL DM tool. I know this was...
Custom Query
Members, I would like to create a TSQL similar to SELECT SPID, [Last Command], user, [Login Time], [Last Batch] FROM [SomeHIstoryTable...
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)....