Viewing 15 posts - 2,581 through 2,595 (of 22,224 total)
I'm doing a precon at Columbus.
SPEND YOUR MONEY!!!!!
"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
May 11, 2019 at 1:56 pm
Here are a bunch of examples from my blog of using Extended Events to answer various questions. This should provide you with a bunch of what you're asking. I'll...
"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
May 11, 2019 at 1:56 pm
Ah, interesting use of the tools. Unfortunately, I don't know of a way to do it. I'm not saying it can't be done, just that there's not a way I'm...
"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
May 10, 2019 at 3:55 pm
Really curious what the use case and need is though.
"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
May 10, 2019 at 2:58 pm
thank you for your reply. What is the difference between MCSA: SQL 2016 Database Administration and MCSA: SQL Server 2012/2014?
One is for SQL Server version 2016 and the other...
"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
May 10, 2019 at 1:44 pm
I don't think you can because the hash is created internally based on a structure in the optimizer, not the T-SQL text, that would also have to be recreated. You...
"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
May 10, 2019 at 1:41 pm
There are built in metrics in Permon that you can use. Here's an article. Chapter 3 (or maybe 4, I forget) of my book also discusses monitoring the network....
"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
May 10, 2019 at 1:36 pm
You're on 2016. Use the Query Store. Nice and easy way to gather that information. Otherwise, some of the suggestions are good, query the cache, use extended events and...
"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
May 10, 2019 at 1:32 pm
I'm not aware of a way to do this, no. You can have a query window showing logins. You can refresh that regularly. Or, maybe you're thinking of the Activity...
"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
May 10, 2019 at 1:29 pm
Good luck. I don't blame you. A friend worked for one when I was growing up. They always got to go to cool places. I just searched for "sql server"...
"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
May 9, 2019 at 2:37 pm
Quick web search. Yes.
"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
May 9, 2019 at 12:17 pm
Oh, and doggone it, database settings. ANSI settings especially, but all the rest too. Differences there can lead to different performance characteristics.
"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
May 9, 2019 at 12:14 pm
First, and I can't emphasize this enough, double, triple, quadruple check that yes, really, these servers are the same. Frequently they are not.
Then, of course, the next question is, are...
"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
May 9, 2019 at 12:11 pm
When you jump the SQL Server 2014 gap (because no one should ever upgrade to 2014), you do need to be aware of something really important. In SQL Server 2014,...
"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
May 9, 2019 at 12:02 pm
If you're just getting going, now is a great time to completely ignore trace and trace events and concentrate only on Extended Events. Instead of default trace, look to 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
May 9, 2019 at 11:55 am
Viewing 15 posts - 2,581 through 2,595 (of 22,224 total)