Viewing 15 posts - 1,141 through 1,155 (of 22,224 total)
That's a measure you have to do from the client. Azure SQL Database isn't going to see latency on it's end. It's going to get a connection request (however long...
"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
October 8, 2021 at 1:45 pm
Another vote for Extended Events. Safe, as light weight as you can get while still monitoring behaviors on the system.
However, yes, you'll have to set something up in order 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
October 7, 2021 at 11:45 am
Without an error message of any kind, it could be sunspots, extra solar radiation or the vast conspiracy of the Bohemian Grove. We simply don't have enough information to say...
"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
October 7, 2021 at 11:43 am
It's hard to say without a lot more data. Capture query metrics using extended events. Capture wait statistics (you can combine these with the query metrics using extended events so...
"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
October 7, 2021 at 11:42 am
ALWAYS, go to Microsoft for accurate licensing information. They're just going to know better than some knucklehead on the internet, like me.
However, this one I think I can answer accurately...
"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
October 7, 2021 at 11:39 am
I'd argue you'll some some general performance enhancements, but it won't be night & day.
"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
October 5, 2021 at 4:29 pm
Grant,
Got it. Good advice about testing from all.
And it looks like I can us ALTER to create a non-clustered index after the table was created.
Oh yeah. Adding them 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
October 5, 2021 at 2:56 pm
Grant,
I think that is what I am doing. The primary path AFTER sign in is by UserId - the identify column. However, at sign in it looks for 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
October 5, 2021 at 1:35 pm
But, in this case, having the Clustered Index on the UserID is probably perfect.
You also won't need a non-clustered index on UserID then, either.
Jeff's not wrong (I say that...
"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
October 5, 2021 at 12:29 pm
This.
Just that. Everything else is nice to have. But that, that's a flipping miracle. And yes, I mean the word other than flipping.
"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
October 5, 2021 at 12:24 pm
You have to monitor the system in order to understand how it is behaving. Capturing wait statistics and queues can tell you where slow downs are occurring. Capturing performance metrics...
"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
October 5, 2021 at 12:20 pm
Hey Grant,
Thanks for the reply. I'm not upset (was just a bit surprised) and glad you aren't either. No harm done on either side then.
Looking back at the DBA...
"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
October 4, 2021 at 3:04 pm
<sigh>
So I post a comment over at DBA Stack Exchange, because I know what I'm posting isn't an answer. I get dinged for it because it almost...
"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
October 4, 2021 at 2:20 pm
It's going to take the amount of time it takes. To rewrite almost a terrabyte of data is just down to having enough disk space and disk speed. You're not...
"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
October 4, 2021 at 1:07 pm
I've been involved in that kind of work before, changing things from within without institutional support. I'd say, on a guess, I failed 75% of the time and succeeded 25%....
"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
October 1, 2021 at 5:15 pm
Viewing 15 posts - 1,141 through 1,155 (of 22,224 total)