Viewing 15 posts - 30,406 through 30,420 (of 49,552 total)
No idea, because I'm still not sure what you're referring to.
Suspended is not a state for a database. (Online, restoring, recovering, recovery_pending, suspect, emergency and offline are)
Where did you see...
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
September 23, 2010 at 5:02 am
Niyala (9/23/2010)
I now configured the log autogrowth by 10% and unrestricted.Is it better to set fixed growth than unrestricted?
Percentage growth is usually not recommended. Pick an appropriate fixed value. 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
September 23, 2010 at 3:52 am
Could you possibly post the plans as .sqlplan files? http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Are you sure you want a nested loop join? It is not always the best join type.
http://sqlinthewild.co.za/index.php/2009/11/24/the-most-optimal-join-type/
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
September 23, 2010 at 3:50 am
Where are you seeing that status?
What errors/messages are you seeing?
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
September 23, 2010 at 3:40 am
I suspect it has to do with the limited size of the log, the duration of the backup and the activity.
Because the full backup needs to include all of 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
September 23, 2010 at 3:37 am
The second one's irreparable. System table damaged (which one I can't tell). It may be possible to script and export to partially recover that one, depending which system table 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
September 23, 2010 at 3:03 am
Run DBCC SQLPERF(LogSpace), see what the % used is.
How big's the log? Is there a max size set for it? Is it on a drive with little free space?
How long...
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
September 23, 2010 at 2:40 am
ALZDBA (9/23/2010)
So I advised them to contact MS PSS and see if they can help out.
Tell them not to waste their time/money. PSS is unlikely to be able to help....
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
September 23, 2010 at 2:34 am
Simple recovery does not mean that the log will not grow. It does not mean that the log will never fill. It only means that log backups are not required...
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
September 23, 2010 at 2:29 am
Dave Ballantyne (9/23/2010)
But his results did get better after removing 90% of the data.
Yeah, surprising that. (not)
I must add that to my optimisation advice. "Try adding this index. If 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
September 23, 2010 at 2:24 am
Paul White NZ (9/22/2010)
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
September 23, 2010 at 1:47 am
4GB is not particularly large for a log file for an 80GB database. Why are you finding it hard to manage?
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
September 23, 2010 at 1:43 am
a.shahnazi (9/22/2010)
with bulk logged recovery mode, I lost point in time recovery
Only if you're trying to restore to a log interval that had a bulk operation in 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
September 22, 2010 at 11:48 pm
Adiga (9/22/2010)
The recovery model can be set to BULK LOGGED
Got a reference that indicates that stats updates are minimally logged? I don't see them listed under "Operations That Can Be...
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
September 22, 2010 at 11:47 pm
There's no way to turn logging off for any operation in SQL. Everything has to be logged. That said, stats updates shouldn't log very much. That's why I'm wondering if...
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
September 22, 2010 at 11:46 pm
Viewing 15 posts - 30,406 through 30,420 (of 49,552 total)