Viewing 15 posts - 15,001 through 15,015 (of 49,552 total)
Since it's not usually a major issue, and can't be fixed while SQL's running, and it pretty immaterial on a SAN, not really.
But it you want. Google: file system fragmentation
It's...
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
January 3, 2013 at 7:33 am
Never heard the term 'data fragmentation'. Guess the person meant index fragmentation, because data can only be fragmented when it's in an index. (unless they meant data file fragmentation, which...
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
January 3, 2013 at 6:11 am
Restore from a good backup
And do some investigation of that IO subsystem, maybe move the DB elsewhere (different disks)
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
January 3, 2013 at 6:00 am
Post the output you got (everything). I can't tell anything from a description of the messages. (no, not with tablock)
Repair is not the recommended way to fix corruption, it's for...
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
January 3, 2013 at 12:56 am
kevin.kembel (1/2/2013)
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
January 2, 2013 at 4:38 pm
opc.three (1/2/2013)
GilaMonster (1/2/2013)
opc.three (1/2/2013)
Are you thinking of reorganize?
No.
I thought a rebuild would re-scan the clustered same as a drop+recreate which would work since all inconsistencies were found in the...
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
January 2, 2013 at 4:11 pm
DB_Newbie2007 (1/2/2013)
Full backups are done weekly and log backups daily.
Daily? So up to 24 hours of data loss is acceptable?
Log backups are usually a lot more frequent than that,...
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
January 2, 2013 at 3:46 pm
RAM-only table-variables are indeed a myth.
Table variables (like temp tables) will be in memory if possible and written to disk if not. They are always allocated space in TempDB, whether...
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
January 2, 2013 at 3:43 pm
CheckDB doesn't check the log file, so it wouldn't pick up the corruption.
Usual solution given for this case:
Restore a backup, full, and logs
Or, if you don't have backups (or can't...
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
January 2, 2013 at 11:44 am
opc.three (1/2/2013)
Are you thinking of reorganize?
No.
I thought a rebuild would re-scan the clustered same as a drop+recreate which would work since all inconsistencies were found in the nonclustered index.
Nope....
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
January 2, 2013 at 11:34 am
Read the article again.
If your log is continually growing it's because you're mis-managing it. Most likely full recovery model with no log backups. Read the article, make sure you have...
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
January 2, 2013 at 11:29 am
Please read through this - Managing Transaction Logs[/url]
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
January 2, 2013 at 8:16 am
Don't rebuild the index. It'll likely fail. Drop the index and recreate it.
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
January 2, 2013 at 8:04 am
ChrisM@Work (1/2/2013)
May 2013 bring you excitement, enlightenment and all the rewards you deserve.
Why do I have to wait til May?
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
January 2, 2013 at 6:56 am
Restore from a clean backup, that's not repairable in any way.
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
January 2, 2013 at 6:27 am
Viewing 15 posts - 15,001 through 15,015 (of 49,552 total)