Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 UPDATE STATISTICS

Author  Topic 

pdset
Constraint Violating Yak Guru

310 Posts

Posted - 2014-11-27 : 20:53:06
We have changed in the Connection String with new Setting with URL along with it is PORT and as a result it has ran with these NEW SETTINGS with more time consuming.

So it was coined perhaps the statistics part has to be run in order to speed up the things for this new setting.

Could anyone explain the purpose of Running UPDATE STATISTICS and how it effects for the new setting.
Cheers.

Shanky
Yak Posting Veteran

84 Posts

Posted - 2014-11-28 : 07:28:17
Its big thing you are asking. Please read this article http://technet.microsoft.com/en-us/library/dd535534%28v=sql.100%29.aspx how sql server uses statistics for query plan. Simply if stats are not upto date SQL Server will prepare a bad plan and query which should complete in seconds might take minutes. One should keep stats most up to date so that SQL Server optimizer can prepare cost effective plan

Hope this helps

Regards
Shanky
SQL Server MVP
http://social.technet.microsoft.com/wiki/contents/articles/24253.list-of-articles-by-shanky.aspx
Go to Top of Page

pdset
Constraint Violating Yak Guru

310 Posts

Posted - 2014-12-01 : 16:46:36
Thanks Shanky
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-12-01 : 16:48:56
I don't see how statistics are related to the new settings of the connection string. The SET options impact execution plans, but not adding a port.

Have you compared execution plans before/after the change?

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

pdset
Constraint Violating Yak Guru

310 Posts

Posted - 2014-12-02 : 21:39:41
Execution Plans have impacted as a result of changing the PORT and New Web Address. So just confirming should the UPDATE STATISTICS will relieve the enhanced times - is all my question.

Thanks
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-12-03 : 12:08:13
quote:
Originally posted by pdset

Execution Plans have impacted as a result of changing the PORT and New Web Address. So just confirming should the UPDATE STATISTICS will relieve the enhanced times - is all my question.

Thanks



If the issue is with out-of-date statistics, then yes updating stats will help. However, you may be able to just recompile the offending stored procs or clearing the cache (if lots of stored procs/queries are impacted).

But your question was asked a few days ago. The problem is resolved already, right?

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -