Viewing 15 posts - 8,221 through 8,235 (of 22,219 total)
My suggestion would be to examine the execution plans for your queries before and after you apply your index. Just because the DTA suggested it, doesn't mean it's a good...
"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 10:30 am
shahgols (5/7/2014)
... the execution plan cost is down 2/3...
Which is a meaningless measure. The costs within execution plans are only applicable within themselves. I would never compare execution plan cost...
"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:10 am
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
Viewing 15 posts - 8,221 through 8,235 (of 22,219 total)