Viewing 15 posts - 13,216 through 13,230 (of 22,227 total)
Brandie Tarvin (2/16/2011)
"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
February 16, 2011 at 12:23 pm
Brandie Tarvin (2/16/2011)
exec @rc = sp_trace_create @TraceID output, 0, N'\\servername\D$\Folder\Trace_1', @maxfilesize, NULL, @filecount
Should be
exec @rc = sp_trace_create @TraceID output,...
"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
February 16, 2011 at 12:21 pm
Anna_SQL (2/16/2011)
One time when one of our servers got a hang or ran very slow, I tried...
"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
February 16, 2011 at 12:12 pm
Your second parameter, which is 0, should be set to 2, which enables rollover.
"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
February 16, 2011 at 12:04 pm
Sounds like you have both problems. I'd attack each one, but try to do it individually so that you can determine if adding memory helps or if getting better, more,...
"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
February 16, 2011 at 11:58 am
Just because it's faster to save unstructured data in a striaght write to disk than it is to a database. You're dealing with all the overhead of SQL Server when...
"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
February 16, 2011 at 11:56 am
Performance monitor is absolutely one of the tools you want to know how to operate to understand what's happening on the server, but if you're trying to determine why 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
February 16, 2011 at 11:48 am
SKYBVI (2/16/2011)
@ grantUrs book on sql server exceution plans is meant for sql 2005 or 2008 or is it just a general book.
Regards,
Sushant
It's written for 2005, but it's largely applicable...
"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
February 16, 2011 at 9:29 am
Pouliot Philippe (2/16/2011)
Grant Fritchey (2/16/2011)
"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
February 16, 2011 at 8:25 am
Well, no, not really. You're saying that the other tables have no type of relationship to the other data at all, but, you want to somehow put it all together.......
"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
February 16, 2011 at 8:23 am
kvr1985 (2/16/2011)
thank you guys. it's working.i have a one more doubt how to do server wide trace?
Please read the article I posted. That's how you do a trace.
"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
February 16, 2011 at 8:19 am
I ran a series of tests, years ago, where I opened multiple default traces on SQL Server. I had 20 running at the same time and i didn't change 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
February 16, 2011 at 8:15 am
That is a GIANT topic. You really need to develop your own story. If you don't have the knowledge yet to be able to walk someone through what you would...
"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
February 16, 2011 at 7:34 am
GilaMonster (2/16/2011)
Ian Scarlett (2/16/2011)
Grant Fritchey (2/16/2011)
but I think I'm right on this one if implicit transactions are on.
I also thought that if you executed a procedure on a connection with...
"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
February 16, 2011 at 7:19 am
Marco V (2/16/2011)
Grant Fritchey (2/16/2011)
And now it's a new one. It was time to change.did the post trigger it?
Yep. Wouldn't have bothered probably. I'm not overly driven by it. Just...
"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
February 16, 2011 at 7:07 am
Viewing 15 posts - 13,216 through 13,230 (of 22,227 total)