How to monitor SQL performance?

Hi,

How can I monitor the SQL performance on my website, hosted at discountasp.net ? (slow query, CPU usage...)

Most reports on MS SQL server management studio don't execute due to insufficient privilege for the user. Same think for a SQL request I used to track the slowest queries ("The user does not have permission to perform this action.")

Regards,
Christian

 

so ?

Hi Bruce,

I've noticed you've blocked that, that's the reason of my question.
How can I do it ?

Christian

 

You can't.

Not yet anyway. We have discussed making CPU usage available but there are a number of roadblocks to doing that. Monitoring of any kind - web or SQL - is very resource intensive, so you can see the problem if hundreds of people decide to monitor sites on the same server. Everything would kind of...stop.

 

Hi,

Just to make sure (I think the term "Monitor" I used was not the good one).
I don't want to be notified of slow queries or CPU usage going above a threshold, but I would like to be able to run a query manually, once a while, which would give me the requests executed, average time consumed per request and so on...
Not possible neither ?

Christian