Viewing 15 posts - 8,236 through 8,250 (of 22,232 total)
Yeah, not sure. Just following where the error messages lead.
"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
May 8, 2014 at 6:08 am
Complete agreement with what Gail is suggesting.
"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
May 8, 2014 at 6:07 am
arkiboys (5/8/2014)
as I send this text I have your book with me.
infact I carry your book in my bag every day as it is a useful book.
ok. I will...
"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
May 8, 2014 at 6:06 am
And all this advice just points out how difficult it is to provide a good answer to such vague & general questions.
I hope all this helps. You've received great pointers.
"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
May 8, 2014 at 6:03 am
Jonathan's advice here [/url]would still be completely applicable to virtual machines, whether they're running in the cloud or not.
"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
May 8, 2014 at 3:05 am
Last batch means the last time it was run, not the amount of time it's been running.
It's the checkpoint operation. That's a fundamental part of the process. It's actually what...
"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
May 7, 2014 at 2:46 pm
The time it takes really depends on the system you're installing it to, the stuff you choose to install, the size of your databases, a ton of stuff that 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
May 7, 2014 at 2:36 pm
Not sure about the encryption. I'm not sure why that would affect performance much at all (a little in the CPU I suppose).
As to figuring out how the server is...
"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
May 7, 2014 at 12:47 pm
Yes, you can upgrade from Standard to Enterprise. You just have to purchase an Enterprise license and then install the correct software.
"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
May 7, 2014 at 12:40 pm
That's an internal process. It's not the cause of your issue. I'd suggest you look for blocked or blocking processes or non-system processes. Also, generally, I don't suggest using sp_who...
"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
May 7, 2014 at 12:38 pm
What? On how to upgrade? You get the software for SQL Server and you start clicking Next, Next, Finish. Here's a Microsoft lesson plan that walks you through a lab...
"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
May 7, 2014 at 12:22 pm
Everything Gail said, plus, remember it does capture the values in microseconds. Just change the display to use those instead of milliseconds and you'll see fewer issues.
"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
May 7, 2014 at 12:19 pm
GilaMonster (5/7/2014)
That's SQL Crystal Ball Pro v12.1. Have to keep up with the versions and the Pro version comes with a command line.
And you've been denying for months that 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
May 7, 2014 at 12:18 pm
Can you upgrade 2008 to 2008R2? Yes, absolutely. There may be licensing costs involved. You'll need to contact Microsoft to see what the situation with your license may be.
"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
May 7, 2014 at 10:17 am
Well, if you want to use this generated job you'll need to get SSIS on 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
May 7, 2014 at 7:53 am
Viewing 15 posts - 8,236 through 8,250 (of 22,232 total)