| Author |
Message |
jonstahura
Joined: 28 Sep 2012 Posts: 11
|
Posted: Mon Oct 22, 2012 5:35 pm Post subject: Slowdown of interface |
|
|
I have 8 servers on my sql monitor.
The response time has slowed down SO much.
When I try to open alerts from the inbox, it takes 30 or more seconds to open.
Is there a reason for this? Can I speed this up? |
|
| Back to top |
|
 |
mipe10
Joined: 22 Nov 2006 Posts: 45
|
Posted: Tue Oct 23, 2012 10:29 am Post subject: |
|
|
| I have the same problem! I have registered a case to get some help. |
|
| Back to top |
|
 |
Brian Donahue
Joined: 23 Aug 2004 Posts: 6347 Location: Red Gate Software
|
Posted: Tue Oct 23, 2012 12:07 pm Post subject: |
|
|
I've sent some debugging steps - basically this is not the kind of thing we can answer without detailed information about the base monitor and website processes.
If you have lots of users connecting to the website (more than 10) you may want to upscale to IIS if you're using the built-in web server. _________________ Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521 |
|
| Back to top |
|
 |
jonstahura
Joined: 28 Sep 2012 Posts: 11
|
Posted: Tue Oct 23, 2012 8:24 pm Post subject: |
|
|
well it is just me.... so i don't see users being an issue.
I was doing some testing.. it seems that if I remote into the monitor server and open a browser to localhost... it is WAY WAY faster...
Everything else seems to run ok... just the alerts take FOREVER.. |
|
| Back to top |
|
 |
mipe10
Joined: 22 Nov 2006 Posts: 45
|
Posted: Wed Oct 24, 2012 8:42 am Post subject: |
|
|
Hi,
I can confirm what jonstahura is saying about the local login and execution on the actual machine containing the installation. It's lightning fast compared to remote connection. |
|
| Back to top |
|
 |
Brian Donahue
Joined: 23 Aug 2004 Posts: 6347 Location: Red Gate Software
|
Posted: Wed Oct 24, 2012 10:31 am Post subject: |
|
|
Seems to implicate your network connection. None of RedGate's code is going to care if the requester is local or remote.
I'm aware also that the Javascript is quicker on some browsers than others. _________________ Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521 |
|
| Back to top |
|
 |
mipe10
Joined: 22 Nov 2006 Posts: 45
|
Posted: Wed Oct 24, 2012 12:32 pm Post subject: |
|
|
| The problem was chrome! Changes to explorer(64 bit) and the problem went away. |
|
| Back to top |
|
 |
jonstahura
Joined: 28 Sep 2012 Posts: 11
|
Posted: Wed Oct 24, 2012 7:01 pm Post subject: |
|
|
i will test it with IE to see if i have the same results..
i also have been using chrome... i hate using IE.. this is the 3rd application in my company that "FORCES" me to use IE.. grrr
although the commercial song for IE is catchy... lol |
|
| Back to top |
|
 |
jonstahura
Joined: 28 Sep 2012 Posts: 11
|
Posted: Wed Oct 24, 2012 9:36 pm Post subject: |
|
|
i hate to say it.. but ti works...
something must be happening in chrome... .. so depressing... IE is nice and snappy compaired.. i have not had ANY of the wait time that hasbuilt up in chrome. |
|
| Back to top |
|
 |
Chris Spencer
Joined: 29 Aug 2006 Posts: 300 Location: Red Gate - Cambridge
|
Posted: Thu Oct 25, 2012 11:49 am Post subject: |
|
|
I'm not seeing any issues with Chrome internally, monitoring 10 servers. We fully support this browser and in general get far less issues with it than we do with IE. I'll keep an closer eye on Chrome to see if I can reproduce this issue.
If you have an aversion to IE then SQL Monitor also works with Firefox, Safari and Opera.
Regards
Chris _________________ Chris Spencer
Test Engineer
Red Gate |
|
| Back to top |
|
 |
jonstahura
Joined: 28 Sep 2012 Posts: 11
|
Posted: Thu Oct 25, 2012 1:49 pm Post subject: |
|
|
i can consistently recreate the issue. If you would like to do a remote or something to see if you can track something down, i would be willing to be a test bunny.
It really creates a wait when opening up alerts. |
|
| Back to top |
|
 |
henkmeulekamp
Joined: 09 May 2006 Posts: 9
|
Posted: Thu Oct 25, 2012 8:14 pm Post subject: Chrome reaaaalllyyy slow here also 3.1 |
|
|
And on your advice tested with IE9 (win7) and its fast.
Definitively an issue with chrome and Sql Monitor web app.
It is especially when hitting the alerts tab and opening an alert.
We only have 3 monitored servers, sql monitor on a complete separate infra. |
|
| Back to top |
|
 |
Chris Spencer
Joined: 29 Aug 2006 Posts: 300 Location: Red Gate - Cambridge
|
Posted: Mon Oct 29, 2012 6:32 pm Post subject: |
|
|
A quick update to say that I'm now seeing this issue in Chrome and have raised a bug (ref: SRP-7768).
We'll look into this and hopefully improve performance in a future release. In the meantime IE9 and Firefox are definitely a better choice for Alert Inbox work.
Many thanks
Chris _________________ Chris Spencer
Test Engineer
Red Gate |
|
| Back to top |
|
 |
Baguck
Joined: 26 Jul 2012 Posts: 4 Location: USA - North Carolina
|
Posted: Wed Oct 31, 2012 2:47 pm Post subject: |
|
|
| Thanks for the thread and bug - I am noticing similar results. |
|
| Back to top |
|
 |
Freman
Joined: 13 Sep 2012 Posts: 4
|
Posted: Tue Nov 06, 2012 2:51 am Post subject: use firefox instead of IE |
|
|
| Firefox is much more fast than IE to SQL Monitor |
|
| Back to top |
|
 |
|