Viewing 15 posts - 6,766 through 6,780 (of 22,229 total)
Or extended events. You can also use those in 2008 and greater for monitoring.
"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
February 17, 2015 at 5:18 am
Assume the right answer is always in the Perfmon Counters themselves and anything else is an interpretation on top of it and make allowances accordingly. Not a great answer, but...
"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
February 17, 2015 at 4:46 am
The DMV is not the performance counter. It's just a view on top of them. It might not resolve in the same way as going directly to the performance counters...
"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
February 16, 2015 at 4:24 am
Word on the street is that a new cert for 2014 will be out very soon. But, as Gail says, it's not here yet.
"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
February 16, 2015 at 4:22 am
KGJ-Dev (2/5/2015)
thanks grant and please suggest me if it not enable will it affect performance. How drastically it affect the performance?
I have not seen it have a negative impact on...
"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
February 16, 2015 at 3:28 am
Lynn Pettis (2/15/2015)
TomThomson (2/14/2015)
Lynn Pettis (2/14/2015)
TomThomson (2/14/2015)
Eirikur Eiriksson (2/7/2015)
TomThomson (2/7/2015)
Grant Fritchey (2/5/2015)
Really? Yankees fans? Are they even human?Usually not - they're mostly American.
Tom, must say that I find this comment...
"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
February 16, 2015 at 3:26 am
Lynn Pettis (2/15/2015)
... Mark one off, 12 days on the calendar to go. 12 days on the calendar to go, 12 days to go, ...
Almost down to the single digits.
WHOOOP!!!!
"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
February 16, 2015 at 3:19 am
kkp40 (2/13/2015)
I would like to read about how to use the execution plans to understand what to change in my sql-query, or in the table, to make it better.
I can...
"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
February 15, 2015 at 5:47 am
I agree. This looks like standard parameter sniffing gone wrong. It's always about the data and the data distribution. The parameter values passed from one create a plan for retrieving...
"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
February 7, 2015 at 3:18 am
Prior to extended events, I had trace running 24/7 on a lot of systems too. It's work to deal with the data generated, but it's a great way to gather...
"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
February 6, 2015 at 8:06 am
dwain.c (2/5/2015)
Grant Fritchey (2/5/2015)
Everything Dwain has said so far is spot on.
I am surprised and somewhat relieved that I am not entirely full of crap, despite what others may be...
"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
February 6, 2015 at 7:55 am
It means that traceflag is not enabled on your system.
"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
February 5, 2015 at 4:13 pm
Thanks for the kind words.
What if you just work on the inner part of the apply query. Can you get that to filter on it's own, either by changing 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
February 5, 2015 at 1:56 pm
OK. Regardless of the logic, just add a step with that logic.
"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
February 5, 2015 at 1:01 pm
Then you can individually go through and REVOKE privileges too.
"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
February 5, 2015 at 12:25 pm
Viewing 15 posts - 6,766 through 6,780 (of 22,229 total)