Viewing 15 posts - 3,241 through 3,255 (of 22,224 total)
If you're on the eastern seaboard of the US and you hear a grinding noise, it's just my teeth.
"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 12, 2018 at 6:46 am
OK. Not sure what that script has to do with things.
You're saying that on a server with zero actual load, a query constitutes 56% of the perceived CPU...
"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 12, 2018 at 6:44 am
Ah, I think I better understand. Well, that can be tough. If the applications all supply their application name with their connection activity (not required), then you can monitor connections...
"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 12, 2018 at 5:51 am
"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 12, 2018 at 5:49 am
"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 12, 2018 at 5:10 am
"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 12, 2018 at 5:07 am
So, the databases all have the same name? If so, you can't put them all on the same instance. So, your options are, in the case of server consolidation, 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
April 12, 2018 at 4:35 am
I won't be able to give you a total run down on everything, but let's cover a few of the topics you raise. We'll start just at the data center. "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood" Author of:
- Theodore Roosevelt
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 12, 2018 at 4:31 am
Alexander Zhang - Wednesday, April 11, 2018 1:36 PMBTW, there is no specific purpose, but for some unreasonable and stupid curiosity:-)
Have fun.
Maybe...
"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 11, 2018 at 1:41 pm
"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 11, 2018 at 12:40 pm
"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 11, 2018 at 6:56 am
"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 11, 2018 at 5:53 am
I do occasionally listen to music. I'm sure that's the same.
"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 11, 2018 at 5:19 am
This bit of code:
like '%[^a-z0-9]william%[^a-z0-9]%'
Means that you're always going to be seeing scans of whatever indexes you have. I'm with Eirikur (always), in...
"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 11, 2018 at 5:12 am
Looks like the problem is the CONVERT inside the ISNUMERIC command. It has to resolve that CONVERT in order to determine whether or not things are a number or not....
"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 11, 2018 at 5:07 am
Viewing 15 posts - 3,241 through 3,255 (of 22,224 total)