September 7, 2016 at 8:49 am
hi,
After running update statistics or sp_updatestats, my queries are getting very slow , please tel me what could be the reason,
yours sincerly
September 7, 2016 at 8:54 am
Once upon a time this happened to me. Turned out that the update statistics job was only sampling the tables and that for the queries to run better (like they used to) I had to update the statistics with a full scan. Took me ages to figure that one out. Not saying that this is definitely the case for you, but worth checking I would say.
September 7, 2016 at 9:32 am
Quick suggestion, use Ola Hallengren's index maintenance scripts, work like a charm.
😎
September 7, 2016 at 12:26 pm
Which query is slower?
sp_whoisactive to find currently-running stuff that is waiting/blocked.
Get a copy of Glenn Berry's SQL Server Diagnostic Scripts and use the goodness therein to find bad things.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
September 9, 2016 at 6:49 am
yes i think this was the reason
well some body said DBCC UPDATEUSAGE (0); is also needed, is it correct?
September 9, 2016 at 7:32 am
rajemessage 14195 (9/9/2016)
yes i think this was the reasonwell some body said DBCC UPDATEUSAGE (0); is also needed, is it correct?
That should not be needed on modern versions of SQL Server.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
September 10, 2016 at 5:52 am
This was removed by the editor as SPAM
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply