Answer / dataarchitect

1. Compression levels are used during either full or log
backups.
2. O is lowest compression level while 9 is highest
compression level
3. Just keep in mind while deciding about compression level
higher compression level will cause max. cpu utilization
and may affect performanc of syste, especially for big db.
4. ASE 15** comes up with new compression levels i.e. 100
and 101 . sybase claims that these are fastes and use less
cpu...

Answer / dilip voora

Compression level 0 indicates no compression and 9 indicates the highest level of compression. From ASE 15.x two more compression levels 100 and 101 are added. Compression level 100 provides faster compression where as the compression level 101 indicates better compression. 100 and 101 will not create much load on CPU.

How do I tell which tables have identities in sybase?

0 Answers  

---

How to remove row affected and dashes?

0 Answers  

---

Explain about the features of sybase iq?

0 Answers  

---

What does –i option do in sybase tools?

0 Answers  

---

How do I open sybase control center?

0 Answers  

---

---

Explain the role of replication server in sybase.

0 Answers  

---

How would you lock a table in sybase? What text command will you use for it?

0 Answers  

---

Explain the structure of adaptive server enterprise?

0 Answers  

---

How can I improve throughput in sybase?

0 Answers  

---

What is the difference between 'dump tran database to physical name' 'dump tran database with truncate_only' and dump tran database with no_log'and in real time when we go to truncate the log?

0 Answers  

---

What do you mean by deferred update in sybase?

0 Answers  

---

What is raid and sybase?

0 Answers  

---