Viewing 15 posts - 9,241 through 9,255 (of 22,232 total)
You may also want to take a look at Extended Events within SQL Server. You can set them up to capture all the queries that are run against the system....
"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
December 18, 2013 at 5:00 am
Yeah, it sounds like the account that it's running under doesn't have access. Validate which account is running Agent. Make sure it's an account with access to your network and...
"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
December 18, 2013 at 4:49 am
Unless you need to learn hybrid environments, I wouldn't bother setting up a system at home any more. Do you have access to an MSDN license through work? If 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
December 18, 2013 at 4:47 am
In my youth, I loved getting involved with online arguments. For some reason, as I've aged, I just walk away from the goofy things. To a degree, this feels like...
"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
December 17, 2013 at 8:26 pm
inevercheckthis2002 (12/17/2013)
I thought...
"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
December 17, 2013 at 10:05 am
I'd suggest getting a copy of my book. I go through all the information you're asking in great detail. The 2008 version is more applicable for your 2005 instance, but...
"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
December 17, 2013 at 10:00 am
defyant_2004 (12/17/2013)
"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
December 17, 2013 at 9:59 am
I know there is a way to do it, yes, but I'm not familiar with it. It's actually something I need to spend some time getting my arms around and...
"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
December 17, 2013 at 9:49 am
KumarVelayutham (12/17/2013)
Based on my understanding,Microsoft assessment and planning tool will help to get the load and all details for each and every server.Is it right?
Not at all.
As Richard says, you'll...
"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
December 17, 2013 at 6:27 am
Honestly, I can't.
How much CPU does each of those servers use? If one is maxed out on memory, we probably don't want to put it into a VM, but from...
"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
December 17, 2013 at 5:39 am
I have to ask, how, possibly, from a listing of servers could I tell you which of the databases on those servers would need mirroring? How could I? Possibly? Further,...
"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
December 17, 2013 at 5:25 am
The restore won't change the compatibility level, you have to do that as a second step.
Even if you create the database in 2012, when you restore the 2005 backup, it's...
"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
December 17, 2013 at 5:19 am
chandan_jha18 (12/17/2013)
Grant Fritchey (12/17/2013)
If the table has 100K of records, this looks like it's also returning over 100K of records. Is the WHERE clause not filtering...
"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
December 17, 2013 at 4:17 am
In short, homework.
Here's how it's done. Think about each of the objects you've just defined. There's a school, a student and student grades. Now think about how those objects relate...
"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
December 17, 2013 at 3:34 am
And ditch the NOLOCK hint.
If the table has 100K of records, this looks like it's also returning over 100K of records. Is the WHERE clause not filtering at all?
"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
December 17, 2013 at 3:28 am
Viewing 15 posts - 9,241 through 9,255 (of 22,232 total)