Viewing 15 posts - 14,416 through 14,430 (of 22,232 total)
No, it shouldn't. If you've got appropriate log backups in place, in general, the size of the log is how big it needs to be to suppor the transaction load...
"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
August 31, 2010 at 9:19 am
CirquedeSQLeil (8/31/2010)
homebrew01 (8/31/2010)
CirquedeSQLeil (8/31/2010)
Once you have re-grown the log - then defrag your indexes.
Does defragmenting indexes apply to shrinking log files as well as data files ?
In this case 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
August 31, 2010 at 9:09 am
Probably that's the original size of the log file. You can't shrink below the original file size (well, not without other work & stuff, just go with it). You'd need...
"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
August 31, 2010 at 8:17 am
9 Million tables?
I suspect that's the issue. I've never even heard of a database with that many tables. I'm not sure what kind of problems you can expect to see...
"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
August 31, 2010 at 7:35 am
I'm in agreement with Gail. Just because they're currently in a potentially dire position doesn't mean they wish to remain there. The best recommendation is to have them get together...
"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
August 31, 2010 at 7:26 am
Great googly moogly, it's the answers that are getting dangerous now... Yeah, let's put the production database to simple recovery... yikes!
"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
August 31, 2010 at 6:57 am
Ramji29 (8/31/2010)
Matt-1034261 (8/31/2010)
Ramji29 (8/31/2010)
GilaMonster (8/31/2010)
DB I used to work with had a 250GB log file. Make sure that you're maintaining it correctly and don't worry too much.
Thx Gail...
"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
August 31, 2010 at 6:55 am
Matt-1034261 (8/31/2010)
Grant Fritchey (8/31/2010)
"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
August 31, 2010 at 6:51 am
The think about backing up the drive is, SQL Server maintains locks on the files. They're not getting backed up. You'll need to create a backup process that creates 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
August 31, 2010 at 6:43 am
From the sounds of the system you describe, I think I would create a third table that is aggregated data of all the other information. You say that the reports...
"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
August 31, 2010 at 6:30 am
Are you also loading data when these scripts are run? By & large, a set of data definition language (DDL) scripts should run very quickly. Assuming no data being loaded...
"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
August 31, 2010 at 6:26 am
Frequently when the log is really big and no one is sure why, it's because the database is set to Full Recovery mode and there are no log backups running....
"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
August 31, 2010 at 6:21 am
Based on three questions in just a few minutes, are you in an interview?
"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
August 31, 2010 at 6:15 am
WayneS (8/30/2010)
For those that go to both this and the SQLPass summit (Steve, anyone else...) - which one has the better ROI? What are the differences?
My take on the two...
"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
August 30, 2010 at 7:07 pm
jcrawf02 (8/30/2010)
Grant Fritchey (8/30/2010)
"It was interesting"
"I liked it"
"Interesting"
"You just made me sit through 45 minutes of a slow zoom...
"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
August 30, 2010 at 12:29 pm
Viewing 15 posts - 14,416 through 14,430 (of 22,232 total)