Viewing 15 posts - 12,661 through 12,675 (of 22,227 total)
Ninja's_RGR'us (4/26/2011)
Grant Fritchey (4/26/2011)
You need a fundamental assessment of the system done. It sounds...
"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 26, 2011 at 6:17 am
I would look first at the SQL Server error log. You can see that in the Management folder in SSMS. I would also look at the Event Viewer on 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
April 26, 2011 at 6:03 am
Referential integrity is also a speed issue. It speeds things up. Here's a blog post outlining why[/url].
You need a fundamental assessment of the system done. It sounds like you don'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 26, 2011 at 6:00 am
Absolutely possible. Pretty common task really. It's an easy way to get a database from one system to another. When you run the restore operation you'll probably have to use...
"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 26, 2011 at 5:56 am
Without knowing lots more about your system, there's no way to know why it's running longer. It could be parameter sniffing. It could be blocking. It could be a hundred...
"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 26, 2011 at 5:54 am
nico van niekerk (4/26/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 26, 2011 at 5:45 am
I have to say, after almost 3 months of working from home, I'm still not used to it. However, I love it. I'm getting tons of work done. I get...
"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 26, 2011 at 5:39 am
David Burrows (4/25/2011)
Grant Fritchey (4/25/2011)
... I usually bump mine up to 35 or so on OLTP systems.Is that a general rule of thumb?
Are there any consequences to that setting?
Not really....
"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 8:35 am
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
Viewing 15 posts - 12,661 through 12,675 (of 22,227 total)