Originally posted by sspruthi
we are having a tempdb of 200 MB size on 2 different db devices with data and log on same devices. Our prodn database size is around 6 GB.I am facing problem of transaction log full quite often and we are not even able to dump tran(including no_log option) to free up space in tran log and at that time we cant execute a single command.
tempdb size is quite less and infact we are planning to make it to 500MB..as we cant go beyond that due to some constraints...will that help the cause or do we need to put a separate logdevice for tempdb..and if yes..what size it should be..??
I am quite a beginner in sybase so can u plz tell me how to solve this issue....
U shud clarify u r currnent Sybase setup here. Certainly u can increase tempdb size to 500 MB also separate Data and Log also. This certainly increase the performance.