Comments
Sort by recent activity
Hi,
Yes you can safely uninstall SQL Response 1.3. There is no shared component between Monitor 2.0 and Response 1.3.
Regards,
Priya / comments
Hi,
Yes you can safely uninstall SQL Response 1.3. There is no shared component between Monitor 2.0 and Response 1.3.
Regards,
Priya
Hi Jeff,
Apologies for the issues you have been facing.
Could you please send the log files to support@red-gate.com? The log files are at this C:\ProgramData\Red Gate\Logs\SQL Monitor 2 or C:\Documents and Settings\All Users\Application Data\Red Gate\Logs\SQL Monitor 2 (for pre-vista OS) location.
Thanks,
Priya / comments
Hi Jeff,
Apologies for the issues you have been facing.
Could you please send the log files to support@red-gate.com? The log files are at this C:\ProgramData\Red Gate\Logs\SQL Monitor 2 or C:\Docum...
Baguck wrote:
*Sorry for digging up an old thread, I just found this by searching for my issue.*
Is there any update to this issue?
I understand that this is a Windows issue, I just did not know if a workaround had been discovered similar to the /32 workaround for perfmon.
This 64bit/32bit setup describes 95% of the servers that I administer. There are plans for the setup to be updated in the near future, but wondering if there is a workaround for the present.
Thanks
Hi,
Thanks for your post. Unfortunately, there is no workaround for the this windows limitations.
Regards,
Priya / comments
Baguck wrote:
*Sorry for digging up an old thread, I just found this by searching for my issue.*
Is there any update to this issue?
I understand that this is a Windows issue, I just did not know...
Hi Rhys,
Unfortunately this is a Microsoft issue and we cannot do anything about it. http://support.microsoft.com/kb/891238 http://blogs.technet.com/b/rob/archive/ ... ssues.aspx
Thanks,
Priya / comments
Hi Rhys,
Unfortunately this is a Microsoft issue and we cannot do anything about it.http://support.microsoft.com/kb/891238http://blogs.technet.com/b/rob/archive/ ... ssues.aspx
Thanks,
Priya
Hi Rhys,
This error generally comes up when performance monitor doesn't return the data for the counters.
Could you please try the following?
1. Is the problematic SQL Server a 32 bit SQL Server on 64 bit windows OS? If no, then please try step 2.
2. Open Performance/ System monitor (open Run and then type perfmon). Then select the listed performance counters i.e. SQLServer:Access Methods, SQLServer:Buffer Manager etc and verify if you can see values for this counters in Performance monitor. If you are not able to see any values here then there is a chance that the performance library might be corrupt and you may have to rebuild it. Please try the steps as listed in support article from Microsoft. The link to article is listed in this help page. http://www.red-gate.com/supportcenter/C ... %20Monitor
Thanks,
Priya / comments
Hi Rhys,
This error generally comes up when performance monitor doesn't return the data for the counters.
Could you please try the following?
1. Is the problematic SQL Server a 32 bit SQL Server on...
Hi,
Thanks for your post. I will investigate this and get back to you.
Regards,
Priya / comments
Hi,
Thanks for your post. I will investigate this and get back to you.
Regards,
Priya
Thanks John and Oderks for your post.
The Job Duration Unusual alert operates in two stages:
Firstly we calculate the baseline (using the median of the last 10 runs). If this is less than the short running time threshold, the alert is disabled until the baseline increases again.
Once the job is known to take a while, we compare each run against the baseline and alert if it deviates too far away from it.
The default configuration thus makes the assumption that a quick running job can be ignored, and once a job is known to take a significant time, it shouldn’t start running quickly or slowly.
Ignoring short running jobs is a powerful way to set defaults for a whole server, but it isn’t that useful to be set on an individual job. You know how long the job normally takes, and so can enable or disable alerting on it to taste.
The ‘ignore if runtime is less than…’ doesn’t work for the use case where you have a job that (say) copies any available new log files, which will run in less than a second if there is nothing to do but takes several minutes every now and then. We didn’t want to try and automagically figure out what is happening and this case and risk getting it wrong.
Hope it explains the behaviour you both are noticing.
Thanks,
Priya / comments
Thanks John and Oderks for your post.
The Job Duration Unusual alert operates in two stages:
Firstly we calculate the baseline (using the median of the last 10 runs). If this is less than the short...
Hi,
You can follow the following steps:
Before running installation:
1. Go to SQL Server management Studio, create a new blank database called ‘RedGateMonitor’ or a database with name of your choice.
2. Ones this database in created, then delete the user defined objects in this database.
3. Now run the installer as normal and at the ‘Set up Data Repository’ stage of the installation, click the ‘Set up Data Repository…’ button and select ‘Use an existing SQL Server database’.
4. Select the ‘RedGateMonitor’ database that has already been created and continue with installation.
Thanks,
Priya / comments
Hi,
You can follow the following steps:
Before running installation:
1. Go to SQL Server management Studio, create a new blank database called ‘RedGateMonitor’ or a database with name of your c...
Hi,
Thanks for your feedback. Unfortunately, this is not supported in the current released version. I have logged this enhancement request as SRP-2472.
Thanks,
Priya / comments
Hi,
Thanks for your feedback. Unfortunately, this is not supported in the current released version. I have logged this enhancement request as SRP-2472.
Thanks,
Priya
Hi Kevan,
The graph draws only when it has at least two data point in the selected time range. The metrics which you have listed are not collected frequently.
I assume that you see this when you are on default time range of last 10 minutes. Can you try a time range greater than 1/2 hour and see if this works for you?
Thanks,
Priya / comments
Hi Kevan,
The graph draws only when it has at least two data point in the selected time range. The metrics which you have listed are not collected frequently.
I assume that you see this when you ar...