Viewing 15 posts - 10,051 through 10,065 (of 22,219 total)
PiMané (2/7/2013)
Grant Fritchey (2/7/2013)
"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
February 7, 2013 at 5:45 am
That calculation is for a minimum healthy value but even that is to be measured against your server over time. But the biggest key word there is: minimum. A higher...
"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
February 7, 2013 at 5:38 am
Brandie Tarvin (2/7/2013)
Oh, heavens. A non-tech webcomic commenting on data consistency.I am amused: http://www.sandraandwoo.com/%5B/url%5D
Excellent!
"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
February 7, 2013 at 5:04 am
Gail also covers setting up server-side trace in her articles on query tuning[/url].
"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
February 6, 2013 at 9:05 am
Just be sure you're using no data types in the newer server that can't exist in the older (or other code constructs). You should be able to export the scripts...
"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
February 6, 2013 at 9:03 am
I won't say bad things about the competition, but be sure you do a VERY thorough evaluation of the Quest/Dell offerings. Just saying.
"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
February 6, 2013 at 6:53 am
If you're talking data changes there's no automatic auditing within SQL Server by default. You can look to extended events as a mechanism to see all data changes by capturing...
"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
February 6, 2013 at 5:12 am
DISCLOSURE: I work for Red Gate Software.
I've used all the major tools and most of them against a production environment. Each of them does different things for you in varying...
"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
February 6, 2013 at 5:10 am
Shadab Shah (2/6/2013)
GilaMonster (2/6/2013)
"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
February 6, 2013 at 4:24 am
k.srikalyan (2/6/2013)
"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
February 6, 2013 at 4:05 am
Another option on the parallelism is to look at the cost threshold for parallelism. That's usually left at the default value of 5 which is WAY too low for most...
"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
February 5, 2013 at 4:32 pm
The optimizer doesn't believe that all six tables are needed in the query. Just saying. It's using a subset of what you defined.
"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
February 5, 2013 at 4:30 pm
Unless you're in a situation where you are already CPU bound, I would absolutely enable compression on backups. Usually, most systems are IO bound. If you can reduce IO, it's...
"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
February 5, 2013 at 4:12 pm
CXPacket waits are an indication of parallelism. Not to say that parallelism is the issue, just that it's going on. Something you'd have to validate.
The latch waits are absolutely and...
"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
February 5, 2013 at 4:10 pm
You've got a two second compile time on a query that's not all that complex. But, you're referencing six tables and the optimizer is only pulling data from four (plus...
"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
February 5, 2013 at 4:08 pm
Viewing 15 posts - 10,051 through 10,065 (of 22,219 total)