Viewing 15 posts - 12,556 through 12,570 (of 22,219 total)
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
Jim Murphy (5/13/2011)
WayneS (5/13/2011)
My only regret was in not having more time to just sit around with all of them to chat and get to know them better.
I agree. 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 14, 2011 at 5:07 am
WayneS (5/13/2011)
Brandie Tarvin (5/13/2011)
Alvin Ramard (5/13/2011)
Had to laugh when Grant mentioned DBCC TimeWarp in a presentation. 😀Oh, you have to share. In what context did he mention it?
Oh, just in...
"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 13, 2011 at 7:02 am
That's a lot of questions at once.
My first suggestion, look at setting up a Central Management Server. This will allow you to take control of the other servers from 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 9, 2011 at 5:43 pm
It really depends on the size of the database and the rate of growth. I wouldn't get hung on specific numbers. If a database is growing very slowly, it can...
"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 9, 2011 at 5:36 pm
GSquared (5/9/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 9, 2011 at 5:22 pm
Viewing 15 posts - 12,556 through 12,570 (of 22,219 total)