Viewing 15 posts - 6,271 through 6,285 (of 22,221 total)
I would absolutely advocate for using the mathematical calculations supplied by Microsoft in the link above. But, for a ballpark guess when doing initial evaluations, 3-5 times the data 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
April 20, 2015 at 9:18 am
SQLRNNR (4/19/2015)
Eirikur Eiriksson (4/19/2015)
Grant Fritchey (4/19/2015)
Eirikur Eiriksson (4/19/2015)
spaghettidba (4/19/2015)
"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
April 20, 2015 at 6:30 am
Eirikur Eiriksson (4/19/2015)
spaghettidba (4/19/2015)
Did I say...
"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
April 19, 2015 at 3:43 am
When querying the wait stats, the real key is going to be getting them before and after the backup to understand where and why things are running slow. Also, 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
April 17, 2015 at 9:59 am
I really dislike the native intellisense, so...
I haven't seen major slow downs, but, make sure you have the latest SP and maybe the latest CU installed on top of your...
"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
April 17, 2015 at 8:57 am
It actually might be easier to just use T-SQL rather than the GUI. It's much more straight forward to RESTORE:
RESTORE DATABASE 'ANewName'
FROM DISK = 'e:\backups\myotherdb.bak'
WITH MOVE 'logicaldataname' to 'd:\data\anewname.mdf',
MOVE 'logicallogname'...
"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
April 17, 2015 at 8:52 am
Favorite answer, it depends.
Check the execution plan. It might do TOP on its own. In which case, ignore me. But if it's doing aggregate functions there, modifying it could 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
April 17, 2015 at 7:23 am
Instead of MAX, try a TOP 1 with an ORDER BY.
"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
April 17, 2015 at 7:13 am
There isn't. If the backup is corrupted, it's gone.
go to the last good backup and then use your log backups to restore back to where you need 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
April 17, 2015 at 7:11 am
One setting I'd change immediately is the Cost Threshold for Parallelism. You have it at the default of 5. Change that to a reasonable number. You can look at your...
"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
April 17, 2015 at 7:07 am
ShuaibV (4/16/2015)
Can we do this in Redgate SQL Compare 8? We have the older version.Thanks
I'm not sure. You do the compare then go to Tools, Generate Report and look...
"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
April 16, 2015 at 8:47 pm
Redgate SQL Compare[/url] can do that and then export to XML for Excel. It can also export to HTML and a few other formats.
DISCLAIMER: I work for Redgate.
"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
April 16, 2015 at 3:34 pm
No, there's still no Best Practices Advisor for 2014. There is the 2014 Upgrade Advisor though. That will help you through the upgrade process.
"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
April 16, 2015 at 3:23 pm
There's no read/write on the secondaries. Not yet anyway. That's basically merge replication.
"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
April 16, 2015 at 3:21 pm
If the PK is the single most accessed path to the data, yeah, I agree, it should be clustered, testing or not. Although, I prefer testing and advocate for 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
April 16, 2015 at 3:16 pm
Viewing 15 posts - 6,271 through 6,285 (of 22,221 total)