Viewing 15 posts - 46,636 through 46,650 (of 49,552 total)
Depends what the column says. It gives you the reason the log is not been reused.
Typical things I've seen - Replication, backup, active transaction, mirroring.
Each needs to be treated differently.
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 9, 2008 at 12:00 am
I've also seen it bring the system to an absolute halt during an auto grow.
You're right on the dropped obejcts. While I've seen Ghost cleanup tidying up after a drop,...
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 8, 2008 at 11:55 pm
Excellent. Thank you.
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 8, 2008 at 11:53 pm
Marios Philippopoulos (5/8/2008)
Gail, thanks for the info, I've wondering about this for quite some time...
Don't take it as authoritative, since I can't remember the source.
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 8, 2008 at 11:35 am
I seem to recall reading somewhere that MAXDOP limited the number of running threads, not the total number of threads overall that a query could spawn.
If that's correct, then with...
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 8, 2008 at 11:08 am
Do you not have a backup?
There is a way, but it will cause data loss. No idea how much, or from which table.
Please run the following...
DBCC CHECKDB('msdb') WITH NO_INFOMSGS
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 8, 2008 at 10:41 am
What's the most recent backup you have for MSDB?
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 8, 2008 at 10:12 am
Thanks. I'll check them out.
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 8, 2008 at 10:08 am
TheSQLGuru (5/8/2008)
2. Functions can result in poor performance.3. Functions can result in REALLY REALLY BAD performance. 🙂
6. Did I mention that functions are often bad for performance?? 😀
Especially...
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 8, 2008 at 10:02 am
Probably early-mid June for the full session list. Probably spotlights earlier.
End of May is the date they gave for feedback on submitted abstracts.
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 8, 2008 at 9:33 am
What are the blocks/waits on? What wait type? What resource?
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 8, 2008 at 8:45 am
Storage take blame for a poorly performing database? What universe are you in? 😉
That's my worst fear, and it's something I've had before. A datawarehouse load that was using 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
May 8, 2008 at 8:35 am
As a suggestion - first copy the back up files locally, then do the restore.
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 8, 2008 at 6:55 am
Thanks. I'll check that out when I get home.
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 8, 2008 at 6:42 am
Database backups do not truncate the trasnaction log. They back up enough of the log to ensure that the backup is consistent when restored.
Only a transaction log backup truncated 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
May 8, 2008 at 6:41 am
Viewing 15 posts - 46,636 through 46,650 (of 49,552 total)