database monitoring

[Abhishek Mathur]

Hi,

Is there any way to monitor our cloud sql instance? Keeping the tab over database performrance would be a great help in comparing it with the local counterparts.  Monitoring helps in clearly visualizing the big picture and encourage decision makers to take a leap to cloud with rdbms.

Thanks,
Abhishek

[Brian Duff]

What kinds of metrics are you interested in monitoring?

Thanks,

Brian

[Abhishek Mathur]

The usual ones- Connection and user count, connection time, query execution time,response time,buffer gets,disk reads, and the like.

--Abhishek

[Brian Duff]

Hi Abhishek,

Some questions inline below.

Thanks,

Brian

On Mon, Nov 14, 2011 at 11:23 AM, Abhishek Mathur <abhi...@moruba.com> wrote:

The usual ones- Connection and user count,

This would be the # of open connections, and the number of unique connected users over time?

 

connection time,

Avg. time for a connection to be established?

 

query execution time,

It seems like this would vary a lot by query. Would this be useful if it were for all queries, or would you want to specify which queries to get stats for?

 

response time,

 

 

buffer gets,

Can you explain this further?

[Abhishek Mathur]

Hi Brian,

Its a yes for first two of your questions. It would be great if query execution time could be   monitored for a particular query.
By buffer gets I ment the use of internal data buffer cache in memory to avoid frequent disk access.
There are some monitoring tools our DBA use to keep an eye on DB health n performance. Our application, like all the major business applications, is highly database driven and we want it to perform even better over cloud sql. So I was wishing for some kinda monetoring and performance enhancing tool for cloud sql as well.

Thanks,