Viewing 15 posts - 15,241 through 15,255 (of 22,227 total)
Jeffrey Williams-493691 (4/29/2010)
When you rebuild your indexes - do you by chance have the following setting?STATISTICS_NORECOMPUTE = ON
Oooh, good catch. That's entirely possible.
"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
April 30, 2010 at 5:22 am
noeld (4/29/2010)
Lynn Pettis (4/29/2010)
Anyone seen the OP since this morning?
Forget it ... we know the answer is that it is probably in GB .... or who knows if it was...
"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
April 29, 2010 at 1:15 pm
Then I'm stumped. It doesn't make any sense. To do an index rebuild, a full scan of the data is required and all new statistics based on the full scan...
"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
April 29, 2010 at 1:14 pm
ankitwaitshere (4/29/2010)
The primary database is a heavily transactional OLTP database for a Shipping-System. Currently, the database is serving 2 major purposes: 1- routine shippping/scanning etc, 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
April 29, 2010 at 12:45 pm
No, not knowing more, I wouldn't call it a bug. It's probably something to do with statistics after the rebuild, but I'm just a bit surprised by it because an...
"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
April 29, 2010 at 12:45 pm
Ah I get it. Performance goes down after the indexes are rebuilt and comes back up after the statistics are updated. Got it.
Well, it's hard to say precisely what 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
April 29, 2010 at 12:20 pm
It has to be unique to add a unique constraint. So you either modify the data to make it unique, or you modify the structure, adding, for example, an identity...
"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
April 29, 2010 at 11:56 am
If I understand what you said, statistics updates are taking 12 hours? That's a pretty serious problem. How big is the database in question?
"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
April 29, 2010 at 11:54 am
I sure wouldn't recommend triggers as a mechanism for this.
It really depends on what your business needs are. If you have the need for a near real time copy 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
April 29, 2010 at 11:52 am
Yeah, rearchitect the storage so that you've got normalized data.
Barring that, look at this approach for delimited lists from Jeff Moden[/url]. It'll help.
"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
April 29, 2010 at 11:48 am
I'm not aware of third party SCOM management packs for SQL Server. Microsoft has a management pack for SQL Server. We use it to do most of our SQL Monitoring....
"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
April 29, 2010 at 11:28 am
First things first, contact Blythe Morrow (blythe.morrow@sqlpass dot org) at PASS. They have a starter kit and an infrastructure that will get you going. After that, get help. There are...
"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
April 29, 2010 at 11:13 am
ricardo_chicas (4/29/2010)
I just did the Update statistics and retrieve the ten million rows is two minutes, so I am happy nowThanks to all of you
Ah, so the FULL SCAN did...
"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
April 29, 2010 at 11:03 am
izdede (4/29/2010)
In fact, I have tried restarting my machine to no...
"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
April 29, 2010 at 10:42 am
Luke L (4/29/2010)
Tom.Thomson (4/29/2010)
Dave Ballantyne (4/29/2010)
We can hate them both. Besides, they won't stop sending us beer. If you drink it, they'll keep exporting it.
You can always mark you share...
"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
April 29, 2010 at 9:40 am
Viewing 15 posts - 15,241 through 15,255 (of 22,227 total)