Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 3 down vote favorite
1

I'm doing a lot of work with SQL Azure at the moment, trying to improve performance of a web app. I am using the dm_exec_query_stats view to look for poor performing queries.

Does anyone know a way to clear the query stats in Azure? DBCC FREEPROCCACHE isn't supported. I can use sp_recompile 'procedure' to clear stored procedures/functions etc, but the site uses some LINQ-generated queries which can't be cleared in this manner.

share|improve this question
DBCC FREEPROCCACHE is almost never the right answer. A bad band-aid. If you are looking to clear stored procedures/triggers, you can call sp_recompile 'yourTableName' to mark all procs/triggers for recompile that have yourTableName in the definition. – Thomas Stringer Apr 12 '12 at 1:00

migrated from stackoverflow.com Dec 13 '11 at 20:14

1 Answer

up vote 2 down vote

You probably can't as the procedure cache is shared across all the databases which are hosed on the server that your database is hosted on. All you can do it wait for the old queries to be flushed from cache using normal aging out that the procedure cache uses.

Forcing a recompile of the table objects would probably do the trick as well.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.