Viewing 15 posts - 21,751 through 21,765 (of 49,552 total)
Henry_Lee (12/13/2011)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 13, 2011 at 7:37 am
And run DBCC UpdateUsage please. Negative free space is a bit silly.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 13, 2011 at 7:25 am
jacobbdrew (12/13/2011)
Bummer. Any particular reason I should do this on 2000?
Simplicity. It'll likely work fine on 2008, but with schema corruption like this it's probably safer to keep things...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 13, 2011 at 3:51 am
forsqlserver (12/13/2011)
How much tempdb size will grow how would I know?
How long is a piece of string? You can use the CheckDB option Estimate_Only, but I recall there's a known...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 13, 2011 at 2:04 am
Barkingdog (12/12/2011)
(I have a feeling that indexing should be done only as needed and not as part of a scheduled maintenance plan).
Indexing (creating or modifying indexes) should be done as...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 13, 2011 at 1:55 am
jacobbdrew (12/12/2011)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 13, 2011 at 1:53 am
If you're running full checkDB, no.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 13, 2011 at 1:50 am
Take the shrink out, it's massively fragmenting your indexes right before rebuilding them (and growing the DB in the process). Talk about a waste of effort.
Make sure the stats update...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 12, 2011 at 1:46 pm
If they selected all options, then you have bigger problems than just index rebuilds.
Are they shrinking, rebuilding and reorganising, updating all statistics instead of just column stats?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 12, 2011 at 1:38 pm
Index rebuilds.
They're fully logged in full recovery and the log space used will be > the size of the index rebuild, hence the log backups will be as well. (bulk...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 12, 2011 at 12:59 pm
One way is looking in the SQL error log. One of the earlier messages in the current log will state which node the service is running on.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 12, 2011 at 10:09 am
Please have a read through this: http://www.sqlservercentral.com/articles/Transaction+Log/72488/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 12, 2011 at 9:45 am
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 12, 2011 at 9:35 am
Portion in one, portions in the other. If you want the details, read up on proportional fill (it's how SQL allocates pages when there's more than one file in a...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 12, 2011 at 9:34 am
SKYBVI (12/12/2011)
Ninja's_RGR'us (12/12/2011)
Except for all the stats that are not updated by the index rebuild. Which is usually a lot of them 😉Ya but mostly it will be redundunt.
Disagree....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 12, 2011 at 8:58 am
Viewing 15 posts - 21,751 through 21,765 (of 49,552 total)