Viewing 15 posts - 17,566 through 17,580 (of 22,219 total)
Using trace to capture execution plans can be an expensive operation so you need to be very judicious in it's application within a production system. That said, it really depends...
"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
April 30, 2009 at 6:21 am
Compile time is a result of resources available and the complexity of the query. The more complex the query, the longer it will take. Also, if the query is in...
"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
April 30, 2009 at 6:16 am
Sure. Check sys.dm_exec_requests. You should be able to get what you need from there or by joining to one of the other execution DMV/F's to prevent a secondary execution while...
"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
April 30, 2009 at 6:11 am
Lynn Pettis (4/29/2009)
GilaMonster (4/29/2009)
Bruce W Cassidy (4/29/2009)
[font="Verdana"]International Star Wars day... "May the 4th be with you."[/font]*groan*
Hmmm, we were discussing having another Starwars day.....
Now for something totally the same...
How many...
"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
April 29, 2009 at 4:15 pm
It's right there in the signature line, The Scary DBA.
"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
April 29, 2009 at 6:35 am
It could be something you have to monitor. Do you have an idea as to why you're getting so many page splits? Does the table have a clustered index that's...
"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
April 29, 2009 at 5:40 am
There are great articles right here on SQL Server Central. Just type something like 'index design' in the search box and then limit the scope to articles. There are 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
April 29, 2009 at 5:32 am
You can take advantage of the default return value from procedures like this (untested code):
DECLARE @retval int
EXEC @retval = ProcA @param1='a',@param2='b'
IF @retval = 0
BEGIN
EXEC ProcB
EXEC ProcC
END
"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
April 29, 2009 at 5:24 am
How much data is in the table, specifically how many pages?
For very small tables, less than 10 pages, you might not see any change in fragmentation, even after a rebuild...
"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
April 29, 2009 at 5:02 am
Yeah, that sounds familiar. I'd suggest recompiling after the data load and avoid using query hints. Since you know it's going to happen, take care of it that way. Also,...
"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
April 29, 2009 at 4:58 am
Without details it's not possible to give you specific advice. In general, make sure you have a clustered index on the table. Make it as narrow as you can, 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
April 29, 2009 at 4:52 am
Track down a copy of Brad McGehee's "How To Be An Exceptional DBA." It's a great read. For a fantastic introduction to the concept of being a DBA, I recommend...
"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
April 29, 2009 at 4:43 am
You need to use a server-side trace. You can build this manually using the T-SQL commands or you can use the SQL Profiler tool to build it for you. This...
"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
April 29, 2009 at 4:40 am
Thanks for posting the answer. It's always good to know when I got something right.
"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
April 29, 2009 at 4:25 am
Bruce W Cassidy (4/28/2009)
"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
April 29, 2009 at 4:14 am
Viewing 15 posts - 17,566 through 17,580 (of 22,219 total)