I'm consolidating some alerts that create multiple emails, the best way I found so far is use "All metrics in this list" for a single...
SQL Diagnostic Manager for SQL Server
SQL DM causing excess load on Production OLTP server
Currently when I take SQLDM out of Maintenance mode the CPU utilization o the OLTP database it is monitoring goes up to between 75 and 95% and stays...
Troubleshoot High CPU with SQL Diagnostic Manager
We recently had an issue where our primary database server was sustaining 100 % CPU utilization. We were able to identify sqlservr.exe was...
Need SP Names to invoke List of Idera Reports in MS SQL 2012
Hi, Below are the reports which I would like to get on MS SQL by invoking the Stored Procedures of Idera DB which we have, Can you please specify...
Page life expectancy…with duration
can this alert be configured so only if PLE is below a threshold and stays below the threshold for a "n" seconds, the alert needs to...
Wants to add more information in alert generated through SQLDM
Hi Team,I wants to add more information in alerts generated due to SQLDM. for example - if I got alert for session taking long CPU then I got...
Session CPU Time issue.
Hi, I gets Session CPU Time alerts on my mail. its shows every thing but it did not show hostname and user name in this report. Can you please help...
Create a report for SQL Server status: Unable to connect
I'm wondering if there isany way to report on this status. I tried to create a custom report but it doesn't appear in the...
SQL Log file
I'm new to Idera, however the IT group are running SQL Diagnostic tools to help look for a speed issue with a SQL database across a new network....
Could not load file or assembly 'License4Net.dll' or one of its dependencie
Could not load file or assembly 'License4Net.dll' or one of its dependencies. The application has failed to start because its side-by-side...
Setting up SQL DM for the first time
When folks are setting up the tool for the first time, do you enter all nodes for AlwaysOn clusters and failover clusters or just the AGL or virtual...
Unable to Upgrade from 10.1.4 to 10.2.2 – License4Net.dll issue
After the November 6th issue were the Idera SQL Diagnostic Manager desktop client stopped working was resolved (Licence4Net), I wanted to upgrade...
DM 10.1 cannot connect to sql server 2016
Cannot create connection DM 10.1 and sql server 2016- getting error from DM Manager server during test connection phase: "A connection was...
SQLDmCollection Service.exe is consuming more memory on windows server
Hi Team, We have SQL diagnostic Manager 10.0.2 version running for monitoring MSSQL Instances and SQLdmCollection.exe is consuming more physical...
SQL dm Service Stops
Hi, Every few minutes the SQLdm Management Services stops and requires me to manually restart it. The event log says the following. Any...
Secondary Replica instance throws unable to monitor errors
We have an AG setup that has a primary replica and a synchronized commit secondary replica that we use for reporting (SQL 2016, Windows 2016, SQLdm...
product-oriented educational blog posts for SQL Diagnostic Manager
Here is a list of product-oriented educational blog posts for SQL Diagnostic Manager: Five Important Features of SQL Diagnostic Manager How to...
SQL Memory Utilization
I am new to SQL DM. Added few of our servers to Monitor and on one of the servers there is an Critical Alert "OS Memory Used is 92%" ....
SQLdm Management Service High Memory
Hi all, Recently our SQLdm Management Service has been consuming all the memory on the server and is causing the collection service to crash. ...
Sessions Details and Lock Details not loading post upgrade to 10.2
I am not able to see session details post upgrade to 10.2. It keeps refreshing without showing any details. Locks details also comes up with...
Alert Responses are not triggered
Hi, I have started working with SQLdm (10.2.0.3269 Trial version) this week and I can able to monitor the SQL servers without any issues. :)...
SQLdmDatabaseInstall.sql incorrect settings: 'ANSI_WARNINGS'
Hello, can you help me with IDERA SQL Diagnostic Manager Installation please ? My boss asked me to try and choose best monitoring tool for our SQL...
Alerting for corrupted databases
Hi all, I have a corrupted database for testing purposes. Is there a way to detect Errors thrown by DBCC checkdb?Actually I have 1 allocation error...
Fragmentation alert – setup a limit on Page Count
Can I know if there is a way to set a Page Count limit for Fragmentation alerts? Right now I have a table with "image' field in it and a...