Forum Replies Created
Viewing 15 posts - 12,376 through 12,390 (of 22,219 total)
-
RE: CXPACKET Wait - advice on Max Dop setting
I would not recommend setting MAXDOP to 1 for most systems. Instead, I'd experiment with bumping up the cost threshold for parallelism. The default value of 5 is way too...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Alias Problems
Nope, server aliases are a shortcut for local connections, not a way to rename the server.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Determining last update to a table
What version of SQL Server are you running? If it's SQL Server 2000, that would explain your issue.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
Tom.Thomson (6/10/2011)
Kit G (6/9/2011)
GilaMonster (6/9/2011)
Stefan Krzywicki (6/9/2011)
I think I'd be more worried about someone with a gladius on a subway car. A claymore is a lot of steel in a..."The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: your spare time?
Spare time? Interesting concept as I sit here in an airport traveling back from a user group meeting and posting online here.
Write books and help run a scout troop,...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: sys.dm_os_performance_counters
those counters can be accessed through TSQL Queries. There is no set-up required. The Windows OS is maintaining that data for you all the time. Running the query simply accesses...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: SQL Function performance / design question
You're running into the basic problems with table variables. They don't have statistics. So, while coding in them looks very neat and clean, performance is a total bear. You're doing...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: query running slow
There are differences between the systems already identified. I suspect if you dig you'll find more. You can't have differences, especially as big as different service packs, and still expect...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
GilaMonster (6/9/2011)
I post too much.Congratulations, and no 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 RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Recompilation Reason: "FOR BROWSE PERMISSIONS CHANGED"
That is a weird one. Sorry I couldn't help.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: DMV's
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 RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Why compatibilty level is important
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 RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: query running slow
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 RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Query is running slowly in morning times and it is running normally in evening times.
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 RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
Kiara (6/9/2011)
Tom.Thomson (6/9/2011)
Kit G (6/8/2011)
Wearing boots with a kilt isn't a problem (as long as we have socks). But sandals and a kilt? Perhaps... maybe... in a Roman..."The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 15 posts - 12,376 through 12,390 (of 22,219 total)