Viewing 15 posts - 14,791 through 14,805 (of 22,227 total)
It doesn't sound like the log file has been broke, just improperly configured and managed.
Whether or not 5gb is the correct size really depends on the number and size 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 25, 2010 at 8:23 am
yessen (6/24/2010)
GilaMonster (6/23/2010)
"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 25, 2010 at 5:49 am
balasach82 (6/24/2010)
right now, a bit confused. "The trace file wont tell you how many transactions there have been , for that you need to summarise the perfmon data"... any idea...
"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 24, 2010 at 8:16 am
GilaMonster (6/23/2010)
Hehehttp://icanhascheezburger.com/2010/06/23/funny-pictures-call-911/
http://icanhascheezburger.com/2010/06/22/funny-pictures-no-wayz/
Yeah, the planet should send that second down to SA.
"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 23, 2010 at 12:59 pm
Yep, it really is down to the OS.
In general file fragmentation shouldn't be that big a deal. Have you eliminated all other issues on the server that could cause performance...
"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 23, 2010 at 10:24 am
Whoa! No, don't do that. You'll be shooting yourself in the face (yes, face, not foot). I put out a small blog post[/url] on this, just today, that addresses this...
"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 23, 2010 at 8:12 am
Ninja's_RGR'us (6/22/2010)
Grant Fritchey (6/22/2010)
In general, especially for the size of systems you're talking about, I'd seperate these installs to seperate machines.
2 or 3?
They're not even sure they need the technologies,...
"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 22, 2010 at 1:16 pm
In general, especially for the size of systems you're talking about, I'd seperate these installs to seperate machines.
"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 22, 2010 at 11:53 am
GilaMonster (6/22/2010)
Grant Fritchey (6/22/2010)
I'll see if I can't get others to comment on it as well.
What happens if the user goes for lunch leaving the screen open, then decides 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 22, 2010 at 9:33 am
Inserts or deletes are occurring on the system at the same time that you're trying to read it, but the information that was being scanned has been moved. 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 22, 2010 at 9:23 am
A little help over here would be appreciated
"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 22, 2010 at 9:19 am
mshah23 (6/22/2010)
What is the problem do you see on the above solution?
Just as a starting point, what happens if, within the transaction you're holding open, you need to read...
"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 22, 2010 at 9:17 am
mshah23 (6/22/2010)
That's why I want...
"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 22, 2010 at 8:36 am
By and large in SQL Server you don't want to try to control locking. In general it does row level locking by default, all on it's own.
Why are you...
"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 22, 2010 at 8:15 am
Greg Edwards-268690 (6/22/2010)
Paul White NZ (6/22/2010)
Schadenfreude-Mei (6/22/2010)
Seriously, how do these people get to a point where they are even alowed to look at a live server :crazy:
I guess it's because...
"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 22, 2010 at 6:30 am
Viewing 15 posts - 14,791 through 14,805 (of 22,227 total)