Viewing 15 posts - 12,661 through 12,675 (of 22,219 total)
I only know of one person who went straight from college to a full-time DBA and he spent about 18 months as an unpaid intern first. Since you have zero...
"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 5:14 am
In addition to everything else already mentioned, make sure you have good statistics maintenance running on the table. They will impact the plans chosen and because of that, the 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 25, 2011 at 5:08 am
On the other hand, if you're looking at the text showplan, you'll need to parse it using some other language. Better to get the XML 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
April 25, 2011 at 5:02 am
On a side note, I'd suggest taking your cost threshold for parallelism to a much higher number. It looks like it's at the default of 5. I usually bump mine...
"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 5:00 am
It does sound like bad parameter sniffing. In addition to recompile for the procedure, you can try recompile for the problematic statement within the procedure. Recompiles can be expensive, 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 25, 2011 at 4:58 am
mohan.pariveda 18256 (4/24/2011)
I am new to the SQL Server tuning and facing a critical performence problem.
My environment : Windows 2003 R2 (32 bit OS), SQL 2005 ENT, 8 GB...
"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:52 am
okan.okay (4/24/2011)
Check if tracing is on... It usually makes the system crawl...
Based on what. A server-side trace is one of the best ways to collect performance metrics. As long as...
"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:51 am
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
Viewing 15 posts - 12,661 through 12,675 (of 22,219 total)