What are the challenges you face when working across database platforms? Take the survey
Options

GUI Display in Professional Edition Questions

rgiesbrechtrgiesbrecht Posts: 17 Bronze 2
edited July 20, 2009 4:58PM in SQL Backup Previous Versions
Two questions:

1. Is there a way to have the GUI display of monitored servers automatically refreshed at a specfied interval?

2. I have two workstations monitoring the same set of servers (one workstation for each data centre) and it appears that whenever I refresh the server display on one workstation, that same server develops a red 'x' on the display on the other workstation. Is this normal?

Comments

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

    Unfortunately I have been unable to reproduce your fault symptoms where one monitoring workstation kicks out another monitoring workstation.

    What is the OS and service pack level of each workstation?

    Many Thanks
    Eddie

    Eddie Davis
    Red Gate Software Ltd
    Technical Support Engineer
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
  • Options
    rgiesbrechtrgiesbrecht Posts: 17 Bronze 2
    Both workstations are running Windows 2003 Service Pack 2. They also both have SQL Server 2005 Service Pack 2.

    I am not sure if the problem is that one monitoring workstation is kicking the other workstation off, or if the workstations simply periodically disconnect from the monitored servers.

    Most mornings when I check the monitoring workstations, at least half, if not 3/4 of the monitored servers are showing as disconnected and I have to manually refresh the connection on each of them.
  • Options
    marclallenmarclallen Posts: 53 Bronze 3
    I also notice that periodically my connections are disconnected and nothing short of a manual refresh will restore them.

    Marc
  • Options
    Hi, I had similar problems with my local machine and occasionally a development server disconnecting and showing a timeout error - albeit with SQL2K

    It turned out to be because each Server contained several DBs that had the AUTO_CLOSE option set to ON.
    With this set ON, each DB is closed after the last user exist it. Everytime the database gets accessed it has to reopen and this can be a slow process.

    I am guessing that SQL Backup will effectively try to reopen each database when it refreshes its connection to a server and so it takes a while to start them all up.

    This can also cause Enterprise manager to be very slow when you try to expand the Databases node or even the drop down Database combobox in Query analyser seems to go slow if any of the DBs are set to AUTO CLOSE.

    Have a look in the SQL Server Logs to see if you are getting many 'Starting up database xxxxx' messages...
  • Options
    rgiesbrechtrgiesbrecht Posts: 17 Bronze 2
    Sorry, but Auto Close is not the solution. I always disable Auto Close when I create my databases.

    I have a feeling that timeouts may place into this, but I am not sure what setting I would have to change.
  • Options
    Have you tried increasing the connection timeout property for each registered server - right click on the server name and select edit, connection properties tab... That may help?
  • Options
    rgiesbrechtrgiesbrecht Posts: 17 Bronze 2
    Are you talking about the connection properties tab in Enterprise Manager/SQL Management Studio or in the SQL Backup GUI?

    So far, it only seems to be SQL Backup monitoring that times out. Everything else is working fine.
  • Options
    In the SQL Backup GUI...
  • Options
    rgiesbrechtrgiesbrecht Posts: 17 Bronze 2
    Thanks, I finally found it (had to search under Edit when you right-click on the registered server) -- somewhat counter-intuitive.

    I will play with various timeout values to see what works best.
  • Options
    Thanks, I finally found it (had to search under Edit when you right-click on the registered server) -- somewhat counter-intuitive.

    I will play with various timeout values to see what works best.

    Oh boy.. I'm resurrecting a 2 yr old dead post. But I just hit this issue!

    Why can't we have a simple REFRESH ALL connections option?
Sign In or Register to comment.