How to restore the database on new host ? please share video on it
@howtostepbystep37568 ай бұрын
For new host you need to do scp..or sftp from source to destination (copy backup files ) use master go load database db_name from "/backup/drive/db_name1.dmp" stripe on "/backup/drive/db_name2.dmp" stripe on "/backup/drive/db_name3.dmp" stripe on "/backup/drive/db_name4.dmp" stripe on "/backup/drive/db_name5.dmp" go
@arneywillett4198 Жыл бұрын
"promosm"
@saikrishna257 Жыл бұрын
Can you show how we can slove the query slowness and server slow issues in sybase ase
@howtostepbystep3756 Жыл бұрын
Hi SaiKrishna.. Answer is not generic but it can planned and implemented in stepwise 1)Find what are process are running during the timestamp when you have slowness isssue 2) get the process details , find its sql text ,showplan you can do it by running enabling shell script in cron job sp_monitor and. capture all details 3) you need to check what re all tables are present while running these queries check query plan what kind of scanning are happening in table 4) find those tables check sp_spaceused table_name 5)check when was last time maintenance was performed 6) check CPU and memory utilization you can take help and get report from unix. this is very generic strategy based on this result we can take action..
@GaneshKumar-212 Жыл бұрын
Can you make more videos on Sybase dba please
@howtostepbystep3756 Жыл бұрын
Hello @GaneshKumar-212 sure can you help to share list of topics that you want me to create videos I am happy share content around it.
@GaneshKumar-212 Жыл бұрын
Is any website for this?for dba
@howtostepbystep37568 ай бұрын
no wesbite hence created video based on experience