Viewing 15 posts - 13,231 through 13,245 (of 22,219 total)
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
Basic metrics such as wait states and queues, cpu load, disk i/o, these are the things that tell you the server is under load. It doesn't tell you why necessarily....
"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 15, 2011 at 11:25 am
I'm with Cold Coffee on this, there are mechanisms that don't involved a JOIN to put data from different tables together, but you're still defining some type of relationship between...
"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 15, 2011 at 10:10 am
Jeff Moden (2/15/2011)
The article also has the following statements:
...[font="Arial Black"]whereas, with a nonclustered index the leaf level contains the address 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
February 15, 2011 at 8:17 am
Jeff Moden (2/15/2011)
Grant Fritchey (2/15/2011)
Define a clustered index on the column that appears most frequently in the WHERE clause of SELECT
statements.
But not in JOIN criteria? No, no way....
"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 15, 2011 at 8:14 am
Paula-196779 (2/15/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 15, 2011 at 8:08 am
David Benoit (2/15/2011)
Grant Fritchey (2/15/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 15, 2011 at 7:31 am
Paula-196779 (2/15/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 15, 2011 at 7:29 am
Oh crud, and this is the point where I should have mentioned that my company has a couple of excellent backup compression products you might want to take a look...
"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 15, 2011 at 7:23 am
Grant Fritchey (2/15/2011)
You really, really, really should not do that, for at least the reason you just discovered. 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
February 15, 2011 at 7:22 am
Deletes are going to lead to indexes getting updated. That takes place in tempdb. Are you shrinking tempdb over & over? Don't do that. Grow it out to an appropriate...
"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 15, 2011 at 7:10 am
Calculating the transaction log is pretty difficult. Basically, the size of the data being sent into the system times the number of transactions. It's a tough one. Just remember that...
"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 15, 2011 at 7:08 am
On a side note, are you developing against the production database?
You really, really, really should not do that, for at least the reason you just discovered. If you take your...
"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 15, 2011 at 7:05 am
There are many excellent monitoring tools out there. Most of them get the job done. Mainly there are differences in approach and output. The thing to do is explore which...
"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 15, 2011 at 7:01 am
Viewing 15 posts - 13,231 through 13,245 (of 22,219 total)