Viewing 15 posts - 5,476 through 5,490 (of 22,227 total)
I'd take a look at Louis Davidson and Tim Ford's book
Performance Tuning with SQL Server Dynamic Management Views
It's free to download.
"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 5, 2015 at 6:40 am
As long as you're using the BACKUP DATABASE command to create the backup, you're getting a page by page copy of the database. The backup is going to be 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 5, 2015 at 5:12 am
If you have questions or hit snags along the way, you know where to go.
Best of luck.
"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 9:54 am
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
Viewing 15 posts - 5,476 through 5,490 (of 22,227 total)