Viewing 15 posts - 9,466 through 9,480 (of 22,219 total)
GilaMonster (10/4/2013)
I mean the normal dictionary definition of the word.An OLTP system does not automatically have low PLE from being a OLTP system.
Absolutely not. We had OLTP systems with insanely...
"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
October 4, 2013 at 3:20 pm
Jeff Atherton (10/4/2013)
SQLBill (9/30/2013)
Guru's Guide to Transact-SQL by Ken Henderson is my most-read book on SQL Server.-SQLBill
Haven't heard of this one before and all I can find is a version...
"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
October 4, 2013 at 8:55 am
There are multiple causes for this message. Without more information, it's really hard to suggest what it might be. Have you checked the error logs on the server to see...
"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
October 4, 2013 at 4:33 am
Don't get too hung on page life expectancy. It's not a measure of performance really, but an indicator of certain behaviors within the system. I've seen servers that were performing...
"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
October 4, 2013 at 4:10 am
Another approach is to use the queries in cache and the execution plans missing index hints to identify the queries that are called frequently or are actually running slow that...
"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
October 3, 2013 at 12:07 pm
Something is flushing the data out of cache. You'll want to look for long running queries or queries that are moving very large amounts of data (even if they're 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
October 3, 2013 at 12:04 pm
Stefan Krzywicki (10/3/2013)
Grant Fritchey (10/3/2013)
Brandie Tarvin (10/3/2013)
There is a little code at the bottom that has to be entered before you hit the post button. Did you enter that, Grant?
Yep....
"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
October 3, 2013 at 11:53 am
Brandie Tarvin (10/3/2013)
There is a little code at the bottom that has to be entered before you hit the post button. Did you enter that, Grant?
Yep. Ah well.
"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
October 3, 2013 at 11:37 am
Brandie Tarvin (10/3/2013)
Grant Fritchey (10/3/2013)
Brandie Tarvin (10/3/2013)
Odd. I don't see your post yet, Grant. Does MSSQL moderate their comments?Weird. Still nothing. Jeremy must be very unhappy with me.
Can you see...
"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
October 3, 2013 at 11:36 am
Brandie Tarvin (10/3/2013)
Odd. I don't see your post yet, Grant. Does MSSQL moderate their comments?
Weird. Still nothing. Jeremy must be very unhappy with me.
"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
October 3, 2013 at 11:10 am
WayneS (10/3/2013)
Who is going to the Summit this year? (I need to figure out who to meet up with...)
I might swing by, for at least part of it.
"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
October 3, 2013 at 11:09 am
Sounds like a good idea. I sure wouldn't mind getting good reviews from people using the information produced.
You might want to check out the SQL Book Club.
"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
October 3, 2013 at 8:48 am
Brandie Tarvin (10/3/2013)
Odd. I don't see your post yet, Grant. Does MSSQL moderate their comments?
Not a clue. They might.
"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
October 3, 2013 at 8:06 am
Brandie Tarvin (10/3/2013)
Grant Fritchey (10/3/2013)
Brandie Tarvin (10/3/2013)
Why, oh, why do people keep perpetuating (or creating) myths about backups? And in an article about interview questions no less.
I wouldn't hire...
"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
October 3, 2013 at 6:49 am
Brandie Tarvin (10/3/2013)
Grant Fritchey (10/3/2013)
Brandie Tarvin (10/3/2013)
Why, oh, why do people keep perpetuating (or creating) myths about backups? And in an article about interview questions no less.
I wouldn't hire...
"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
October 3, 2013 at 6:31 am
Viewing 15 posts - 9,466 through 9,480 (of 22,219 total)