Posts
Sort by recent activity
Unable to send test email
I'm using SQL Monitor 4.2.0.243, I got the error message "Unable to send test email" even I enter correct SMTP server.
I've tried to telnet to SMTP server and send email via port 25 without any pro...
SQL Monitor Slow
I've upgraded SQL monitor from 3.5 to 4, after upgrade, SQL Monitor need more than 10 sec to load a page.
There are 2 server for monitoring, we use default Data purging setting. We've also enable "...
Monitor Stop, cannot auto reconnect
For some reasons, we don't give ddl_admin to SQL Monitor role and we know that the trace off is DBCC Showconfig fail to run.
However, SQL Monitor stop monitoring every Monday morning due to permiss...
Permission for SQL monitor
ref to http://www.red-gate.com/supportcenter/c ... ermissions
SQL Monitor need a account with ddl_admin. However, ddl_admin can drop any tables and databases, how can Ｉ avoid it?
Trace Data Compare with SQL Response 1.3
I'm using SQL Response 1.3. I use it to troubleshoot the deadlock, it help me alot.
I've tried SQL monitor, it's a powerful tool to monitor SQL performance. However, compare with SQL Response, it p...
Extend "SQLResponsedb.trc" lifetime
We're using SQL Monitor 1.3 and enable "collection of trace data", trace files are obtained in "C:\Program Files\Microsoft SQL Server\MSSQL\Data", they will be kept 20 mins.
Can I extend the lifeti...
High CPU Usage
A Processor utilization alert has been obtained in SQL monitor, the CPU usage is 100% over 15 mins, and there are many Long running query alerts which cuased by "Process name: SQL Monitor - Monitor...
Alert by Database/ Table
When I go to Alert page, I can see alert when I select a SQL Instance. However, when I select a database under the Instance, I can't see any alert. How can I obtain alert by Database or Table?
Top ...
Some suggestions in SQL Monitor 2
I'm using SQL Response and planning upgrade to SQL Monitor 2, I've some suggestions:
1. In SQL Process/ Profiler Trace, I can shot the Process ID in SQL Response but SQL Monitor not.
2. When compar...
SQL Monitor Trace Profiler less details than SQL Response?
I've compare SQL Monitor 2.1 and SQL Response 1.3 because I need to decide upgrade or not. However, when I obtain a dead lock record on SQL Monitor, I've found that it's difficult to troubleshoot, ...