Viewing 15 posts - 17,566 through 17,580 (of 22,226 total)
Paul White (4/30/2009)
Tim,You should use the event SQL:StmtRecompile instead of SP:Recompile in 2005 and later.
See http://msdn.microsoft.com/en-us/library/ms179294.aspx
The SP:Recompile event is there to allow tracing of SQL2K instances.
Hm. Interesting. I didn't...
"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 7:29 pm
WayneS (4/30/2009)
Gail - can you give a good answer to this? I kinda thought along these line also.http://www.sqlservercentral.com/Forums/Topic707743-338-1.aspx
I think Gail nailed it. I sure hope so since I posted 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
April 30, 2009 at 4:55 pm
You're probably getting a statement recompile rather than a procedure recompile. If you capture the SP:Recompile event in a trace you can see, probably multiple, the event show up 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
April 30, 2009 at 4:54 pm
I don't know where you're located, but I'd suggest also getting in touch with a local user's group, if any. Go to the Professional Association of SQL Server users 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
April 30, 2009 at 1:05 pm
From a strict, structural stand point, no it doesn't make any sense to break that data out in that fashion. Not unless you're breaking down all the address information so...
"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 7:22 am
There are absolute, demonstrable, performance issues when you don't schema qualify the tables, views, stored procedures & UDF's. You can get away with not doing it, yes, but you're paying...
"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 7:11 am
One of two ways you can go about that. First option, run server-side traces to capture events over time. You can set those up through Profiler. You can then aggregate...
"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:36 am
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
Viewing 15 posts - 17,566 through 17,580 (of 22,226 total)