Posts
Sort by recent activity
How To Covert T-SQL Logic to Regular Expressions Logic
How To Filter the LRQ (Long Running Query) ALert using Regular Expressions
I don't know if its the way I'm asking this or if its just that the search critieria is too simple for Regular Expression...
Where In the SQL Monitor Is My Data From The Last Server?
We recently switched out our primary DB server for a new one and that of course meant changing in SQL Monitor the name/instance of the SQL Server we are monitoring. That’s worked fine with the e...
Can I Get Analysis On Built-In Alerts
When in the ANALYSIS tab I can see my own custom metrics and get a chart of the history of the alerts occurrence. Where can I get the same for the built-in alerts like the LRQ (Long Running Query)...
Restoring a DB backed up via SQL Back without SQL back
If I back up a database to multiple files using SQL back (so as to create several smaller files instead of 1 giant bak file) and then move those files to another SQL Server do I have to use SQL Ba...
Repeating LRQ Alert that persissts (ACTIVE) All day long
Does SQL Monitor raise an LRQ Alert on the Stored Procedure ‘sp_trace_Getdata’ for you? It does for us and not only one LRQ but 2 HIGH level LRQ alerts which persist at an ACTIVE status all d...
Gaps In ANALYSIS Data with No Corresponding Alerts
Several times yesterday (2012/07/02) between 12PM CDST and 530PM CDST SQL Monitor shows gaps in info gathered and shown in the ANALYSIS tab.
For example, SQL User Conections which shows how many us...
Reconnecting automatically after monitoring stopped
The Redgate Help Doc titled "Reconnecting automatically after monitoring stopped - SQL Monitor" ( http://www.red-gate.com/supportcenter/Content/SQL_Monitor/help/3.0/SM_ReconnectAutomatically ) deta...
SQL Backup Pro vs MS System Centers DPM
Currently we are using the System Center Module DPM (Data Protection Management) and while it’s great for doing restores it is less than good when it comes to backups.
We have a 250GB DB with a ...
How Many Ticks Does It Take DT To Load a DB Schema?
How Many Ticks (or seconds) Does It Take DT To Load a DB Schema?
I just timed it to find out myself and during normal business hours it takes Dependency Tracker more than 600 seconds (or greater t...
SQL Monitor Alerts - LRQs (Long Running Query) Alerts Config
The default settings for the LOW, MEDIUM & HIGH Level alerts for LRQ alerts are:LOW: Raised when a query takes 60 seconds or longer to run to completionMEDIUM: Raised when A query takes longer than...