Viewing 15 posts - 18,451 through 18,465 (of 49,552 total)
Check your IO throughput. Sounds like the drive is not responding as it should.
Index physical stats doesn't run showcontig, more the other way around. Showcontig is deprecated and just runs...
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
May 23, 2012 at 10:42 am
No effect. Log backups will not affect any form of normal database activity or maintenance
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
May 23, 2012 at 5:15 am
A simple view won't cause an update to the table to be slow. If the view is indexed, maybe.
Can you post the code and execution plan of the 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
May 23, 2012 at 4:01 am
The remaining database will be marked as in the middle of a restore and will be unusable. You'd have to restart the restore and complete it to access the database.
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
May 23, 2012 at 3:58 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
May 23, 2012 at 3:30 am
dwain.c (5/22/2012)
Stefan Krzywicki (5/22/2012)
Lynn Pettis (5/22/2012)
If people would just format their code they could figure out some of their own problems. Geez.
Many should format it all at once, like...
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
May 23, 2012 at 3:25 am
For this scenario - 4GB memory, option 2.
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
May 23, 2012 at 2:39 am
It's fine as a once-off, you just didn't mention that you'd done 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
May 22, 2012 at 2:53 pm
MarkThornton (5/22/2012)
And the log file is now down to 235 MB, when it was >4GB in size an hour ago!
What? The actual size of the log file on disk? 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
May 22, 2012 at 2:38 pm
Good, now you should be able to shrink your log to a sensible size.
Doesn't explain what happened though. Are you sure that the log backups were running and were running...
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
May 22, 2012 at 2:34 pm
Delete data from the table. That's the only reliable way to reduce the size of the data in the table, which is what page count is.
Why are you fixated 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
May 22, 2012 at 2:28 pm
If the log backups are succeeding, that's not the root cause. Check again, see if there's another reason for the log to 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
May 22, 2012 at 2:22 pm
Check that your log backups are running then. if the log has been growing, it suggests that the log backups haven't been running at all.
Wait for the next log backup...
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
May 22, 2012 at 2:19 pm
Reduce what? Fragmentation or page count?
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
May 22, 2012 at 2:17 pm
No it does not. If your log backups are failing or the full backup is still running however...
Please read through that article and identify what is preventing the log from...
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
May 22, 2012 at 2:12 pm
Viewing 15 posts - 18,451 through 18,465 (of 49,552 total)