Viewing 15 posts - 11,371 through 11,385 (of 22,224 total)
ChiragNS (1/20/2012)
Grant Fritchey (1/20/2012)
Also you could be looking at a long compile time if the proc aged out of cache over night.
Will this result in such a huge performance degrade....
"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
January 20, 2012 at 6:09 am
Ninja's_RGR'us (1/20/2012)
Isn't it better to use 1222 rather than 1204??
Oh god. I can't believe I typed that. Yes, 1222 is better. I edited the post. Yikes.
"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
January 20, 2012 at 6:04 am
SQL Server doesn't have an in-memory setting. It works as it works and the disk is heavily involved. But if you're not seeing disk queuing, why would having everything in...
"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
January 20, 2012 at 6:01 am
What is your physical usage of those 8 processors now? Are they maxed? Sustained greater than 50%? Or, are they like most systems, sitting around at about 10% with only...
"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
January 20, 2012 at 5:56 am
Sounds like you need to run your log backups much, much more frequently. None of the mid-sized to large systems I've run would have worked well with a 6 hour...
"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
January 20, 2012 at 5:55 am
There's an internal blocking monitor that observes all blocks and looks for places where that cross-referenced lock exists. When it finds that, it identifies the least costly query by 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
January 20, 2012 at 5:52 am
Frequently with a linked server what happens is that ALL the data in referenced tables is brought across the wire and then filtered on the local server. If you use...
"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
January 20, 2012 at 5:49 am
curly brackets like that are for ODBC escape sequencing. It'll work... most of the time, but you might get really strange results some of the time. I wouldn't do 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
January 20, 2012 at 5:09 am
Also you could be looking at a long compile time if the proc aged out of cache over night.
"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
January 20, 2012 at 5:02 am
Good luck. The current version of the book doesn't emphasize wait stats nearly enough, so keep an eye on those. I hope the book proves helpful.
"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
January 19, 2012 at 6:39 pm
RIF? Reading Is Fundamental?
Educate the old guy.
"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
January 19, 2012 at 1:08 pm
Without more information I'm just guessing. It could be that different parameters for these queries results in simply different result sets. If it's accessing more data (the increased number of...
"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
January 19, 2012 at 12:40 pm
If you have the enterprise level of SQL SErver 2008 or better, you can use the Data Collection, also known as the Management Data Warehouse, to collect performance metrics about...
"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
January 19, 2012 at 12:09 pm
The precise formulas are totally propriatary, but basically it works off the statistics available about the indexes. The more accurate those stats are to the underlying data and the 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
January 19, 2012 at 12:05 pm
Jonathan Kehayias (1/19/2012)
Grant Fritchey (1/19/2012)
And if writing a book carries weight (I'd argue it doesn't, but...)
+1. A really good book isn't necessarily due to the authors own knowledge. ...
"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
January 19, 2012 at 10:42 am
Viewing 15 posts - 11,371 through 11,385 (of 22,224 total)