Comments
Sort by recent activity
Hi,
You are not getting Long Running with duration of 2 seconds because by default we poll only every 45 sec (for Long Running Query). So for a query to qualify for 'Long Running Query' alert it should ideally pass at least twice when we poll. So SQL Response can at best catch a query of duration 46 sec but it will always catch anything which is running for more than 90 sec (which is double the polling frequency). E.g. if you always want to catch a query which is of duration 40 sec or more then you have to reduce the polling frequency to 20 sec.
You can look at the config.xml (which is in install directory where you have installed your Alert Repository). This is by default should be at this location C:\Program Files\Red Gate\SQL Response 1\Alert Repository. Then look at this particular section:
<!-- This will affect the polling frequency for these alerts; Long running query and Blocked SQL Process - setting to every 45 seconds-->
<SysProcessesTime>45</SysProcessesTime>
You can change this to modify the polling frequency. But I would not recommend to set this to a very low value as this will have impact on the performance of your server.
If you want to test SQL Response for a Long Running Query then may be the easiest thing would be to use a waitfor delay statement. Something like Waitfor delay '00:02:00'
Regarding your second problem.. if you have already tried the all the steps in the KB article and still the new alert occurrence has the same problem then please send the Alert Repository log files to support@red-gate.com. You can access the log files via the Icon Menu on the top left hand corner.
Thanks,
Priya / comments
Hi,
You are not getting Long Running with duration of 2 seconds because by default we poll only every 45 sec (for Long Running Query). So for a query to qualify for 'Long Running Query' alert it sh...
Thanks a lot for your feedback. I have included this in our feature list. For your reference, the tracking id is SSR-1661.
Thanks,
Priya / comments
Thanks a lot for your feedback. I have included this in our feature list. For your reference, the tracking id is SSR-1661.
Thanks,
Priya
Hi Gregor,
Select the server you want to license on the left hand side under "Servers to show". Right click and get the context menu. Click on 'Activate Server License' to license the server.
Thanks,
Priya / comments
Hi Gregor,
Select the server you want to license on the left hand side under "Servers to show". Right click and get the context menu. Click on 'Activate Server License' to license the server.
Thank...
Hi Matt,
Ideally, changing the name of the server shouldn't cause you any licensing related issue.
The best way to sort this out... would be to send your license key to support@red-gate.com and then they can look at the licensing server and let you know how many activations and deactivation etc is against that particular license number.
Thanks,
Priya / comments
Hi Matt,
Ideally, changing the name of the server shouldn't cause you any licensing related issue.
The best way to sort this out... would be to send your license key to support@red-gate.com and th...
Hi Cowski,
'SQL Response Alert Repository 1' should be listed in the Add/ Remove Program. But since you are not seeing it in this list .. I would assume that you have installed the Alert Repository on a different machines (and client was on this machine for which you have posted the screen shot).
Do you remember that which machine you installed Alert Repository on? Please log to that machine and then uninstall 'SQL Response Alert Repository'.
But if you do not remember then .. if you have emails coming then look at this part of the email: More details for Server: Server1/SQL2005 - [url=sqlresponse://machinename.red-gate.com:7398/4694/8cc7fa56acf4b78]sqlresponse://machinename.red-gate.com: ... a56acf4b78[/url]
This should be the machine machinename.red-gate.com on which you have installed your Alert Repository.
Hope this helps.
Thanks,
Priya / comments
Hi Cowski,
'SQL Response Alert Repository 1' should be listed in the Add/ Remove Program. But since you are not seeing it in this list .. I would assume that you have installed the Alert Repository...
Hi Cowski,
SQL Response has two main component .. client (UI) and Alert Repository (main engine which collects the data from SQL Server and sends email etc). It looks like you have only uninstalled SQL Response client.
Please also uninstall 'SQL Response Alert Repository 1'. Once you have uninstalled 'SQL Response Alert Repository 1' then no email will be sent.
Also, SQL Response Client and SQL Response Alert Repository uninstall does not require you to reboot the machine.
Please do let us know if you still keep getting emails after uninstalling SQL Response Alert Repository.
Thanks,
Priya / comments
Hi Cowski,
SQL Response has two main component .. client (UI) and Alert Repository (main engine which collects the data from SQL Server and sends email etc). It looks like you have only uninstalle...
Hi,
Apologies for the issues you have encountered.
SQL Response sends an email only when the alert is raised for the very first time. If the alert is not cleared then no further emails will be sent for that alert.
Have you cleared deadlock alerts? If you have already done it and then also you don’t get email at the next occurrence of this alert then please send the Alert Repository log files to support@red-gate.com.
You can access the log file by clicking on the top left hand icon/ system menu.
Thanks,
Priya / comments
Hi,
Apologies for the issues you have encountered.
SQL Response sends an email only when the alert is raised for the very first time. If the alert is not cleared then no further emails will be sent...
Hi Simon,
SQL Response V 1 doesn't support this.
But just to let you know that we are currently developing V 2 of SQL Response and "maintenance window" is one of the features in our list. We are at very early stage of the project so I wont be able to give you more information at this stage but this is something we are definitely considering.
Thanks,
Priya / comments
Hi Simon,
SQL Response V 1 doesn't support this.
But just to let you know that we are currently developing V 2 of SQL Response and "maintenance window" is one of the features in our list. We are at...
Hi Simon,
Aplologies for the issues you are facing. Please read this knowledge base article for more information on this issue. http://www.red-gate.com/supportcenter/Content.aspx?p=SQL%20Response&c=knowledgebase%5cSQL_Response%5cKB200910000438.htm
Thanks,
Priya / comments
Hi Simon,
Aplologies for the issues you are facing. Please read this knowledge base article for more information on this issue.http://www.red-gate.com/supportcenter/Content.aspx?p=SQL%20Response&c=...
Hi Proto,
Apologies for the problems you are having.
Is the machine hosting Alert Repository able to see SMTP Server? Please try pinging the SMTP server from the Alert Repository machine and see if that works.
Also, do you see any error on the UI when the test email fails?
If the problem is still not resolved then please email us the screen shot of the "Mail Server Settings" dialog box with the error message and also the Alert Repository log file. You can obtain the log file by clicking on the SQL Response icon on the top left corner and then selecting 'Copy Alert Repository log file' in the menu.
Please email this to support@red-gate.com. Also, please put a reference to this forum post. This will help us to diagnose the issue.
Thanks a lot.
Regards,
Priya / comments
Hi Proto,
Apologies for the problems you are having.
Is the machine hosting Alert Repository able to see SMTP Server? Please try pinging the SMTP server from the Alert Repository machine and see if...