Viewing 15 posts - 9,466 through 9,480 (of 22,224 total)
Backups and restores.
Oh, those weren't on the list. I'm going to support Gail's answer. If you spend more time building and designing systems, having a working knowledge of how the...
"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 7, 2013 at 6:17 am
Excellent editorial Steve.
At my previous employer we spent years and interviewed hundreds of people trying to find qualified DBAs. This story, someone knows a few things and repeats them for...
"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 7, 2013 at 4:29 am
What Gail said.
But, if you really want to avoid adding too much additional overhead to the system, then instead of a trace, I'd look at extended events. They're much more...
"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 7, 2013 at 4:11 am
I would not suggest turning it off, no. You can add additional traces if you need them, but the default trace captures a basic set of information about what's happening...
"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 5, 2013 at 5:30 am
I would suggest focusing first on wait stats to understand what is causing the server to run slow. But, if you want to know if you're out of memory, going...
"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 5, 2013 at 5:24 am
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
Viewing 15 posts - 9,466 through 9,480 (of 22,224 total)