Viewing 15 posts - 376 through 390 (of 469 total)
Milu (10/23/2008)
My Problem Here is After running this MY DB performance increase but my log file is Increasing as leading to degrade my performance...
What I wants, is to run...
October 23, 2008 at 12:53 pm
Do not run DBCC SHRINKDATABASE on a PRODUCTION database :w00t:, especially when it is ONLINE.
Do a dbcc update_statistics(fullscan)
Cleaning PROC Cache calls for more compilation time, thereby slowing things down.
One thing...
October 23, 2008 at 12:48 pm
Why is the T-Log failing?? :unsure:
October 23, 2008 at 12:36 pm
Is the table accessible?
Why not run this query from the query analyzer and check for the results, if not run a profiler trace while this script is being executed..there are...
October 23, 2008 at 12:12 pm
Cant you change the RECOVERY MODEL TO BULK LOGGED, and then do the updates. If in Full recovery model, no matter how many T_log backups you take it does not...
October 23, 2008 at 11:30 am
As a rule of thumb, the indexes need to be re-organised when the fragmentation(logical scan) is higher tha 10% and the Rebuild is done when the fragmentation is greater than...
October 21, 2008 at 2:10 pm
1.Run the log backup only after you run a full backup
2.Why the log size is increasing??
If the Db is active with many DML's then the log would increase certainly.
If this...
October 21, 2008 at 2:00 pm
Do not post a new topic, you could just put a new reply as an updated script you need to be helped out with..my version is same again
OSQL.EXE /n /S...
October 21, 2008 at 1:55 pm
OSQL.EXE /n /S "servername" /E /dDBName /i "input script path" /o "output file path
Hope this helps
Thanks!!!
October 21, 2008 at 1:49 pm
In my case I see most of the tables have a high Extent fragmentation.
Now, my guess is Logical Fragmentation is what we fix with re-indexing.
I am back to...
October 17, 2008 at 1:04 pm
Gordon (10/16/2008)
And how often do you test recovering from those tapes? Nothings worse than going to tape and finding bad or unusable tape....
Well, for me there was never a...
October 17, 2008 at 12:47 pm
use lock hints and also see if the timeout setting is too low. We ran into this problem where my DB timeout setting was infinite but the application timeout in...
October 16, 2008 at 11:53 am
Well I wouldn't need to do point in time restore as I am reIndexing while in the maitenance window.Also it would be started after the full backup is taken.Does this...
October 16, 2008 at 10:41 am
Viewing 15 posts - 376 through 390 (of 469 total)