1 feature, 1 bug

fatherjack2fatherjack2 Posts: 311
edited December 24, 2008 6:45AM in SQL Monitor Previous Versions
Hi,

Feature first:
I have merge replication set on two databases between two instances. the replication schedule runs from 08:00-20:00. There are over-night data processes that run to increment time bound values etc in the published databases. this takes place outside the replication schedule. The first replication job to run in the morning takes a long time (00's of seconds) but all others run in 15-30s. I get alerts all day long about the job running for an unusual time. I have no idea how you can get around this situation but it would be great if you could! I cannot set a % on the alert settings that will allow for this.

Bug
I have created a custom filter for alerts and recommendations views but when starting the application these filters are not applied. They are shown in the filter drop-down (as they were active last time i used the application) but i have to select them again to get them to take effect.

thanks
Jonathan

Senior DBA
Careers South West Ltd

Comments

  • Eddie DEddie D Posts: 1,780 Rose Gold 5
    Thank you for your post into the forum.

    I have submitted a Feature Request for consideration by the SQL Response Development Team, for users to be able to monitor and configure thresholds for SQL Server Merge Replication Tasks as it's own alert. The reference for this request is SSR-1373.

    As for the Bug you submitted. Myself and a colleague have tried setting custom filters and views. After the closing the client, SQL response re-opens the last view, viewed by the user. So if I was using my custom view and then closed SQL Response Client. On reopening the client, my custom view is loaded.

    Can you please confirm that you are using the custom filter and view before closing the SQL Response client?

    Many Thanks
    Eddie
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
  • Hi Eddie,

    Yes I am only using the custom filter all the time. I use it all day (eg last Friday) and at the end of day I close the application and shut down the PC. In the morning (today) I start my PC, start SQL Response and the alerts are listed in full detail. I have to click the custom filter name and then the filter applies...

    Senior DBA
    Careers South West Ltd
  • Eddie DEddie D Posts: 1,780 Rose Gold 5
    Thank you for your reply.

    After closing and reopening the SQL Response Client. Once the client has loaded, what is the view name in the 'Show:' drop down box on the toolbar?

    Can you please locate the ClientSettings.dat file in the following directory:
    C:\Documents and settings\<User_Name>\Application Data\Red Gate\SQL Response Client

    If you open the ClientSettings.dat file using notepad, you will see some xml code like the following:
    &lt;root&gt;
      &lt;persistRoot version="1" isObject="true"&gt;
        &lt;Type&gt;Settings&lt;/Type&gt;
        &lt;MainFormX&gt;0&lt;/MainFormX&gt;
        &lt;MainFormY&gt;0&lt;/MainFormY&gt;
        &lt;MainFormWidth&gt;0&lt;/MainFormWidth&gt;
        &lt;MainFormHeight&gt;0&lt;/MainFormHeight&gt;
        &lt;MainFormWindowState&gt;2&lt;/MainFormWindowState&gt;
        &lt;MRUServers&gt;tcp://localhost:7398/MonitorService,tcp://ed:7398/MonitorService&lt;/MRUServers&gt;
        &lt;PerformanceGraphColors&gt;
        &lt;/PerformanceGraphColors&gt;
        &lt;IncidentCachePath&gt;
        &lt;/IncidentCachePath&gt;
        &lt;MaxIncidentCacheBytes&gt;104857600&lt;/MaxIncidentCacheBytes&gt;
        &lt;TimeFrameIndex&gt;1&lt;/TimeFrameIndex&gt;
        &lt;UseIncidentSummaryDiskCache&gt;False&lt;/UseIncidentSummaryDiskCache&gt;
        &lt;CommentUsername&gt;
        &lt;/CommentUsername&gt;
        &lt;AlertView&gt;My View 1&lt;/AlertView&gt;
        &lt;RecommendationView&gt;
        &lt;/RecommendationView&gt;
        &lt;GroupByServer&gt;True&lt;/GroupByServer&gt;
        &lt;ShowAlerts&gt;True&lt;/ShowAlerts&gt;
      &lt;/persistRoot&gt;
    &lt;/root&gt;
    

    Do you have your custom view name in between the <AlertView> </AlertView> code?

    Many Thanks
    Eddie
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.