Viewing 15 posts - 1 through 15 (of 164 total)
opc.three (9/3/2013)
Sergei Zarembo (9/3/2013)
in other words, the modiication should execute fast, correct?Thanks, Gail.
Yes. Provided it is not being blocked it will complete practically instantaneously.
Thank you for your feedback, opc.three.
September 4, 2013 at 7:26 am
in other words, the modiication should execute fast, correct?
Thanks, Gail.
September 3, 2013 at 4:34 pm
AlexSQLForums (2/11/2013)
on s2 there is more data then on s1 so chances are some kind of an aggregate function in your sp could slow it down.
Alex,
what tells you that S2...
February 14, 2013 at 3:21 pm
on S1
<AdditionalInfo>
<ProcessingEngine>2</ProcessingEngine>
<ScalabilityTime>
<Pagination>0</Pagination>
<Processing>0</Processing>
</ScalabilityTime>
<EstimatedMemoryUsageKB>
<Pagination>35</Pagination>
<Processing>83</Processing>
</EstimatedMemoryUsageKB>
<DataExtension>
...
February 6, 2013 at 2:24 pm
yes , the difference betw TimeStart and TimeEnd =~ 40 sec in both cases:
on S1
TimeStart2013-02-05 15:07:26.037
TimeEnd2013-02-05 15:08:10.15727734
TimeDataRetrieval:27734
TimeProcessing: 48
TimeRendering: 60
on S2
TimeStart :2013-02-05 15:42:59.293
TimeEnd :2013-02-05 15:43:40.430
TimeDataRetrieval :28451
TimeProcessing: 58
TimeRendering : 207
the numbers are...
February 6, 2013 at 2:11 pm
@SQLFRNDZ (2/6/2013)
Does S1 and S2 has same configuration of RAM, CPU, traffic and NETWORK Speed ? all of these makes a difference too
S2 [slow one] has actually has more...
February 6, 2013 at 12:55 pm
AlexSQLForums (2/6/2013)
Can you delete S2 report and copy S1 .rdl file to S2 and relink it to the data source and run it?
Alex,
By *copying rdl* you really mean deploying it...
February 6, 2013 at 12:49 pm
As always the case with matching/parsing tasks, it's helpful to actually see the real data to be able to offer a meaningful solution/advise.
If you cannot expose sensitive data, can you...
February 6, 2013 at 9:12 am
THANKS everyone for your help,
thread is closed.
October 16, 2012 at 1:47 pm
my DBA got me confused again, he is telling me:
***You should be creating your temp tables within the user database and not within the ‘tempdb’ database.***
I guess at the moment...
October 16, 2012 at 1:24 pm
Thank you , that explains it.
October 16, 2012 at 10:57 am
Vedran, DiverCast
thank you very much for your responses, it helps.
October 12, 2012 at 2:04 pm
this book
http://www.amazon.com/Server-Query-Performance-Tuning-Distilled/dp/1590594215
has a lot of buzz words on the topic.
October 12, 2012 at 11:03 am
Thank you for your answers. I read what MSDN has on it before. I was hoping to get some info on other metrics people use to estimate load on...
October 12, 2012 at 10:11 am
Thank you for your response, rVadim. I do have some contention on the box that runs SSRS. Some huge QlikView application lives there as well. I need to think of...
August 14, 2012 at 1:51 pm
Viewing 15 posts - 1 through 15 (of 164 total)