Viewing 15 posts - 12,496 through 12,510 (of 22,224 total)
1.1. Not per se. I prefer just using the STATISTICS IO and STATISTICS TIME when working with a single query. It's easier than this set up and accurate enough
1.2.a. 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
May 24, 2011 at 5:08 am
No, don't use the DTA. It's recommendations are frequently a waste of time and that's if it makes recommendations.
Your approach is OK as mechanism to see what the query...
"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 24, 2011 at 4:37 am
I buy 'em all. I've got a kindle, an ipad and I'll shortly have an Asus running Honeycomb.
Seriously though, the Kindle is excellent for reading and the battery life is...
"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 24, 2011 at 4:33 am
When you tell SQL Server to run a backup, the backup process runs under the context that SQL Server is configured in, not the context in which you are connecting...
"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 24, 2011 at 4:12 am
opc.three (5/23/2011)
Craig Farrell (5/23/2011)
GilaMonster (5/23/2011)
LutzM (5/23/2011)
GilaMonster (5/23/2011)
"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 23, 2011 at 6:43 pm
Jim Murphy (5/23/2011)
Grant Fritchey (5/23/2011)
colin.Leversuch-Roberts (5/23/2011)
isn't a bit scary when a DBA asks this question?
You mean it's scary when a DBA asks what he ought to document? I'd like 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
May 23, 2011 at 6:41 pm
colin.Leversuch-Roberts (5/23/2011)
isn't a bit scary when a DBA asks this question?
You mean it's scary when a DBA asks what he ought to document? I'd like to see what people think...
"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 23, 2011 at 4:15 pm
I'd get the maintenance jobs documented as much as possible. This way you'll know what's not getting done. Other than that, I find that the business documention is more important...
"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 23, 2011 at 1:26 pm
jarid.lawson (5/23/2011)
Excellent. I just IM'ed my wife to add it to the list / budget. I'll give it a go soon.
I can help you with the wife, it's free unless...
"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 23, 2011 at 1:17 pm
GilaMonster (5/23/2011)
"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 23, 2011 at 1:16 pm
Soonish. 1st draft is done, but my tech editor, Brad McGehee, has probably painted it red with comments & suggestions. I think we're shooting for publishing before the PASS Summit....
"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 23, 2011 at 12:29 pm
Then you're probably running this against a 2000 database as Gail already pointed out. You can't do this with 2000.
"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 23, 2011 at 11:32 am
But if you're in 2005 or above you can right click on the plan and select "Save As"
"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 23, 2011 at 11:01 am
Danzz (5/23/2011)
@ Grant FritcheyThanks for the reply.
For sure the SQL Queries are slow. How do I start over and troubleshoot.
Tuning queries is a huge topic. If you start with...
"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 23, 2011 at 10:05 am
Ninja's_RGR'us (5/23/2011)
Indianrock (5/23/2011)
Thanks Grant. Time to read your book on execution plans. It's sounding like no magic bullet here.
there's no magic bullet for any global tuning process... always takes...
"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 23, 2011 at 7:19 am
Viewing 15 posts - 12,496 through 12,510 (of 22,224 total)