What tools can I use to monitor performance, defragment, etc. a Sybase SQL Anywhere database?
+1
A:
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.
Graeme Perrow
2009-09-29 23:19:49
A:
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.
Vincent Buck
2009-09-30 17:14:51
Sadly, Beta 9 of Foxhound is closed, and Beta 10 won't be starting until next year... BUT, Foxhound is in active development and planned for GA release after Beta 10.
Breck Carter
2009-11-18 09:33:31
A:
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)
Dan
2009-10-09 19:54:26
A:
Also you can look at Performance and Tuning Series: Monitoring Adaptive Server with sp_sysmon in pdf. This can help too.
Aykut
2009-10-14 05:50:09
The question was about SQL Anywhere, which is a completely different product from Adaptive Server.
Breck Carter
2009-11-18 09:29:20