Viewing 15 posts - 1 through 15 (of 41 total)
Well, I'm pretty sure ours is full of extra junk. 🙂 tons of auditing and audits of the auditing... goes on and on. It's a good thing disk...
August 3, 2012 at 9:39 am
Main Production DB is around 3 TB, current growth rate is roughly 1 TB / year.
Total 7 copies.
We keep 5 copies online (prod, qas, dev, train, sandbox), a SAN-level mirror,...
August 3, 2012 at 9:03 am
SELECT 1-(compressed_backup_size/backup_size) FROM msdb..backupset
April 9, 2012 at 9:13 am
Once the configuration wizard is run and SMSQL knows where all your datafiles, filegroups, etc are distributed on whatever volume they're on, I believe SMSQL will stop all IO for...
September 22, 2011 at 1:05 pm
We've been using this for about a year, and I think we have more luck with the product. We're using it for backup/restores naturally, but also take advantage of...
August 25, 2011 at 12:40 pm
It seems at first that this would be counter-productive, it could be log-shipped to separate disk, yes? You'd still have some shared resources (uh, the instance), but maybe it's...
June 8, 2011 at 7:13 am
Our biggest are a couple SAP BW systems (Production, Quality). With 64 GB each.
March 15, 2011 at 9:45 am
Awesome, Gail, thanks a ton.
Do you have the same screenshot for the last two query plans? They both look exactly the same and say they're query 1. But...
January 14, 2011 at 12:05 pm
SanDroid (12/10/2010)
GilaMonster (12/10/2010)
December 10, 2010 at 1:03 pm
GilaMonster (12/10/2010)
Log files don't have indexes, they don't have pages that can get shuffled around, they don't have fragmentation. The architecture of the log file is quite different from the...
December 10, 2010 at 12:50 pm
SanDroid (12/10/2010)
pjdiller (12/10/2010)
SanDroid (12/10/2010)
pjdiller (12/10/2010)
Yes? I didn't say it'll throw an error, just that it's ignored. It's the same as running
DBCC SHRINKFILE (N'my DB logfile' , 0)
Ultimately, my question is...
December 10, 2010 at 11:50 am
SanDroid (12/10/2010)
pjdiller (12/10/2010)
Yes? I didn't say it'll throw an error, just that it's ignored. It's the same as running
DBCC SHRINKFILE (N'my DB logfile' , 0)
Ultimately, my question is whether that...
December 10, 2010 at 9:55 am
Yes? I didn't say it'll throw an error, just that it's ignored. It's the same as running
DBCC SHRINKFILE (N'my DB logfile' , 0)
Ultimately, my question is whether that is evil.
December 10, 2010 at 9:36 am
Viewing 15 posts - 1 through 15 (of 41 total)