August 1, 2011 at 11:24 am
Unfortunately I can't get the space. We are playing with going out and getting some external drives to do some of this. Hopefully that will work.
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
August 1, 2011 at 11:25 am
sjimmo (8/1/2011)
Unfortunately I can't get the space. We are playing with going out and getting some external drives to do some of this. Hopefully that will work.
That's just what I had in mind. Nothing fancy, maybe just a small nas with 10K RPM disks. Shouldn't cost 100K to do that.
August 1, 2011 at 11:25 am
How to make sure whether auto update statistics is ON in rebuilding index step?
August 1, 2011 at 11:28 am
How to make sure Autoupdate statistics is ON in Rebulding index step
August 1, 2011 at 11:29 am
clarification (8/1/2011)
How to make sure whether auto update statistics is ON in rebuilding index step?
Just check at the db level :
SELECT * FROM sys.databases
Then stats level :
SELECT * FROM sys.stats
Auto-update will kick in when rebuilding the indexes. But you'll need to manually kick it in for stats that are not part of those indexes.
August 1, 2011 at 11:32 am
how do we know which stats are not part of indexes?
August 1, 2011 at 11:36 am
The name will match the index. Then
http://msdn.microsoft.com/en-us/library/ms177623(v=SQL.100).aspx
August 5, 2011 at 3:12 am
>As for "His maint is also set up to do checkdb against the entire db or just the pieces that have changed."
The integrity check stored procedure does not have any logic to only check the parts of the database that has changed. I am not sure how that would work.
The integrity check stored procedure supports the options PHYSICAL_ONLY and NOINDEX. This can be useful if you have a large database and a small maintenance window.
http://ola.hallengren.com/sql-server-integrity-check.html
Ola Hallengren
August 5, 2011 at 5:43 am
Ola Hallengren (8/5/2011)
>As for "His maint is also set up to do checkdb against the entire db or just the pieces that have changed."The integrity check stored procedure does not have any logic to only check the parts of the database that has changed. I am not sure how that would work.
The integrity check stored procedure supports the options PHYSICAL_ONLY and NOINDEX. This can be useful if you have a large database and a small maintenance window.
http://ola.hallengren.com/Documentation.html#DatabaseIntegrityCheck
Ola Hallengren
Thanks for clarifying. I couldn't really imagine how that would have been coded anyways :hehe:.
Viewing 9 posts - 16 through 23 (of 23 total)
You must be logged in to reply to this topic. Login to reply