Viewing 15 posts - 24,406 through 24,420 (of 49,552 total)
Ninja's_RGR'us (8/5/2011)
How do you define seldom and what's the "usual" delay to bring it back online (ms or s)?
The same way I define 'often', 'most', etc. Relative to what else...
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 5, 2011 at 9:41 am
Ninja's_RGR'us (8/5/2011)
GilaMonster (8/5/2011)
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 5, 2011 at 9:35 am
What on earth is usp_delete_update_insert doing that it's over 3000 lines long?
The problematic code is around line 49 and line=3497. You've changed the table names, so I can't comment further...
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 5, 2011 at 9:34 am
btw, if you're getting that in the middle of the day it means that the database closed and SQL opened it again. That's only printed when SQL brings a DB...
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 5, 2011 at 9:27 am
Sailor (8/5/2011)
Date8/4/2011 10:43:05 AM
LogSQL Server (Current - 8/5/2011 9:25:00 AM)
Sourcespid76s
Message
CHECKDB for database 'bigdb' finished without errors on 2011-07-28 00:02:57.417 (local time). This is an informational message only; no user action...
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 5, 2011 at 9:21 am
Rhox (8/5/2011)
I will manualy change the recovery model to simpel and manualy rebuild the index on the best time (of the week).
No. Don't switch to simple. It gives you nothing...
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 5, 2011 at 6:28 am
Rhox (8/5/2011)
crashdan (8/5/2011)
also: No...
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 5, 2011 at 6:25 am
Ninja's_RGR'us (8/5/2011)
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 5, 2011 at 6:24 am
Rhox (8/5/2011)
Does a rebuild index keeps its transactions in the log till it's ended (commited) so the log can't be emptied (free space created)?
Yes. Index rebuilds are done as 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 5, 2011 at 6:09 am
Yes if could, in which case you need more disk space.
To rebuild an index in full recovery model you need as much log space as the total size 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
August 5, 2011 at 6:06 am
Lavanyasri (8/5/2011)
The main reason why my database goes to suspect mode is server restarted 2 times . Paricular database goes to suspect mode .
There's something wrong with your...
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 5, 2011 at 6:01 am
Corruption is almost always caused by a problem in the IO subsystem. Could be anything in the IO stack.
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 5, 2011 at 5:38 am
Please post new questions in a new thread. Don't hijack an unrelated thread.
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 5, 2011 at 5:20 am
Sure, but having only a week old backup of (I assume) an important database is a stuff-up in and of itself. Surely if the data's important to you (or your...
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 5, 2011 at 5:13 am
Errors in the space used algorithms. Upgrade to at least SP3, they're fixed by then.
It's not really a problem, if it bothers use use DBCC UPDATEUSAGE
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 5, 2011 at 5:07 am
Viewing 15 posts - 24,406 through 24,420 (of 49,552 total)