Viewing 15 posts - 10,831 through 10,845 (of 22,224 total)
Do you already have a backup process in place? Have you verified that your backups work? That means have you tested a restore? I'd start there as step one 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
June 4, 2012 at 5:19 am
pages/sec is just an indication of load. You don't know if it's high or low until you get a baseline to compare it 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
June 1, 2012 at 5:22 am
patrickmcginnis59 (5/31/2012)
Grant Fritchey (5/31/2012)
patrickmcginnis59 (5/31/2012)
Grant Fritchey (5/31/2012)
I'm with you. Fast enough is fast enough.
But, I remember when a friend of mine (wish I could say I did this) spotted a...
"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
May 31, 2012 at 12:07 pm
patrickmcginnis59 (5/31/2012)
Grant Fritchey (5/31/2012)
I'm with you. Fast enough is fast enough.
But, I remember when a friend of mine (wish I could say I did this) spotted a problematic query 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
May 31, 2012 at 11:34 am
donnapatriciakelly (5/31/2012)
I work in the Business Intelligence area, and deal with all sorts of source systems. Getting data...
"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
May 31, 2012 at 11:01 am
jfogel (5/31/2012)
patrickmcginnis59 (5/31/2012)
Grant Fritchey (5/31/2012)
TravisDBA (5/31/2012)
Sorry about that. I was trying to make the point that "generic" database designs aren't really possible due to the nature of the underlying infrastructure....
"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
May 31, 2012 at 9:55 am
Chris.C-977504 (5/31/2012)
Grant Fritchey (5/31/2012)
...I was trying to make the point that "generic" database designs aren't really possible due to the nature of the underlying infrastructure. Clearly failed.
Well you didn't completely...
"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
May 31, 2012 at 9:48 am
Rog Saber (5/31/2012)
"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
May 31, 2012 at 8:15 am
TravisDBA (5/31/2012)
Sorry about that. I was trying to make the point that "generic" database designs aren't really possible due to the nature of the underlying infrastructure. Clearly failed.
I'm a little...
"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
May 31, 2012 at 8:12 am
Chris.C-977504 (5/31/2012)
Now that I've read the whole article, I'm really not clear what your message is.
FWIW,
...
"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
May 31, 2012 at 7:39 am
A few reasons:
* I've got the "helper" gene. I try to pitch in & help out. Can't stop.
* It's a great way to learn how to do stuff
* I learn...
"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
May 31, 2012 at 5:10 am
Yeah, that's pretty normal. SQL Server ensures that each of the transactions within it maintains ACID properties (Atomic, Consistant, Isolated, Durable) through the use of locking. This prevents data from...
"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
May 31, 2012 at 5:06 am
You need to wait.
Long running transactions that fill the log need to be rewound, which can take longer than the original transaction. Rebooting doesn't help.
In the mean time, I'd suggest...
"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
May 31, 2012 at 4:31 am
You need a much more thorough collection of data in order to determine the causes of the high cpu. Yeah, it could be SQL Server, but from what you've said...
"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
May 31, 2012 at 4:27 am
Alex-668179 (5/31/2012)
Fine, but should it then also always be the (preferably meaningless?) primary key? Or an index that is more likely...
"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
May 31, 2012 at 3:41 am
Viewing 15 posts - 10,831 through 10,845 (of 22,224 total)