Viewing 15 posts - 12,991 through 13,005 (of 22,219 total)
I agree with Pam, first place to look is the actual execution plans. Are they different, if so, what are the differences?
Another option to check, what are the ANSI connection...
"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
March 18, 2011 at 3:53 pm
[Jim].[dba].[Murphy] (3/18/2011)
Grant Fritchey (3/18/2011)
...you may want to take the consistency checks offline, perform them on a restored copy of the database or something.
I have to agree; also helps minimize 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
March 18, 2011 at 3:26 pm
Honestly, on most systems, on most databases, I just use the defaults. It's pretty rare that suggesting a marginal change in sampling rates will make that big a difference 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
March 18, 2011 at 3:17 pm
GilaMonster (3/18/2011)
Test the backupexec full with the log. I have not...
"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
March 18, 2011 at 3:15 pm
Depending on the system, you may want to take the consistency checks offline, perform them on a restored copy of the database or something. I'd move that away from any...
"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
March 18, 2011 at 3:13 pm
Each of those INSERT statements is treated as a miniature transaction and the INSERT ... SELECT ... UNION is a giant transaction. That's probably where the differences lie.
"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
March 18, 2011 at 5:40 am
Chad Crawford (3/17/2011)
Wahoo! Just passed 70-454. I am now officially SQL 2008 DBD ITP. 😀 Yipee!
Congratulations, well done.
"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
March 17, 2011 at 2:49 pm
jason.spangler (3/17/2011)
I'm checking out the ad hoc workload option. Looks like it will help. We...
"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
March 17, 2011 at 10:44 am
Brandie Tarvin (3/17/2011)
I...
"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
March 17, 2011 at 9:00 am
It's an artifact I wouldn't sweat it. If you're getting the cache hit, you're good to go. You can also look at the execution plans to see if the plan...
"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
March 17, 2011 at 8:55 am
GilaMonster (3/17/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
March 17, 2011 at 6:24 am
Restoring the database will recreate it with the same size and allocation you have now.
108gb is not that big a database. In fact, it's almost a small database. If it'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
March 17, 2011 at 6:12 am
No reason why you can't move that into the derived table. I've done it before.
"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
March 17, 2011 at 6:08 am
Shrinking the log file won't affect the log chain. You can do it when you think best.
Shrinking files is a problematic thing to do since it leads to fragmentation. 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
March 17, 2011 at 5:49 am
I don't like correcting people online, but don't follow Rohit's advice. Constantly shrinking your files leads to severe file fragmentation. You don't want to do this to a production server.
I...
"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
March 17, 2011 at 5:47 am
Viewing 15 posts - 12,991 through 13,005 (of 22,219 total)