Viewing 15 posts - 4,651 through 4,665 (of 22,219 total)
You're saying deadlock. Do you mean that the SELECT query in question is being chosen as a deadlock victim and it's transaction is being rolled back? Or do you mean...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 29, 2016 at 2:33 am
You've got two choices on capturing this information within SQL SErver 2012 and one more with SQL Server 2016 (and Azure SQL Database).
First, extended events. You can capture rpc_completed event...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 28, 2016 at 9:46 am
And just so you know, the way filtering works in Trace, it captures the events first, using whatever memory & cpu it needs to do that, then determines if the...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 28, 2016 at 9:40 am
Each of the individual statements are going to reflect the statement, but the whole RPC will include any round trip waits between the statements as the data moves back to...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 28, 2016 at 9:38 am
Gary Varga (6/28/2016)
Grant Fritchey (6/28/2016)
Microsoft is...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 28, 2016 at 9:32 am
OK, you'll have to explain that to me better. If Azure releases are bad, that makes the SQL Server release better? I don't get that.
Microsoft is releasing SQL Server more...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 28, 2016 at 8:18 am
Without seeing the error, it's hard to say. However, if you start a transaction and that transaction fails, you will get a rollback of that transaction.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 28, 2016 at 6:39 am
You'll have to set up an Azure account too. If you have access to MSDN, you can get a free account with a limited amount of funds for each month....
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 28, 2016 at 6:37 am
CASE statement in the GROUP BY clause is also going to lead to some pretty poor choices by the optimizer.
If you have two different sets of logic, rather than try...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 27, 2016 at 2:52 am
I absolutely hear you. I've been working with 2016 for quite some time now. I just haven't hit major issues. Not like with other releases. I'm not about to argue...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 27, 2016 at 1:40 am
You know I don't argue with you. I haven't seen this. Do you have an example, just to educate me.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 25, 2016 at 4:14 pm
Brandie Tarvin (6/22/2016)
Well, speaking from the perspective of a science fiction fan...The sooner we all get ourselves a world government, the better.
Ha!
Being a different kind of science fiction fan,...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 22, 2016 at 8:31 am
jasona.work (6/21/2016)
Geez, where the heck has the year gone?We're just under 2 weeks out from the half-way mark of the year...
And I'm only at 56,000 miles so far.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 21, 2016 at 7:16 am
The two most important things are to start running SQL Server backups of all your databases and, test those backups by occasionally running a restore (to a test system, or...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 17, 2016 at 7:34 am
djj (6/16/2016)
I had the privilege of meeting Grant last night at the local PASS meeting. Liked his talk. Gave me a few (many) things to check today.
WHOOP!
It was...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 16, 2016 at 7:24 am
Viewing 15 posts - 4,651 through 4,665 (of 22,219 total)