Slow site

Question

Slow site

Forum Etiquette: How to post Reporting Services problems

[/url]

Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
[/url]

How to Post Performance Problems - by Gail Shaw
[/url]

Sean Lange SSC Guru Points: 286573 More actions · Answer 1

robert.chipperfield (9/10/2015)
Sorry to hear that - we've not seen a repeat of the same packet loss we were seeing since it was fixed, so it feels like it must be unrelated.
If you can either drop a reply on this thread, or email me (I'm sure you can guess my @red-gate.com address from my SSC username!) while it's in go-slow mode for you, I'll do my best to jump on while it's happening, and see if I can dig into the cause.
Thanks,
Rob

Thanks Rob. We appreciate everything you and the rest of the team do to keep the site up and running. It does seem that I am not the only person experiencing really bad performance for the past 2-3 days. Let me know if there is anything I can do from my end to help you troubleshoot the issue.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

J Livingston SQL SSC Guru Points: 51550 More actions · Answer 2

Sean Lange (9/10/2015)
robert.chipperfield (9/10/2015)
Sorry to hear that - we've not seen a repeat of the same packet loss we were seeing since it was fixed, so it feels like it must be unrelated.
If you can either drop a reply on this thread, or email me (I'm sure you can guess my @red-gate.com address from my SSC username!) while it's in go-slow mode for you, I'll do my best to jump on while it's happening, and see if I can dig into the cause.
Thanks,
Rob
Thanks Rob. We appreciate everything you and the rest of the team do to keep the site up and running. It does seem that I am not the only person experiencing really bad performance for the past 2-3 days. Let me know if there is anything I can do from my end to help you troubleshoot the issue.

Rob ...I am based in the UK and I have not experienced the issues raised by Sean today (10/09/15)

the response from the site in last 10 days since you fixed the previous problem has been great and continues to be so...as far I as I am concerned.

not sure if this is of help......but thanks for all you guys do to keep this site running effectively.

regards JLS

________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day

Robert Chipperfield (Redgate) Ten Centuries Points: 1380 More actions · Answer 3

Thanks all.

Times (with timezone!) when it's particularly bad for you are definitely the most helpful bit in the first instance - then I can correlate them against logs, perf counters and network traffic graphs, and spot the patterns.

Thanks,

Rob

mister.magoo SSC-Forever Points: 47068 More actions · Answer 4

Anyone hear squeaking at around 1:16am (London time)?

I had a long delay when I clicked Reply on a thread, it felt like upwards of 30 seconds or so before the page loaded.

All seemed fine after that.

As a side note, there is a constant, repeated, failed attempt to GET http://www.sqlservercentral.com/Forums/tbl_spacer.gif happening on these pages - response code 403 - Forbidden.

MM

select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

mister.magoo SSC-Forever Points: 47068 More actions · Answer 5

And another ... over a minute to open a thread at about 01:26 (London) 12 sep 2015

MM

select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

Steve Jones - SSC Editor SSC Guru Points: 734449 More actions · Answer 6

Thanks, I'll get someone to take a look at the hosting provider.

Robert Chipperfield (Redgate) Ten Centuries Points: 1380 More actions · Answer 7

Morning all,

MM - that's an interesting graph, because the vast bulk of the time is the browser waiting before it tries to open the connection to the server, rather than the server actually taking a long time to respond once the request is fired off.

There's normally a limit of how many concurrent connections a browser will open to one server (6 in the case of Chrome, I think), which means there's probably another request in progress somewhere that's actually causing the problem. It might be on another SSC tab (I think the connection limit spans all tabs) if you have multiple open, or just another request a little earlier on the page that hasn't completed.

Out of interest, is it normally just the forums that are the problem, or the rest of the site as well?

Thanks,

Rob

mister.magoo SSC-Forever Points: 47068 More actions · Answer 8

Hi Robert,

I hadn't noticed that about the delay! I'll check next time whether there are multiple tabs open and check in another browser as well.

For me, yes, the problem only seems to be on the forums.

Thanks

MM

select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

Robert Chipperfield (Redgate) Ten Centuries Points: 1380 More actions · Answer 9

Hi MM,

Are you still seeing this, or has it calmed down again now?

Cheers,

Rob

mister.magoo SSC-Forever Points: 47068 More actions · Answer 10

I've not seen any problems lately, thanks.

MM

select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

Sean Lange SSC Guru Points: 286573 More actions · Answer 11

The speed issues seem to have been elusive for me too. Not sure what, if anything, you did but it seems to have helped.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Ant-Green SSC Guru Points: 113445 More actions · Answer 12

Site is slow for me today, taking a good 30 seconds to a minute to switch between topics and posting.

Just took 60 seconds to get to forum 433-1 and then 30 seconds into this thread with 30 seconds to get to the posting box.

Time was 9:07:28.955 according to fiddler

Steve Jones - SSC Editor SSC Guru Points: 734449 More actions · Answer 13

Still? Loading quickly now. Might have been transient issues while the newsletter was sending.