May 17, 2016 at 6:40 am
Thanks for the script.
March 1, 2018 at 6:32 am
mgigani-696113 - Wednesday, February 23, 2011 9:08 AMI have a question.Does this statistics persist after a SQL Server service restart? or server reboot etc.
Hi Mgigani,
Of course, if you restart the sql service you continue to have statistics because it is a persistant infomation.
March 6, 2018 at 11:13 am
harriga.rabie-1008938 - Thursday, March 1, 2018 6:32 AMmgigani-696113 - Wednesday, February 23, 2011 9:08 AMI have a question.Does this statistics persist after a SQL Server service restart? or server reboot etc.Hi Mgigani,
Of course, if you restart the sql service you continue to have statistics because it is a persistant infomation.
This is incorrect. Index statistics will reset if the underlying index is rebuilt "ALTER INDEX ... REBUILD", but not with "ALTER INDEX ... REORG". All index stats will clear if you restart SQL Server services.
March 6, 2018 at 11:32 am
mgigani-696113 - Wednesday, February 23, 2011 9:08 AMI have a question.Does this statistics persist after a SQL Server service restart? or server reboot etc.
No, the stats reset.
Viewing 4 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply