Viewing 15 posts - 13,366 through 13,380 (of 22,227 total)
SKYBVI (2/8/2011)
I am the only guy who does the backup so im pretty sure that the backups are...
"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:59 am
Tom Brown (2/8/2011)
Just wondered why, no one mentioned VmWare or Hyper-V?
As far as I know Hyper-V is only available on Windows 2008 Server...
"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:56 am
No, I think you might be in a minority there. Where I was working was using PBM to monitor backup age, agent status, and a bunch of other server settings...
"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:38 am
I think that you installed SQL Server Express. That doesn't support SQL Agent. You can't install it because it just won't work. You have to look for some other method...
"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:37 am
It can be, but I thought you were more interested in what was running the backup process so you can get some control & understanding.
"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:17 am
parissa_bakhshi (2/8/2011)
another question is that I didn't see any wait resource showing CPU...
"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:12 am
If you're looking to focus on system metrics, then why would you set up a trace? That's for tactical measures of the performance of individual queries. If you want 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 8, 2011 at 8:08 am
lianv 90648 (2/8/2011)
Thank you for the feedback. I just like to know how this can be scripted and scheduled in a job ?
Yes, use the script supplied by avinashily above.
"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
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
Viewing 15 posts - 13,366 through 13,380 (of 22,227 total)