Viewing 15 posts - 5,476 through 5,490 (of 22,224 total)
mw112009 (10/2/2015)
Got lost here.. What button/menu item should I use to see the actual plan ? ( not the estimated )
Just remember that the Actual Plan requires that your run...
"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 2, 2015 at 8:05 am
ChrisM@Work (10/2/2015)
Grant Fritchey (10/2/2015)
ChrisM@Work (10/2/2015)
Jason A. Long (10/2/2015)
ChrisM@Work (10/2/2015)
Jason A. Long (10/1/2015)
Also note that you will need to look at the Actual execution plan to see the plan change. 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 2, 2015 at 7:31 am
ChrisM@Work (10/2/2015)
Jason A. Long (10/2/2015)
ChrisM@Work (10/2/2015)
Jason A. Long (10/1/2015)
Also note that you will need to look at the Actual execution plan to see the plan change. The Estimated plan will...
"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 2, 2015 at 7:06 am
Jason A. Long (10/2/2015)
ChrisM@Work (10/2/2015)
Jason A. Long (10/1/2015)
Also note that you will need to look at the Actual execution plan to see the plan change. The Estimated plan will continue...
"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 2, 2015 at 7:04 am
DMV = Dynamic Management Views
It's a way of accessing information about the system. You're focusing on the wrong things here. As others have pointed out, just because an index exists...
"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 2, 2015 at 4:29 am
The install ought to be pretty straight forward. The hard part is getting the configuration right. Make sure you change a few defaults. For example, Set a Max Memory 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 2, 2015 at 4:25 am
I would have expected to see something in the text column yes. But, maybe because it errored out there was an issue with what was stored in cache.
"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 2, 2015 at 4:21 am
Don't forget about all the "Stairways" series of articles listing over on the left of this screen.
"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 2, 2015 at 4:18 am
WayneS (10/1/2015)
Grant Fritchey (10/1/2015)
Eirikur Eiriksson (10/1/2015)
ChrisM@Work (10/1/2015)
Oh, and maple beer - yuck.
This made me spill my ESB all over the Pub lunch
😎
However, Maple Whiskey... YUM! Specifically though, when you use...
"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, 2015 at 8:38 am
In addition to the above, find out what the Recovery Time Objective and Recovery Point Objective is for each of the databases in production. I would also find out if...
"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, 2015 at 7:54 am
I'm not aware of any way to do this through DMVs. A number of other options present themselves, but all are going to be a lot more work than just...
"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, 2015 at 7:50 am
Eirikur Eiriksson (10/1/2015)
ChrisM@Work (10/1/2015)
Oh, and maple beer - yuck.
This made me spill my ESB all over the Pub lunch
😎
However, Maple Whiskey... YUM! Specifically though, when you use it in a...
"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, 2015 at 6:08 am
You can try doing plan forcing through plan guides. But it's also subject to the issues around white space and value changes within the code. As long as the code...
"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
September 30, 2015 at 3:21 am
Huh. Cool. Always learning. That's the first time I've seen 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
September 29, 2015 at 4:47 pm
I'm not aware of any way to do this. If you're attempting to insert data that violates a primary key, it's a very serious error.
"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
September 29, 2015 at 12:28 pm
Viewing 15 posts - 5,476 through 5,490 (of 22,224 total)