Viewing 15 posts - 13,231 through 13,245 (of 22,232 total)
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
Ian Scarlett (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 7:02 am
And now it's a new one. It was time to change.
"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 6:59 am
muten79 (2/16/2011)
I have been having a read about best practices when designing a database.
I have developed an application using OIDs (object identifiers) for any class I will store 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
February 16, 2011 at 6:53 am
No one script is going to tell you what you need. There are just too many variables that you haven't defined for me to suggest a single point of focus....
"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 5:28 am
kvr1985 (2/16/2011)
thank you for informationi will read the article later .how can find the slow running queries.
You can find slow running queries by using a server-side trace to gather metrics...
"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 5:25 am
Assuming a standard stored procedure, when the procedure reaches it's end. With a query outside of a procedure, when the batch completes (there's a go statement or it's the end...
"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 4:34 am
There was a chat about Babylon 5 one day and I decided to switch. I'm too lazy to make it something else. That's about it.
"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 4:32 am
Are you sure the only difference is hardware? How much different is that hardware? Are there multiple CPU's in UAT but not in Dev or vice versa? What are the...
"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 4:31 am
That's a very broad topic. What's going wrong? What have you not been able to do? Are parts working but not other parts?
I've posted an article here on SSC[/url]...
"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 4:25 am
You want to set up a server side trace to do that. I have a small article here on SSC[/url] describing how to do it.
"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 4:19 am
Viewing 15 posts - 13,231 through 13,245 (of 22,232 total)