Viewing 15 posts - 19,456 through 19,470 (of 22,226 total)
Do the execution plans change between the two?
I agree with Matt. It's probably parameter sniffing.
"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 17, 2008 at 5:46 am
The easiest way to do it is probably with a backup & restore.
However, if you're making lots of changes over time to the structure or the data, you may want...
"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 17, 2008 at 5:37 am
jonathanmreynolds (10/16/2008)
isql.exe -U SA -P XXXXXX -d DBNAME -S SERVERNAME -n -i vsm_his2he.sql -o log.txt
bcp DBNAME.dbo.hotel_expert_room_registry out out1.txt -f param.txt -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
October 17, 2008 at 5:35 am
You can use a PRINT command to put it out into the Messages window.
"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 16, 2008 at 11:59 am
If you do nothing else at all, I'd recommend bumping that up to something like 25 or 30. I've seen it set as high as 50 on servers that still...
"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 16, 2008 at 8:45 am
Since you've got parallelism on, what's the threshold set 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 16, 2008 at 8:34 am
I'd suggest checking the variable that's being executed as the query, @clk_fund_stmt (and the others). Make sure that's structured correctly. If you're getting nulls, it's originating there.
"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 16, 2008 at 5:39 am
There was also a presentation from one of the SQL Server internals guys at the PASS summit a couple of years back called "A Day In The Life of...
"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 16, 2008 at 5:26 am
Go back and reread Gail's post. She shows you how to measure which procs are taking the longest & using up CPU. Once you identify the query or queries 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
October 15, 2008 at 10:31 am
GilaMonster (10/15/2008)
Grant Fritchey (10/15/2008)
OK. That's twice. It should stop now.:hehe: 😀 Great minds think alike?
I'll go do something else for a while...
Normally, my response is for the other party 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 15, 2008 at 9:00 am
OK. That's twice. It should stop now.
"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 15, 2008 at 8:50 am
I'm so stupid...
This is 2005 right? Toss trace. Run a query against sys.dm_exec_query_stats. This is a dynamic management view that contains information about the queries currently in cache. You can...
"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 15, 2008 at 8:48 am
Oops. There I am typing up the response and looking for your URL and there you are posting it. Ah well. Reinforces the point.
"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 15, 2008 at 8:41 am
It really depends on how you're going to use the information. Since it's only a single row returned, probably, you won't have issues with either approach. Usually, the inline 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
October 15, 2008 at 8:40 am
Cross-posted here: http://www.sqlservercentral.com/Forums/Topic586167-145-1.aspx
Please keep posts to one forum.
"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 15, 2008 at 8:32 am
Viewing 15 posts - 19,456 through 19,470 (of 22,226 total)