Viewing 15 posts - 8,041 through 8,055 (of 22,226 total)
Yeah, of course. Both processes are going to use CPU and memory and I/O. Therefore there's a very distinct possibility that the two processes may be in contention on those...
"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
June 9, 2014 at 4:32 am
Extended events is not easier than trace, but it's pretty easy and certainly has less impact on the server. Books Online will get you going.
"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
June 5, 2014 at 2:50 pm
That's an excellent point. Sounds like you're doing fine. If you hit issues, you know where to go for help.
"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
June 5, 2014 at 2:31 pm
Lookup the data types of the underlying columns and then manually set them. That's the only way.
"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
June 5, 2014 at 2:10 pm
Sean Lange (6/5/2014)
http://www.sqlusa.com/bestpractices/%5B/url%5D
Don't worry there is soap for your eyes. Then if you read some of the content you may want to find...
"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
June 5, 2014 at 12:49 pm
sqldriver (6/5/2014)
"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
June 5, 2014 at 12:42 pm
patrickmcginnis59 10839 (6/5/2014)
Grant Fritchey (6/5/2014)
"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
June 5, 2014 at 12:39 pm
Jason Strate has a great example that shows the effects of NOLOCK.
But, one little thing, just on the side, why write code where you put NOLOCK everywhere. If you're 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
June 5, 2014 at 11:47 am
While you can use trace, extended events might be a better way to go. The filtering on trace events occurs after the event is captures while the filtering on extended...
"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
June 5, 2014 at 11:43 am
SQLRNNR (6/5/2014)
Grant Fritchey (6/5/2014)
"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
June 5, 2014 at 8:31 am
Please, please, please, bestester behavior, no piling on of any kind (or I'll delete the posts and I can do that, BWA-HA-HA-HA, THE POWER!, ahem, where was I), but 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
June 5, 2014 at 8:00 am
Those times are in milliseconds.
Usually, the way I measure performance for a query is to SET STATISTICS IO ON and SET STATISTICS TIME ON for the query window I'm operating...
"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
June 5, 2014 at 7:45 am
george sibbald (6/5/2014)
Is Dynamics AX a microsoft product, they 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
June 5, 2014 at 6:57 am
You're seeing no CXPACKET waits at all? That's a little abnormal in itself. Some of those waits are sure to bubble up in most systems. They're not any kind of...
"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
June 5, 2014 at 4:46 am
They could be coming from anywhere that can call the system with appropriate permissions. To know who made the call you'd need to set up extended events to monitor queries...
"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
June 5, 2014 at 4:41 am
Viewing 15 posts - 8,041 through 8,055 (of 22,226 total)