Viewing 15 posts - 12,556 through 12,570 (of 22,224 total)
GilaMonster (5/16/2011)
Grant Fritchey (5/16/2011)
"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 16, 2011 at 2:13 pm
I don't know, we'll have to renogiate the rate now...
Here's a little query to just get you started:
SELECT bf.logical_name,bs.backup_finish_date
FROM dbo.backupfile AS bf
...
"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 16, 2011 at 2:10 pm
Jack Corbett (5/16/2011)
"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 16, 2011 at 1:47 pm
Yeah. That way you don't have to guess what the backup name 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 16, 2011 at 1:44 pm
You could use SSIS and schedule it from SQL Agent. You could use a PowerShell script and run that from SQL Agent. You could probably use a linked server 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
May 16, 2011 at 1:15 pm
Problem is, that includes the time too. No way to calculate that, you have to know it.
Do you have access to the server where the backups are being taken? 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 16, 2011 at 1:13 pm
You'll be able to make guesses on the table structures if, and only if, you have all dynamic TSQL. If they're calling stored procedures you will have absolutely no mechanism...
"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 16, 2011 at 12:05 pm
Ninja's_RGR'us (5/16/2011)
Ninja's_RGR'us (5/16/2011)
What's the advantage of setting the db or files to read_only?.. and which ones do you set ro?
Ya, but if the db only has selects running 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 16, 2011 at 8:42 am
GSquared (5/16/2011)
I went. There were a number of good presentations. Definitely worth the time spent and all that. Learned more than a little bit.
And I got 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
May 16, 2011 at 8:39 am
Gail said it. Read only not only means it doesn't take out locks, but it stops trying to. Changes the dynamic on queries considerably. Huge advantage for read only systems....
"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 16, 2011 at 8:38 am
One option to consider, SQL Server Central Management System[/url] from CodePlex. But better still, read through this section in Books Online. It should get you where you need to go.
"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 16, 2011 at 8:33 am
First off, if it is a reporting only system that gets a refresh at night or something, make it read only. That will radically improve your performance for the queries.
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
May 16, 2011 at 8:24 am
Are you using a custom script or is that a 3rd party backup routine?
Another thing that comes up are locked files on the server. These can be caused when a...
"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 16, 2011 at 7:31 am
Functions are a notorious TSQL bottleneck. Most of the time they are used incorrectly or written badly and the combination causes poor performance. This is especially true if you're working...
"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 16, 2011 at 7:29 am
Another thing you can do is pull the execution plans from the cache on the production systems you're working on. That way you can see what's happening in the production...
"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 16, 2011 at 7:11 am
Viewing 15 posts - 12,556 through 12,570 (of 22,224 total)