March 22, 2017 at 4:42 am
required ur help in one the issue I m facing.
We have an environment with active passive cluster with 4 sql reporting servers. there is process which generate reports for 1000 branches there is a procedure which runs and generate report (pdf format) on one of the report server. Issue in this is it generates the report for around 80 branches and then halt for 10 to 15 mins then it start the process again and then again it generates some report and the other halts for 10 to 15 mins it the reports gets generated for 1000 branches. No memory pressure or disk issue I have run the scenario with 100 branches but the issues was the same.so will like to know where shud I diggin.when it gets halt no active sessions are found.
March 22, 2017 at 5:02 am
Please don't post multiple threads for the same question.
No replies here please. Direct replies to https://www.sqlservercentral.com/Forums/1865935/Urgent-help-on-ssrs
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 22, 2017 at 7:16 am
GilaMonster - Wednesday, March 22, 2017 5:02 AMPlease don't post multiple threads for the same question.
No replies here please. Direct replies to https://www.sqlservercentral.com/Forums/1865935/Urgent-help-on-ssrs
I want some help from your experience gila I have never seen these type of issue
March 22, 2017 at 4:21 pm
I have last used reporting services 5 years ago and have barely touched clustering. I don't think my experience will help you in the slightest.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply