Currently we have alerts set up in SQL Sentry and are migrating to SQLdm. Our current alerts notify us when a server goes offline and then we...
SQL Diagnostic Manager for SQL Server
Bugfix in SQLdm 8.6?
Hi there, can anyone tell if this anoying bug is finally fixed, that everytime you use the SQLdm powershell plugin to set an instance into...
Lead blocker is a SQL DM thread.
I’m looking at the history from this morning in SQL DM. I have 13 sessions being blocked by entry 152 which for a while there I wasn’t...
Where metric severity has changed
Hi I would like to understand what exactly Does “Where metric severity has changed” means in Alerts actions and responses. Does that...
SQLdm WebUI Service and Java.exe memory usage
We are noticing are java.exe process that is taking up significant memory. At 11 AM it used 317MB, by 7PM it was up to 520MB and growing. There are...
Upgrade Errors with 8.5
Hi, I’m new to SQLdm. I’ve been tasked to upgrade from 8.01 to 8.5. During the upgrade process I get an error stating that it...
a question for web console in 8.5
I recently installed DM 8.5 and love the web console feature. While it runs on http://servername:9279, I wonder if there is a way for me to...
Add custom counter error
Hi All, Below is the error I get everytime I try to create a custom counter. I just updated to 8.5 and I am wondering if this is a bug or if my...
Granting Namespace Rights to DM Service Account
community.idera.com/.../Granting-Namespace-Rights-to-Service-Account-for-SQldm-Web-Console-Services.docx Useful document describing how to grant...
Adhoc Query to Check Status of Servers and Active Alerts
I’m needing to put together some adhoc queries to show the status of all monitored SQL Servers, whether Critical, Warning or OK. I’m...
Connect to Newsfeed from laptop
Newsfeed is up and running and I can connect to it from the Diagnostic Manager console running on the same host Newfeed is running on. However if I...
SQLdm – permission to view selected servers
We are using SQLdm throughout our enterprise for hundreds of SQL Servers across many lines of business. Our consultant said that there is no...
Definition Request – Sort, Hash, Index (Memory Areas)
Hello, I’m having a hard time figuring out what’s happening when I see this: Can someone steer me in the direction of what this metric...
Custom Counter – Select All Instances
Hi In Perfmon I can select all instances of a counter for example â€SQLServer:Databases(*)Log Bytes Flushed/sec†which will collect data for...
[Definition Request] — MaintenanceModeType column
Greetings, My company is writing a wrapper stored procedure which we will call on a centralized monitoring SQL Server instance to put SQL Server...
Idera SSRS reports
I recently deployed some of the Idera reports in SSRS, using the ‘deploy reports’ option from within Idera. It successfully deployed the...
OS metrics – WMI connection error
Configuring a monitored server (Windows 2008 R2) OS Metrics Select: Collect Operating System metrics using direct WMI Check: Connect using the SQLdm...
Mobile Newsfeed Login
Hi All Total Noob here. I just installed the newsfeed service. I logged in via SQLdm console. When i try to login mobile, it’s askign for a...
SQLdm Restarting SQL Traces
Our company has a full time trace running to collect audit data needed for SOX Compliance. We recently purchased and install SQLdm and chose this...
SQL 2012 Always On Redo Rate
We are monitoring SQL 2012 Always On instances and found that lower utilized databases report the Redo Rate in the range less than 100 KB/sec for...
Tracking query performance over period of time
I’m researching whether or not SQL DM has the ability to either report on query performance over recent periods by default or if I can...
CPU Statistics in Resource Reports – what does it mean ?
Hi, we have 2 active instances running on one node of a sql cluster which contains 80 cores and I’m trying to gather the CPU statistics to do...
Always-On Availability Groups hosting a repository
Whether it be SQLdm, SQLcm, or SQL Elements it would be great if the possibility existed where we could run the repository as part of an...
SQL Diag Monitor memory usage counter
I recently had a problem with one of my sql servers and it brought up a question. I had a very underpowered VM running replication. It was the...