Viewing 15 posts - 14,776 through 14,790 (of 22,219 total)
balasach82 (6/28/2010)
Thats a great way of explaining. Now I understand. Its complicated to get the query's count(which query ran how many times).
Still having one doubt.. that fileds with NULL values.....
"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 28, 2010 at 7:30 am
The text data field shows the full query, including parameters passed. Take these two calls as an example:
EXEC spMyProc @parm1 = 42, @parm2 = 'Optional Parameter'
EXEC spMyProc @parm1 = 42
Now,...
"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 28, 2010 at 7:13 am
Not to mention that the out of the box security settings are pretty tight:
Script exec is prohibited by default
ps1 is not associated with the shell
must provide a path to 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
June 28, 2010 at 6:59 am
There a number[/url] of articles[/url] right here on SSC that can help you out. You just need to use the Search window over there in the upper right to track...
"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 28, 2010 at 6:56 am
Jeff Moden (6/27/2010)
Lynn Pettis (6/27/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 28, 2010 at 5:44 am
GabyYYZ (6/25/2010)
Lynn Pettis (6/25/2010)
Steve Jones - Editor (6/25/2010)
Send me pix, I'm happy to wait for Oct here. I...
"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 11:07 am
Sounds basically accurate to me. The only addition I would make is to be careful about the shrink process. It can lead to other issues, including file fragmentation. If 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 25, 2010 at 8:42 am
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
Viewing 15 posts - 14,776 through 14,790 (of 22,219 total)