Posts
Sort by recent activity
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, ...
SQL process fragment just display "SELECT"
I've received a Long-running query alert, when I open the alert detail in WebUI, it show:
*****************************
Process ID: 369
Process name: Process_Name
Host: Copmputer_Name
User: User_Na...
SQL Response V2 cause server deactivate in V1?
Hi all,
I've install SQL Response V2 in a Virtual Machine which monitoring SQL Server A. However, when I open SQL Response V1, I've found that SQL Server A is deactivate on 23 Oct.
Does SQL Respons...
Process ID not found in Performance Snapshot
I'm using SQL Response 1.3 and SQL 2000 Ent. We've noted that when we open the details of SQL deadlock/ Long running query, I can't find the Process ID in Performance Snapshot that shown in Deadloc...