Viewing 15 posts - 12,676 through 12,690 (of 22,227 total)
Brandie Tarvin (4/25/2011)
GilaMonster (4/23/2011)
Jack Corbett (4/23/2011)
So now we have someone saying don't REORG indexes only REBUILD and you don't need to do statistics maintenance.http://www.sqlservercentral.com/Forums/Topic1094168-146-3.aspx
Want to swap? I'm having some amusement...
"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 25, 2011 at 4:48 am
Sorry to hear about the loss Steve. I'm going to go down & give my kids a hug 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
April 25, 2011 at 4:45 am
vishal.gamji (4/22/2011)
Nevermind, it does use cached plans.Found an interesting article that helped answer my question.
http://awanderingmind.com/2011/01/03/entity-framework-from-a-dba-perspective-part-2/
Good. Guess I need to type faster next time.
"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 22, 2011 at 9:41 am
vishal.gamji (4/22/2011)
Does anyone have any experience with EF4 and the queries it generates? Someone from the application team mentioned that the query plans were reused (somehow). Is this true?
By EF4,...
"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 22, 2011 at 9:40 am
While a read is occuring, you can't update the data underneath. Read uncommitted allows you to read before the write has been committed (while it's still in cache), which 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
April 22, 2011 at 9:36 am
sandyinfowave (4/22/2011)
I am noticing some database timeouts in my .NET application and on further analysis(of Actual...
"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 22, 2011 at 9:33 am
If you have foreign keys in place, then you should not have any orphans. That's the whole idea of referential integrity.
If your foreign keys are not enforced, then you could...
"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 22, 2011 at 5:39 am
You might want to take a look at Red Gate SQL Data Compare. It's a great tool for moving data between two databases. You can automate it too 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 22, 2011 at 5:34 am
Did you update the statistcs after the upgrade?
There are a few instances where queries, especially complex or convaluted queries, had different execution plans after the upgrade due to regressions. Have...
"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 22, 2011 at 5:31 am
If your log is growing like crazy, are you in FULL recovery and if so, are you running log backups. Having databases in FULL recovery and not running log backups...
"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 22, 2011 at 5:28 am
I'm not sure that I'd worry too much about that. I'd focus on Lock Timeouts/sec and Lock Wait Time. Those are better indications of issues with locking than simply getting...
"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 22, 2011 at 5:23 am
I'm not familiar with Compellent, but I went to their web site. It looks to me like it's a SAN management and backup software. Is that right?
If so, those things...
"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 22, 2011 at 5:20 am
The other thing you can do with the trace data is feed it into the RML utilities. That will give you good reports on the longest running query, etc. From...
"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 22, 2011 at 4:59 am
If I were doing it, I'd probably do that first.
"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 21, 2011 at 7:35 am
Matt-1034261 (4/21/2011)
Grant Fritchey (4/21/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
April 21, 2011 at 7:19 am
Viewing 15 posts - 12,676 through 12,690 (of 22,227 total)