Viewing 15 posts - 13,366 through 13,380 (of 22,219 total)
avinashily (2/8/2011)
and if suppose you have taken the trace output to a .trc file 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 8, 2011 at 8:06 am
A backup can be run from anywhere. You can run one from the command line in sqlcmd, you can run them from Query Analyzer, and most often, it's stored as...
"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 8, 2011 at 8:04 am
smushti (2/7/2011)
The explain plans are different in prod and test although test is a clone of prod.
The wait time and type are both...
"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 8, 2011 at 7:40 am
Also, also, be cognizant of the fact that just becuase you have a high cost in an execution plan, doesn't mean that the process itself is very high cost. Execution...
"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 8, 2011 at 7:31 am
Those waits are I/O related. Spend your time working on that. Don't worry about the memory for now. Keep an eye on it, of course, but don't focus there.
"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 8, 2011 at 6:41 am
Thank you Jeff!
"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 8, 2011 at 5:33 am
Trey Staker (2/7/2011)
Threadizens, What are you currently using to run virtual servers on your desktops/laptops?
VirtualPC and VirtualBox. Loath as I am to admit it, the Oracle product is better.
"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 7, 2011 at 10:30 am
Roy Ernest (2/7/2011)
Great. I will keep appending the list. 🙂
Hey Roy,
You can put me down for virtual presentations, absolutely. Travel is something I can do, but it's very limited, so...
"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 7, 2011 at 9:04 am
I need tons more information to even attempt to give you answer. A few places you should look, what process are you using to load? Is it a batch oriented...
"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 7, 2011 at 7:12 am
Are you shrinking the tempdb over & over? Please don't do that. It hurts the system in lots of ways.
If whatever you're processing needs to to use that much tempdb,...
"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 7, 2011 at 6:26 am
It may be an issue, and it may not. Any time someone puts forward numbers like that, you have to assume they're a guideline, not an absolute.
Are you monitoring waits?...
"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 7, 2011 at 6:19 am
I'm sorry I missed Friday night. I would have loved to have hung out with you guys. Jeff's fun when you get him going. SQL Saturday in Cleveland was 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 6, 2011 at 4:44 am
argaen21 (2/4/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 4, 2011 at 5:15 pm
mister.magoo (2/4/2011)
Thanks for that comment, but the trace is actually writing to a file on a separate physical disk, the the StopPerfTrace SP reads it in using fn_trace_gettable.
I am...
"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 4, 2011 at 7:29 am
For what it's worth, I came into databases from development. I got into development after film school and four years in the Navy as a nuclear power monkey mate. 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
February 4, 2011 at 7:25 am
Viewing 15 posts - 13,366 through 13,380 (of 22,219 total)