Home > Archive > SQL Anywhere database > July 2005 > Troubleshooting production problems









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Troubleshooting production problems
David Tawil

2005-07-22, 8:23 pm

We are using ASA9 and have 120 users and a 5GB database. There are
times when the database performance is slow and cpu usage is pegged at
100% on the server.

Are there any tools in ASA that will allow us to see which sql
statements or stored procedures are running while the performance is
slow?

Thanks
Dave

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com