Viewing 15 posts - 8,041 through 8,055 (of 22,224 total)
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
Regardless of the source, those are still just queries coming into the system. If you're capturing query metrics using any of the common approaches such as querying the cache through...
"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:34 am
Connection timeouts can be tough to monitor for since you're usually monitoring for activity and this is the failure to generate any activity at all. By and large I would...
"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:30 am
Viewing 15 posts - 8,041 through 8,055 (of 22,224 total)