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...
a question for web console in 8.5
read more
SQL Diagnostic Manager for SQL Server
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...
Custom counter – deadlocks in the past X hours
In response to a couple of requests, here’s a custom counter that allows you to alert on the total number of deadlocks which happen in a...
Capacity Management and Planning
Would be nice to have a tool that would show growth of database, instance, Server over time with forecasting to provide approximate time until disks...
Any way in DM to monitor if a job is running?
Management wants an alert is a specific job on a specific server is not running on Sundays at 6:00 PM EDT. I’m looking at DM, Powershell,...
PDF Reports are Enormous
February 12, 2014 at 2:23 pm