Viewing 15 posts - 15,691 through 15,705 (of 22,227 total)
CirquedeSQLeil (3/16/2010)
Grant Fritchey (3/16/2010)
What about a simple backup and restore? Or are you trying to build some sort of deployment mechanism?
Backup and restore would be my first inclination for users...
"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 16, 2010 at 10:31 am
Steve Jones - Editor (3/16/2010)
I have had some authors that we have gone through 5 or 6 drafts to get a barely understandable article.
And I've apologized for that over &...
"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 16, 2010 at 10:30 am
I'm not aware of a precise method for calculating your number, but if I wanted to make an educated guess, I'd query the procedures that are currently in cache 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 16, 2010 at 10:29 am
Lynn Pettis (3/16/2010)
Grant Fritchey (3/16/2010)
"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 16, 2010 at 10:24 am
ESAT ERKEC (3/16/2010)
I think you can look at the query parralesim parameter in the server.
Which one specifically?
"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 16, 2010 at 10:24 am
malachyrafferty (3/16/2010)
currently the cost threshold is set at 5 - i have no idea what 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
March 16, 2010 at 9:18 am
CirquedeSQLeil (3/16/2010)
Grant Fritchey (3/16/2010)
CirquedeSQLeil (3/15/2010)
george sibbald (3/15/2010)
Always...
"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 16, 2010 at 9:12 am
Steve Jones - Editor (3/16/2010)
Actually we're not. We try to get a wide variety of opinions and styles. Happy to get some people writing from 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 16, 2010 at 8:54 am
malachyrafferty (3/16/2010)
CXPACKET 3344303.7276.4476.44
PAGEIOLATCH_SH 407470.349.3185.76
LCK_M_SCH_M 173911.163.9889.73
ASYNC_NETWORK_IO 118890.632.7292.45
BROKER_TASK_STOP 93700.662.1494.59
LCK_M_S91672.272.10 96.69...
"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 16, 2010 at 8:48 am
Paul White (3/16/2010)
Grant Fritchey (3/16/2010)
Yeah, it was absolutely top notch. Too bad he didn't write it for the Standard. I would have paid more. 😀
$500!!!
But, you must:
Have 5 years professional...
"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 16, 2010 at 8:36 am
It's all based on the estimated costs of the query as determined by the optimizer. If that estimate is higher than the cost threshold for parallelism, then you have 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 16, 2010 at 8:32 am
Yep, that's it. It's a DMV to give you a view into what things are waiting for what in the server. You'll need to look in BOL or online at...
"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 16, 2010 at 8:28 am
There's still not enough information to see exactly what the cause of slow performance might be. I'd suggest you gather data using sys.dm_os_wait_stats. Get that information together over a period...
"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 16, 2010 at 7:24 am
sp_executesql is actually one of the best ways to run ad hoc tsql because you can parameterize it and get more plan reuse.
It sounds like, possibly, you're hitting a parameter...
"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 16, 2010 at 7:00 am
It's possible that it's a memory issue. What other metrics have you gathered? Do you have wait statistics available? That will tell you what things are waiting on, 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
March 16, 2010 at 6:58 am
Viewing 15 posts - 15,691 through 15,705 (of 22,227 total)