Viewing 15 posts - 12,391 through 12,405 (of 22,224 total)
I would pick up a copy of Louis Davidson's and Tim Ford's book. That will give you a bunch of the standard DMOs and how to use them.
"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, 2011 at 6:53 am
Basically, if the compatibility level is set to a lower value than the current value of the server, you will have reduced functionality in that database.
"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, 2011 at 6:51 am
First thing to compare between the three servers is the execution plan. If it's identical on all three, then you need to look at server settings. If it's different, first...
"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, 2011 at 6:48 am
An execution plan isn't going to tell you that tempdb is 97% of usage. It's giong to tell you that you have index scans instead of seeks or a loop...
"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, 2011 at 6:33 am
Kiara (6/9/2011)
Tom.Thomson (6/9/2011)
Kit G (6/8/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
June 9, 2011 at 6:29 am
GilaMonster (6/9/2011)
Is this person irritating anyone else, or am I just in low-tolerance mode at the moment?
Some of the posts seem... less than original.
"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, 2011 at 6:27 am
GilaMonster (6/9/2011)
Stefan Krzywicki (6/8/2011)
Kit G (6/8/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
June 9, 2011 at 6:26 am
Stefan Krzywicki (6/8/2011)
Kit G (6/8/2011)
Grant Fritchey (6/8/2011)
I hate to tell you this, but I wear sandals, sneakers & boots with kilts, but...
"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 8, 2011 at 3:35 pm
andykr-773587 (6/8/2011)
Thanks for the input though, I will report back if I find anything.
(When will you be out our way again?...
"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 8, 2011 at 3:33 pm
Itzik's books are some of the first I recommend. After that, get a copy of Kalen Delaney's book SQL Server Internals. Since you're just getting going, you might want 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
June 8, 2011 at 1:59 pm
I don't think you can do this with Profiler. You can do it using Extended Events though.
"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 8, 2011 at 1:57 pm
In general, I'm always wary to shrink log files until I'm sure that I've got them under control so I know what size they really ought to be. 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
June 8, 2011 at 1:53 pm
Finished my 3 mile contribution gotta go log it.
I hate to tell you this, but I wear sandals, sneakers & boots with kilts, but I seldom wear long socks with...
"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 8, 2011 at 12:52 pm
Yes, it could be the connection, but then I'd expect that to affect the query on both sides.... although, maybe not. Maybe only on the hop. I'm not sure.
"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 8, 2011 at 12:50 pm
That is not one I've run into before. I'd check to see if there are differences between the databases. I'd focus on the collation and the ANSI connection settings. Something...
"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 8, 2011 at 9:53 am
Viewing 15 posts - 12,391 through 12,405 (of 22,224 total)