Forum Replies Created
Viewing 15 posts - 3,001 through 3,015 (of 22,224 total)
-
RE: Ideas for setting Azure SQLmanaged instance for transaction and reporting
Jeff Moden - Monday, September 10, 2018 7:28 AM"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Ideas for setting Azure SQLmanaged instance for transaction and reporting
Jeff Moden - Monday, September 10, 2018 7:16 AM"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: CPU time > Elapsed time
msimone - Monday, September 10, 2018 6:13 AM"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Ideas for setting Azure SQLmanaged instance for transaction and reporting
Jeff Moden - Monday, September 10, 2018 6:27 AM"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance TuningRE: Coming down on bad users - WWYD ?
Education.
Help them out by teaching them the right things to do. It's the only way unless you lock them out, which may or may not be possible depending...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance TuningRE: Fast Database Clone
Jeff is dead on accurate. That is the fastest and safest way I know to get the job done.
However, I do know a way that is just as...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance TuningRE: CPU time > Elapsed time
It really depends on how you're capturing the elapsed time. There is a way in extended events to only capture the execution time of a procedure, skipping the compile time...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance TuningRE: Ideas for setting Azure SQLmanaged instance for transaction and reporting
Jeff Moden - Sunday, September 9, 2018 10:18 AM"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance TuningRE: Ideas for setting Azure SQLmanaged instance for transaction and reporting
ebooklub - Friday, September 7, 2018 12:54 PM"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance TuningRE: Are the posted questions getting worse?
Jonathan AC Roberts - Friday, September 7, 2018 7:54 AM"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance TuningRE: Are the posted questions getting worse?
Sergiy - Friday, September 7, 2018 7:01 AMHere is the screenshot of a fresh job description.
Seems like ticks all the boxes.
🙂
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance TuningRE: Ideas for setting Azure SQLmanaged instance for transaction and reporting
Availability groups and read only secondaries are, I think, supported on managed instances. That would be a solution.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance TuningRE: Question about administration of your databases on Azure
It completely depends on what we're talking about when we say "Azure". So, if by Azure you mean Virtual Machines managed on Azure, it's just SQL Server instances and everything...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance TuningRE: Capture query which takes longer than 20 seconds and send email from SQL Server
Second vote for Redgate SQL Monitor. That will do everything you're asking for.
However, if you really want to build it yourself, look to Extended Events. You can use...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance TuningRE: Question about memory
Generally SQL Server will consume every bit of memory it can and hold on to it. That your'e seeing it go up and down is more concerning than that it...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance TuningViewing 15 posts - 3,001 through 3,015 (of 22,224 total)
