Do we have script where i can populate the Defrag results in a table and run defrag based on condition. For e.g. I dont have window where i can...

Yes Its a non clustered index.How can we avoid to increase the log growth.However, log backup is scheduled to run every 10 mins.

Thanks

Log growth happening during the maintenance window.Probabily new indexes or new addition of data. Question i have is we are running out of disk space.I need to request for additional...

I read the nice artice and thanks for sharing that.However, i am not able to decide the additional disk space i should ask for keeping in mind the log grwoth?...

Thanks! Any more suggestions?

Thanks for the Information!

We don’t have down time window. Since I have to do online operations only, I cannot opt for Rebuild or Rebuild online(Since it takes more Log space where we have...

So the recommended values for reorganize index is page_count_num > 1000 and Index Frag > 30?

Thanks,

Recovery model is FULL and Log backup happens every 15mins.

Let me know if you need more details

Thanks

Is there a way to find the cause of transaction log size growth?

Let me know if its still unclear?

Thanks

Enterprise Edition (64-bit)10.50.1777.0RTM

give me your email id i can send to you..

Thanks

Do you know any chance in sybase database to look for row level locking?

Thanks

But you can still do without STOPAT clause right?

Then why to add key word STOPAT?

Thanks

Is this with native backup? Where you backing up,means backup server or same server?

Thanks

column 1 is population into different columns instead of one column?