Slowdown of interface

SQL Server performance monitoring and alerting

Moderators: eddie davis, priyasinha, Adam, chriskelly, Chris Lambrou, Chris Spencer

Slowdown of interface

Postby jonstahura » Mon Oct 22, 2012 5:35 pm

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?
jonstahura
 
Posts: 13
Joined: Fri Sep 28, 2012 2:28 pm

Postby mipe10 » Tue Oct 23, 2012 10:29 am

I have the same problem! I have registered a case to get some help.
mipe10
 
Posts: 46
Joined: Wed Nov 22, 2006 2:08 pm

Postby Brian Donahue » Tue Oct 23, 2012 12:07 pm

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
 
Posts: 6668
Joined: Mon Aug 23, 2004 10:48 am

Postby jonstahura » Tue Oct 23, 2012 8:24 pm

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..
jonstahura
 
Posts: 13
Joined: Fri Sep 28, 2012 2:28 pm

Postby mipe10 » Wed Oct 24, 2012 8:42 am

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.
mipe10
 
Posts: 46
Joined: Wed Nov 22, 2006 2:08 pm

Postby Brian Donahue » Wed Oct 24, 2012 10:31 am

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
 
Posts: 6668
Joined: Mon Aug 23, 2004 10:48 am

Postby mipe10 » Wed Oct 24, 2012 12:32 pm

The problem was chrome! Changes to explorer(64 bit) and the problem went away.
mipe10
 
Posts: 46
Joined: Wed Nov 22, 2006 2:08 pm

Postby jonstahura » Wed Oct 24, 2012 7:01 pm

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
jonstahura
 
Posts: 13
Joined: Fri Sep 28, 2012 2:28 pm

Postby jonstahura » Wed Oct 24, 2012 9:36 pm

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.
jonstahura
 
Posts: 13
Joined: Fri Sep 28, 2012 2:28 pm

Postby Chris Spencer » Thu Oct 25, 2012 11:49 am

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
Chris Spencer
 
Posts: 301
Joined: Tue Aug 29, 2006 9:09 am
Location: Red Gate - Cambridge

Postby jonstahura » Thu Oct 25, 2012 1:49 pm

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.
jonstahura
 
Posts: 13
Joined: Fri Sep 28, 2012 2:28 pm

Chrome reaaaalllyyy slow here also 3.1

Postby henkmeulekamp » Thu Oct 25, 2012 8:14 pm

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.
henkmeulekamp
 
Posts: 9
Joined: Tue May 09, 2006 5:56 pm

Postby Chris Spencer » Mon Oct 29, 2012 6:32 pm

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
Chris Spencer
 
Posts: 301
Joined: Tue Aug 29, 2006 9:09 am
Location: Red Gate - Cambridge

Postby Baguck » Wed Oct 31, 2012 2:47 pm

Thanks for the thread and bug - I am noticing similar results.
Baguck
 
Posts: 4
Joined: Thu Jul 26, 2012 7:47 pm
Location: USA - North Carolina

use firefox instead of IE

Postby Freman » Tue Nov 06, 2012 2:51 am

Firefox is much more fast than IE to SQL Monitor
Freman
 
Posts: 6
Joined: Thu Sep 13, 2012 7:33 am

Next

Return to SQL Monitor 3

Who is online

Users browsing this forum: No registered users and 0 guests