View Complete Post
Here is my problem,
I have an sp to retrieve max 1000 records(from joining 6 diff tables & conditions too).
suddenly a bulk amount (millions)of records inserted to the tables.
Here is the statistics of the sp executed in an order :[any way result will be top 1000]
0 seconds for querying a dept of 10500 records without extra parameters.
0 seconds for querying a dept of 10500 records with extra parameters.
4 seconds for querying a dept of 700500 records without extra parameters.
8 seconds for querying a dept of 700500 records with extra parameters.
now the problem starts
3 minutes for querying a dept of 700500 records without extra parameters.[which previously executed in 4 seconds.]
Thanks for looking into this,
Any solution/suggestion will help me to recover from mental stress :(
When I ran this query from SQL 2000 it takes 1 second. now in SQL 2008 R2 the same query is 20 times slower.
This is the query and the numer of records and the time in SQL 2008 R2:
SELECT * FROM dbo.CxP_Saldos
0 seconds, 923 Rows
SELECT * FROM S_Conta.Cuentas
0 seconds, 662 Rows
SELECT * FROM S_Conta.Cuentas c INNER JOIN dbo.CxP_Saldos s ON c.id = s.CtaProv
18 seconds, 923 Rows
how can I submit the actual execution Plan?
I have a report i have developed in Bids sourcing from AS cube. Whe I execute the report inside BIDS, i get the results within couple of seconds. But when i run the same report from Report Manager Site, It process for a long time and then generate the following
error. Any ideas gues?
An error occurred during client rendering. An error has occurred during report processing. An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database.Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is not responding.
If we installed Time card management template in share point 2007 By default it will be working (work flow) right?
Otherwise we have to configure anything?
If i try this workflow message is failed to start
We have the case where in a reporting solution for an application it was decided to build a series of reporting views, fair enough. These views are layered, nested several levels deep at times and, not unexpectedly, as our customer's data grows so these
To complicate matters further, the report SQL may then join several of these top level reporting views to produce the data it needs.
In a recent support request for a slow performing report we ripped the sql out of the report, pasted it into SSMS and while investigating found a join error in the reports SQL that took execution time from ~ 2 minutes down to about 6 seconds... Regardless
of what we did after that we were unable to reduce the time below 6 seconds using our reporting views. Rewriting the SQL against our base tables takes a fraction of a second to return the needed information.
What I need to do is demonstrate where the extra time in getting the results from the views is spent. My guess is that it is in untangling all the views and then ending up with a less than optimal query plan. Is there anyway to measure how long it
takes the server to "unpack" the nested views into a single SQL statement before it can be executed? Knowing how much of the 6 seconds this is accounting for would be helpful to us in our decision making process.
I need to send a reminder to the person whom a task has been assigned 3 days before a due date. We also wants to re-use this workflow/time job on other lists as well. Name of the lists can be different??
Also if the due date gets change it should change the reminder accordingly.
Which approach i should take to achieve this??
I have a little question about settings specific today (Date + Time) value to a field/column within a workflow that is designed by Sharepoint Designer 2007.
I can manage to set the field to today() => but the time is always 00:00 houres.
I would like toÃÂ set a specific field to the "exact" date+time when the workflow is running. (so choosing a fixed date+fixed Time isn't a solution either)
So I anyone could help me how I can do such "simple" task, I would be very pleased.