Viewing 15 posts - 4,846 through 4,860 (of 49,552 total)
Try increasing the size of TempDB, you're just running out of space. Put extra files on another drive if necessary, or get a larger drive for it.
Without seeing the formula...
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 2, 2015 at 3:19 am
That's normal. You'll always have intent locks at the table level. Nothing to worry about, it's how SQL's locking process works.
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 2, 2015 at 3:14 am
So 6 then.
In that case, you can try 6, 9 or 12 as maxdop, see which works best for you (calced as 1x, 1.5x and 2x the number of physical...
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 2, 2015 at 3:00 am
I'm going to give you my usual answer.
Analyse, investigate and identify exactly what's happening. Don't guess, you're just going to waste time. Don't try stuff at random, it doesn't work....
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 2, 2015 at 2:52 am
I would suggest you start by reading Books Online, there's lots of details and recommendations there.
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 2, 2015 at 2:50 am
Restore from their last good backup. 😀
Without a backup, pretty close to no options. I can't recall ever having seen a deleted database file recovered and be useful.
What's the exact...
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 2, 2015 at 2:49 am
sqlbaby2 (9/1/2015)
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 2, 2015 at 2:47 am
sqlfriends (9/1/2015)
Can I use a full and differential backup to restore to a point of time?
No. Full and diffs can only be restored to the time which they ran (end...
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 2, 2015 at 2:43 am
EasyBoy (9/1/2015)
Thanks for your prompt response. I understand that we can't limited to growth. But, this is how they implemented tempdb.
Ok, but that doesn't stop you from reconfiguring it correctly
...
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 1, 2015 at 4:32 pm
Then someone else changed something, or you changed something that you didn't think relevant. CheckDB CANNOT have fixed the error you posted.
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 1, 2015 at 4:27 pm
SQLBill (9/1/2015)
Check your code for reindexing....does it use SORT_IN_TEMPDB?
The rebuild starts 20 minutes after the alert, so unless there's a second rebuild job somewhere, it's not from rebuilds.
Could 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 1, 2015 at 4:26 pm
Back in SQL 2000 that construct would cause a recompile on every execution, no idea offhand for 2008. Fire up server-side trace or extended events (no GUI in 2008 though)...
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 1, 2015 at 2:53 pm
First fix that growth increment. Nothing should use % growth. Set the growth increment to a sensible size. Second, the limit on the file size means that if something needs...
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 1, 2015 at 2:51 pm
CheckDB cannot fix code problems, and unless the errors being thrown were severity 24, probably did nothing at all.
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 1, 2015 at 1:48 pm
It probably did nothing, since the error was in code and repair can't fix that (short of deallocating pages from the system tables)
Though he said nothing about using the REPAIR_ALLOW_DATA_LOSS...
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 1, 2015 at 1:43 pm
Viewing 15 posts - 4,846 through 4,860 (of 49,552 total)