Viewing 15 posts - 7,171 through 7,185 (of 22,226 total)
GilaMonster (12/2/2014)
Grant Fritchey (12/2/2014)
GilaMonster (12/2/2014)
Grant Fritchey (12/2/2014)
You may need to re-schedule them so they run less frequently, but you may just need to get more hardware.
Or restore the backups to...
"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
December 2, 2014 at 7:22 am
npranj (12/2/2014)
As for the Identity Column CI - we will not be using this column in any query.
So what should...
"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
December 2, 2014 at 6:52 am
GilaMonster (12/2/2014)
Grant Fritchey (12/2/2014)
You may need to re-schedule them so they run less frequently, but you may just need to get more hardware.
Or restore the backups to another server 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
December 2, 2014 at 6:48 am
It sounds like your server is seriously underpowered. I've seen DBCC impact performance in some ways, but it doesn't take the database offline, at all, by design. So if your...
"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
December 2, 2014 at 6:32 am
Have you looked at the documentation available from Microsoft. Here's the command line install documentation and the configuration file install documentation. Both of those have examples available that you can...
"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
December 2, 2014 at 6:28 am
npranj (12/1/2014)
The 42% cost is Clustered Index insert cost. There is one CI and 4 NCI on this table.
All the other costs are from Index Seeks.
Also, this PK...
"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
December 2, 2014 at 6:04 am
Jeff Moden (12/1/2014)
Grant Fritchey (12/1/2014)
Just because it's not an incrementing number doesn't mean that it's not a good choice for the clustered index.
I have to admit that I'm taken aback...
"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
December 2, 2014 at 5:59 am
kevaburg (12/2/2014)
Grant Fritchey (12/1/2014)
"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
December 2, 2014 at 5:51 am
Nah, the other plan knew that it was only returning a single row from the seek too.
Pretty sure Scott's onto something. Indexes sure won't hurt and if you can...
"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
December 1, 2014 at 5:51 pm
Robert Frasca (12/1/2014)
Grant Fritchey (12/1/2014)
"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
December 1, 2014 at 11:26 am
The pain point on the WithMAX plan is the fact that it's doing a Loops join against 1.9 million rows. That's effectively a cursor. But, it looks like your full...
"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
December 1, 2014 at 10:54 am
On most systems, most of the time, the vast majority of tables should have, at minimum, a clustered index. I'll bet if you put it on the right place, 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
December 1, 2014 at 8:50 am
Just because it's not an incrementing number doesn't mean that it's not a good choice for the clustered index. Also, the cost of an insert is usually quite high 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
December 1, 2014 at 7:50 am
The trick would be to look at the execution plan to understand how your delete statement is being processed. Table scans can be costly depending on the size of your...
"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
December 1, 2014 at 3:35 am
Always go the Books Online for knowledge fundamentals. It's the single best and most accurate resource you have.
"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
November 28, 2014 at 8:52 am
Viewing 15 posts - 7,171 through 7,185 (of 22,226 total)