Viewing 12 posts - 1 through 12 (of 12 total)
So this the script is returning a snapshot at the time the script is executed. Is this correct?
July 9, 2014 at 7:27 am
Very nice script. Is there a way to break down the script for date ranges (ie last week, this month, this year)?
Thanks
July 8, 2014 at 7:23 am
I checked the execution plan on the production server as well and I am seeing close to the same values for this query.
The full database statistics updates have finished and...
August 1, 2013 at 3:41 pm
Would you suggest adding the Update Statistics Task to my maintenance plan that backs up the full database every night?
August 1, 2013 at 2:58 pm
I've updated the statistics on all of the underlying tables and the estimated rows are at 207077. Any other suggestions? I've attached the new .sqlplan.
BTW, all of these...
August 1, 2013 at 2:43 pm
Thanks again.
Is the goal to get the actual number of rows and estimated number of rows to be equal?
Donnie
August 1, 2013 at 2:26 pm
Awesome! Thanks Lowell. The 3 tables you mentioned are actually views. I'm guessing I should actually update the statistics on the tables included in the views. ...
August 1, 2013 at 2:20 pm
The plan was running on our staging server, which has most of the data.
My web server monitoring was indicating that this query was taking a long time during the heavy...
August 1, 2013 at 2:05 pm
Here is the .sqlplan for the one of the queries that I anticipate may be causing a bottle neck as it is referenced on every request.
August 1, 2013 at 1:05 pm
Thanks for the quick responses. What is a .sqlplan? Is it the estimated execution plan from ssms?
August 1, 2013 at 12:31 pm
Thanks.
I suspect locking because we had a client run a test against the web application and we got very poor response times for a low number of...
August 1, 2013 at 12:04 pm
Viewing 12 posts - 1 through 12 (of 12 total)