Forum Replies Created
Viewing 15 posts - 3,001 through 3,015 (of 22,227 total)
-
RE: Does SQL Profiler template created for SQL Server 2017 work for 2008?
Yes. Nothing has changed in Profiler since 2008.
You might want to take a look at Extended Events for your more modern systems.
"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: Coming down on bad users - WWYD ?
JaybeeSQL - Monday, September 10, 2018 1:12 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 Tuning -
RE: Are the posted questions getting worse?
Hello Threadizens,
Look, I could care less, but Hugo is quite chuffed about this, so I figured I'd share this with you. The 3rd Edition of Execution Plans is...
"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: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 TuningViewing 15 posts - 3,001 through 3,015 (of 22,227 total)
