Viewing 15 posts - 4,036 through 4,050 (of 49,552 total)
The deadlock is not coming from a select.
What you have, at the time the deadlock happens, is one session that holds an X lock already on one row (and will...
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
December 10, 2015 at 1:48 pm
Um...
SQL-DBA-01 (12/10/2015)
will run in every 30 secs to take more frequent tlog bkps until the job (full bkp) is completed.
The log won't truncate until the full backup finishes, that's 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
December 10, 2015 at 1:21 pm
That's not a lock conversion, and SQL will never convert an X lock to a U. Lock conversions are to more restrictive lock modes. U is less restrictive than X.
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
December 10, 2015 at 12:44 pm
Ok, and?
The log is full, you've seen that. It's full because a transaction is open and hence the space in the log can't be reused. The procedure with the transaction...
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
December 10, 2015 at 12:41 pm
Disable page locks
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
December 10, 2015 at 12:07 pm
Ok, so you're filling the log with a transaction. What's the question?
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
December 10, 2015 at 11:49 am
Frank Dijk (12/10/2015)
For your info: It is MySQL (if that matters).
Yes it does. This is a Microsoft SQL Server forum. We know MS SQL, not MySQL, so solutions posted here...
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
December 10, 2015 at 11:48 am
No.
The log won't truncate until the full backup finishes, that's the only difference to running the log backup any other time.
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
December 10, 2015 at 11:46 am
Fandy08 (12/8/2015)
So, definitively, the reason must have been bad plans after reorg of indexes
No. Not bad plans. Plans which run more data through the UDFs than previously, resulting in 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
December 10, 2015 at 4:10 am
No, we're not. We don't have the rigour, the formality, the adherence to standards that characterises engineering disciplines. The scientific method is not 'try stuff at random until something 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
December 10, 2015 at 3:53 am
It'll take a while. Do it in 5GB or so chunks.
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
December 10, 2015 at 3:32 am
IF is a control flow statement. It's used outside of queries to determine whether a statement should run or not. It can't be used inside a query.
You probably want something...
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
December 10, 2015 at 3:30 am
And speaking of the boss, I just sent him an email with no text, just two screenshots. Flight prices Johannesburg to London return, train prices London to Liverpool return. Let's...
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
December 9, 2015 at 2:48 pm
jasona.work (12/9/2015)
that also happens to be a day I'm sure Gail is waiting for...Star Wars: The Force Awakens release day!
It's releasing here on the 16th, which is a public holiday....
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
December 9, 2015 at 2:23 pm
rodjkidd (12/9/2015)
Wed May 4th to Sat May 7th
Liverpool Exhibition Centre
Now what do to about the ticket I have for Yes...
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
December 9, 2015 at 9:42 am
Viewing 15 posts - 4,036 through 4,050 (of 49,552 total)