CODEWITHSUNDEEP
monitoringsqlanywhere
Calvin Allen
Calvin Allen

Reputation: 4248

Sybase SQL Anywhere Database Management Tools

What tools can I use to monitor performance, defragment, etc. a Sybase SQL Anywhere database?

Upvotes: 1

Views: 6600

Answers (3)

Dan
Dan

Reputation: 836

If you're looking for more of a health and availability monitoring tool, you might also want to look at the SQL Anywhere Monitor, introduced in version 11.0.1.

(Full disclosure: Like Graeme, I also work for Sybase in SQL Anywhere engineering)

Upvotes: 0

Vincent Buck
Vincent Buck

Reputation: 17132

Look at Breck Carter's Foxhound. It was built specifically for SQL Anywhere. I'm not sure it supports version 11, but as Graeme said there are built-in monitoring tools for that version.

If file fragmentation is an issue, my experience with dbunload is that the rebuilt database files will also be fragmented to some extent. What you can do is stop the database server and run Sysinternal's contig against the .db and .log files.

Upvotes: 0

Graeme Perrow
Graeme Perrow

Reputation: 57248

To defragment a SQL Anywhere database, you need to rebuild it. Look in the docs for the dbunload -an switch.

As for performance monitoring, in version 11.x, the Sybase Central Performance Monitor was introduced.

Full disclosure: I work for Sybase in SQL Anywhere engineering.

Upvotes: 1

Related Questions