Viewing 15 posts - 12,121 through 12,135 (of 49,552 total)
Wait. Do not restart SQL (the roll back will just continue with the DB unavailable). Check what the shrink process is waiting 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
August 14, 2013 at 5:07 am
Do not kill the process from Windows. There's an MSDN blog somewhere (will find when I get home if you like) that discusses what can happen in that case and...
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
August 14, 2013 at 5:07 am
Why are you partitioning? What's the intended goal?
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
August 14, 2013 at 5:00 am
If you want to drop an index at the subscriber, go to the subscriber and drop the index. Make sure that you don't adversely affect the subscriber's workload by doing...
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
August 14, 2013 at 4:58 am
Unless the database is in full recovery and there was a full backup taken at some point prior to the delete, there won't be anything in the log to analyse.
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
August 14, 2013 at 4:52 am
Please post table definition, index definitions and execution plan as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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
August 14, 2013 at 12:46 am
That's how the index rebuild is executed behind the scenes
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
August 13, 2013 at 2:23 pm
Possibly related to this
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
August 13, 2013 at 1:38 pm
Why is the log growing? Logs should reach a steady spot where they don't grow any further, so what is causing your log to grow continuously?
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
August 13, 2013 at 9:48 am
Did you read the articles?
Any suggestions on exactly what specifically (since the articles explain log reuse and reasons why it might not be reused)?
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
August 13, 2013 at 9:39 am
If you have this problem, open a case with CSS. Data purity errors should not ever happen in the system tables.
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
August 13, 2013 at 9:38 am
Unless you have a really good reason otherwise, leave min server memory at default. 14.25GB is a little high on a 16 GB box. I'd usually start at 12...
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
August 13, 2013 at 9:35 am
HildaJ (8/13/2013)
However, if I removed this option how am I suppose to repair any errors if found? I guess manually?
By restoring a clean backup. Repair is usually 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
August 13, 2013 at 9:35 am
ctrlb (8/13/2013)
I do not believe it's uncorrectable corruption. http://support.microsoft.com/kb/923247 shows how to fix the error.
That support article explains how to fix the error in user tables. The table in question...
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
August 13, 2013 at 9:09 am
Let me guess, the index is 4 pages in size (at the leaf level)?
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
August 13, 2013 at 8:29 am
Viewing 15 posts - 12,121 through 12,135 (of 49,552 total)