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.
| 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 planHope this helpsRegardsShankySQL Server MVPhttp://social.technet.microsoft.com/wiki/contents/articles/24253.list-of-articles-by-shanky.aspx |
 |
|
|
pdset
Constraint Violating Yak Guru
310 Posts |
Posted - 2014-12-01 : 16:46:36
|
| Thanks Shanky |
|
|
|
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 KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
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 |
|
|
|
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 KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
UPDATE STATISTICS